how to import a backup / migratated database. (step 5 of migration FAQ)
|Posted: Tue, 2010-12-07 09:40|
I am trying to move a g2 installation to another server and am following the instructions from http://codex.gallery2.org/Gallery2:FAQ#How_can_I_move_my_gallery_installation_from_one_server_to_another.3F
I am however getting stuck at step 5
1 Backup your installation!
2 Upgrade G2 on the old server to the same G2 version which you plan to install on the new server.
3 Deactivate AND uninstall the url rewrite module if it is active because it will generate incorrect urls after your move.
4 Backup G2 on your old host. Backup the database and the g2data folder.
I don't understand the difference with step 1, but I have made with phpadmin a backup to a non-compressed file and to a zip file, according to http://codex.gallery2.org/Gallery2:How_do_I_Make_Backups_of_My_Database. Furthermore, I have made a backup of the g2data folder.
5 Copy the g2data folder and import the mysql database to your new host. You can skip copying the g2data/locks directory if you want.
I have FPT'ed g2data and the two database exports to the new server.
Is there a FAQ or post explaining how to exactly import the files? I have searched, but could not find anything. In myphpadmin I get the following error if I try to upload the non-compressed file (with utf8)
I do have another g2 running on the server. Is this causing the problems? I can delete this one, but prefer to get a new g2 running, do an import, and then delete the other g2.