how to import a backup / migratated database. (step 5 of migration FAQ)
|
bobob
Joined: 2003-07-12
Posts: 110 |
Posted: Tue, 2010-12-07 09:40
|
|
Hi 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 Quote:
1 Backup your installation! done. Quote:
2 Upgrade G2 on the old server to the same G2 version which you plan to install on the new server. done Quote:
3 Deactivate AND uninstall the url rewrite module if it is active because it will generate incorrect urls after your move. done Quote:
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. Quote:
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) Quote:
Error 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. |
|
Posts: 16504
Here's a good explanation on using phpMyAdmin to restore:
http://codex.wordpress.org/Restoring_Your_Database_From_Backup
____________________________________________
Like Gallery? Like the support? Donate now!
Posts: 110
thanks. That worked. Kind off...
I didn't have an option to upload the SQL file, but could copy-paste all the SQL commands in the command line text box, as mentioned in http://www.tamba2.org.uk/wordpress/restore/. There was no create db command, so I guess I could just enter all the commands.
After this, I ran the script to convert the lowercase to uppercase characters (the db export is from a windows machine. the import a linux machine).
I ran gallery2/install, pointed to the transfered g2data (which was chmodded 777 recursively) and the newly created db where I imported the tables into. The wizard run the first time when it run into a error during the step of installing corde module. I believe it mentioned "rmdir g2data\deriviate is not empty". After running it one more time, it finished all the steps succesfully.
After a completed installation, all the thumnails are broken / missing. Not a big deal. I thought I could login as admin and rebuild all the thumbnails. However, when I try to login i get the error:
Now I am stuck. I cannot login, repair, or switch on debug mode. Any ideas?
BTW, I do have other instance of gallery2 running on the server. I renamed this one however to public_html\gallery2old, it uses a seperate database and a seperate g2data folder. I am hoping this is not intereffering with this new install of gallery into which I am trying to import the database tables/g2data that came from another server.