WordPress.org

1. mtp1032
   Member
   Posted 11 months ago #
   

   So, I upgraded my Windows 7 system to a 64-bit machine. Prior to the upgrade, I made a full backup of my WP site. Part of the backup was to use phpMyAdmin to export the DB to a file on a removable disk.

   I then switched to the new computer, installed WAMP-64, and then attempted to restore the WP database previously exported with phpMyAdmin (above). The restore fails giving me error #1064 (syntax error).

   I'm distressed because the same version of phpMyAdmin and mysql are identical on the old and new systems. I've tried dumping and restoring from the commandline as well and it still doesn't work.

   What am I missing, here?

   Any help would be deeply appreciated.

   Michael

2. Seacoast Web Design
   Member
   Posted 11 months ago #
   

   Use the 32 bit version as your server is not 64 bit?

3. mtp1032
   Member
   Posted 11 months ago #
   

   Thanks for the quick reply, alas I've tried all that. Specifically, I've attempted the restore using the following 4 scenerios (among others):

   NOTE: In all cases the versions of MySQL are identical on both machines (as are the phpMyAdmin version)

   1) sqldump from old 32-bit machine, restore on new 64-bit machine using MySQL in WAMP-64 -- FAIL

   2) phpMyAdmin db export from old 32-machine then phpMyAdmin import using MySQL in WAMP-64 -- FAIL

   3) sqldump from old 32-bit machine, restore on new 64-bit machine using MySQL in WAMP-32 -- FAIL
   4) phpMyAdmin db export from old 32-machine then phpMyAdmin import using MySQL in WAMP-32 -- FAIL

   I'm at my wit's end...

   Michael

4. Seacoast Web Design
   Member
   Posted 11 months ago #
   

   #4:

   4) phpMyAdmin db export from old 32-machine then phpMyAdmin import using MySQL in WAMP-32 -- FAIL

   to me, it says you are not getting a proper export.

5. Jan Dembowski
   Volunteer Mod. & Brute Squad
   Posted 11 months ago #
   

   Fails and displays what error message exactly?

   And are you backing and restoring using one of these methods?

   http://codex.wordpress.org/Backing_Up_Your_Database
   http://codex.wordpress.org/Restoring_Your_Database_From_Backup

Reply

You must log in to post.