WordPress.org

1. DaveyDreamnation
   Member
   Posted 5 years 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

2. Samuel B
   moderator
   Posted 5 years ago #

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

3. DaveyDreamnation
   Member
   Posted 5 years 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 ...

4. Samuel B
   moderator
   Posted 5 years 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

5. DaveyDreamnation
   Member
   Posted 5 years 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

6. DaveyDreamnation
   Member
   Posted 5 years 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

7. FuzzyDogSlayer
   Member
   Posted 5 years 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)

Topic Closed

This topic has been closed to new replies.