The free forums are no longer in use. It remains available as read-only archive.
Log In
Home
1:29 am
March 19, 2012
Offline
I am new to xcloner, and am trying to migrate a 2.5.8 version of my 1.5.26 site from staging.certifiedinfosec.com to http://www.certiifie.....nfosec.com. The file restore worked great. The database restore is crawling. It's only completed 59.48% after 9.5 hours. I created a fresh empty database for the restore, and I know the restoration is connecting since I can see database tables show up in phpMyAdmin. What is taking so long? It's about a 18MB comrpessed backup that takes about 10 minutes to restore using cPanel backup.
What is going on?
Ideas?
11:52 am
September 26, 2010
Offline
Try importing the database backup directly through phpmyadmin and see if that helps, file is located in administrator/backups/database-sql.sql
The restore speed depends very much on the mysql server connection as well as general server speed and number of queries to be executed...
12:35 pm
March 19, 2012
Offline
I woke up this morning to find that Firefox was locked up at about 82% restore. The restore crashed.
I am hosting on a commercial-grade Hostgator VPS with PHP1200MB allocated memory (out of 1368 available). MySQL version 5.1.66-cll. I am now restarting the restore with a base backup set that does not include my learning management system installation, which cuts the DB backup down to about 1/3 of the size.
MyphpAdmin doesn't want to cooperate with the import of the exported DB. I suspect size is the issue. Not sure since POST limit is set to 800 MB.
I will re-install the LMS on restored site if all goes well. The 2nd tar file is about 30% transfered at this point.
I have wiped all tables from the target DB in preparation for the restore so there will not be any table conflicts over over-writes necessary.
My server suports exec and tar. When I restore the files, can I opt for tar restore without messing up file permissions? Any special DB settings you recommend?
Thanks,
Allen
9:01 am
September 26, 2010
Offline
Yes, you can opt for the tar server support, permissions should be restored to their original state as on the old site! As for DB settings, default permissions for read/write of the mysql user should be enough...
Ovidiu
All RSS1 Guest(s)
