Migrate a MySQL Database Preserving Special Characters

TomSlick writes "Michael Chu's blog provides a good solution for people migrating their MySQL databases and finding that special characters (like smart quotes) get mangled. He presents two practical solutions to migrating the database properly."

Pffft Easy...

[Frogbert]

First you get the names of every table in the old database

Then you create these tables in the new one. Just so there are no problems with data types you should probably just make every field varchar(100) in the new one.

Then you fire up MS Access, the older the better. I try to stick to Access 95.

Then you create two ODBC links, one to your old one and one to the new one.

Then you use the linked table manager to link each table to ms access.

Then you open both the new table and the old table and select all, copy and paste the data into the new table.

It's so simple even a child could do it!

Re:How is this news?

[kestasjk]

If there's a chance of starting a PostgreSQL vs MySQL flamewar, it's news.

Re:Pffft Easy...

[Negatyfus]

Linux doesn't use databases. Flat text files and grep work just as well as this overly complicated "SQL" crap.

Re:Pffft Easy...

[Jacco de Leeuw]

So very simple,
that only a child can do it!

Re:smart quotes? more like stupid fucked up quotes

[frisket]

Real IT professionals don't use Outlook.

Re:Tagged slashdigg

[Anonymous Coward]

No, it's "The Top 10 Photoshop Filters for Ron Paul!"