Database migration
Added by Anonymous almost 20 years ago
Hi Everyone and especially Denis,
I have been trying to migrate my leginon database over to another machine with mysqldump and I have been getting syntax errors when I try and load the sql file into the database on the new machine.
The mysql versions are slightly different on the new machine. Old is 4.0.21-4 , and new is 4.0.21-4.2.
Do you guys have an easy way of doing this?
Thanks,
Jonny
Replies (1)
Database Migration - Added by Anonymous almost 20 years ago
I think I am going to post my own reply...
I am not sure why the mysqldump didn't work, but I ended up using the export database option in phpMyAdmin. That didn't work initially and gave errors of max_allowed_packet was too large. So, I checked the extended inserts option in the export options in phpMyAdmin, that reduced the .sql size considerably and allowed me to import the database with the source command at the mysql prompt. I think everything is working fine now...
Jonny