Slashdot Mirror

← Back to Stories (view on slashdot.org)

Migrate a MySQL Database Preserving Special Characters

Posted by kdawson on from the encoding-juju dept.

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."

6 of 98 comments (clear)

  1. Pffft Easy... by Frogbert · · Score: 4, Funny

    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!

    1. Re:Pffft Easy... by Negatyfus · · Score: 4, Funny

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

    2. Re:Pffft Easy... by Jacco+de+Leeuw · · Score: 2, Funny

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

      --
      -------
      Warning: Slashdot may contain traces of nuts.
  2. Re:How is this news? by kestasjk · · Score: 5, Funny

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

    --
    // MD_Update(&m,buf,j);
  3. Re:smart quotes? more like stupid fucked up quotes by frisket · · Score: 2, Funny

    Real IT professionals don't use Outlook.

  4. Re:Tagged slashdigg by Anonymous Coward · · Score: 1, Funny

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