MySQL database import error – #1064

  • Resolved daveydreamnation

    (@daveydreamnation)


    19 years, 2 months ago

    Hi, I’m trying to use PhPMyadmin to move a database exported from an older version of WP to a new one on a different host. The old database also contained some posts exported from MT – so the export file I’m trying to import is giving me the following message:

    SQL query:
    #
    # Data contents of table mt_author
    #
    INSERT INTO mt_author
    VALUES (…)

    MySQL said:
    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ ”, ‘en-us’)’ at line 1

    I’m not sure what to do, as I can’t seem to open the whole export file in a text editor (I’m getting a diagnostic message that says the file is corrupt every time I try and unzip it, and a lot of the data seems to be missing), although some database tables seem to have been created – eg wpposts etc … So I seem to have data there, but the import process is being tripped up by the error message. Is there some way I can skip that row of the table (ie the ‘mt_author’) and continue with the import?

    I have no idea about MySQL or PhpAdmin, whatsoever, just learning this on the run 😉 – I’ve searched the forums but can’t seem to find an answer to this specific question … can anyone help?

    Thanks in advance,

    D

Viewing 6 replies - 1 through 6 (of 6 total)
  • Samuel B

    (@samboll)

    19 years, 2 months ago

    You are getting that error because the mt_author table does not exist.
    If you’re not good with phpmyadmin…

    Thread Starter daveydreamnation

    (@daveydreamnation)

    19 years, 2 months ago

    Thanks for the reply – it’s certainly correct that I’m not good with phpmyadmin … 😉

    I’m assuming I need to delete the reference to mt_author from the sql file – but I can’t seem to extract the whole file from the zipped export file …

    Any suggestions? Thanks again …

    Samuel B

    (@samboll)

    19 years, 2 months ago

    I would download this plugin:
    http://www.silpstream.com/blog/wp-phpmyadmin/
    Then you can work with phpmyadmin through your WP interface.

    Read more about phpmyadmin here:
    http://wiki.cihar.com/pma/Welcome_to_phpMyAdmin_Wiki

    Thread Starter daveydreamnation

    (@daveydreamnation)

    19 years, 2 months ago

    Thanks –

    I will give those two a go, and if I end up figuring it out, will post again to this thread.

    Greatly appreciate your help!

    D

    Thread Starter daveydreamnation

    (@daveydreamnation)

    19 years, 2 months ago

    Just thought I’d post again to say how I figured this out, in case anyone else has a similar problem …

    All I had to do in the end was drop the mt_author row from the table created by the import – the rest of the rows (wpposts etc) had already uploaded and I didn’t need any of the MT data anyway. For some reason when I exported from my old version of WP, it had also exported all of my MT posts (which I thougth were saved in another database but must have been in the same one …)

    Anyway, once I deleted the mt rows, I went back to my WP login screen, which told me my database was out of date, which was easy to fix – I then had to try and log in again, which required me to request my password again, for some reason …

    All of which is a long-winded and probably useless way of saying it finally worked. But maybe it will help someone, some day …

    D

    fuzzydogslayer

    (@fuzzydogslayer)

    19 years, 1 month ago

    I seem to be getting the same #1064 error.
    It occurs after I’ve created a new database and then proceed to import an sql dump, how would I go about resolving that?

    Any help would be greatly apprieciated.(sp)

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

The topic ‘MySQL database import error – #1064’ is closed to new replies.