MySQL importion error

  • Hi,

    When I export my WordPress’ database from my old host and try to import it with at my new host, I get the following error message:

    CREATE DATABASE generic_name COLLATE latin1_general_ci;

    MySQL said:

    #1064 – You have an error in your MySQL syntax. Check the manual that correspond with your MySQL server version for the right syntax to use near ‘COLLATE latin1_general_ci’ at line 1

    I have tried to import both from myPhpAdmin and from the default backup utility that came with WordPress 2. Both database exports gave the same error.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Getting a 1064 error upon import is often due to a MySQL version mismatch of some sort. I recommend, if you can, creating the database manually through whatever tools your new host provides. Then remove the CREATE DATABASE line from your sqldump file.

    Thread Starter aleksandersen

    (@aleksandersen)

    I have access to phpMyAdmin, but I seriously cannot figure out what to put in which field in that tool. There appear to be so many tables too! :S

    Can someone please help with this?

    Thread Starter aleksandersen

    (@aleksandersen)

    I exported a WordPress/mySQL database created at GoDaddy and it imported back into another database at GoDaddy just fine. But the one I try to import, which where created on my old host’s server, will not be imported no matter what I do!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MySQL importion error’ is closed to new replies.