The free forums are no longer in use. It remains available as read-only archive.
Log In
Home
11:13 am
October 5, 2012
Offline
Hello,
Today I realised the hard way that my xcloner MySQL database backups are useless for some reason that I fail to understand.
If I backup the exact same database using phpMyAdmin, the restore process takes 2~3 seconds for the whole database.
When I try to restore using the xCloner backup, it takes on forever and phpMyAdmin is constantly interrupting the import process after 5 minutes. Clearly that there is something wrong with the way my Xcloner SQL backups are generated, but that still doesn't get me closer to understanding how I can fix this. Any tips are welcome.
Thanks in advance.
12:06 pm
September 26, 2010
Offline
XCloner backups up the mysql data inside the administrator/backups/database-sql.sql file inside the created backup archive, try and import that and see if it helps.
2:45 pm
October 5, 2012
Offline
3:14 pm
September 26, 2010
Offline
Yes, i understand now, if you support mysqldump utility on your server, try and activate it and rerun th Backup Process, the mysqldump should be more compressed. Otherwise, you always have the option to restore the mysql backup only by using XCloner, simply upload the file in the administrator/backups folder and start XCloner.php restore process with "Skip files restore" option checked.
4:06 pm
October 5, 2012
Offline
What you said above is the definite solution for my issue!
On one hand, using the XCloner "clone" function allows me to have a real-time notion of the database restore process, I did not use it before but it's a great feature. On the other hand, using mysqldump has created a database dump exactly like the ones phpMyAdmin does. It now takes the same ~15sec. to restore the database through phpMyAdmin.
Everything is working perfectly now, thank you again! 
4:21 pm
October 5, 2012
Offline
Sorry but I have one further question. I did not find info on this in any XCloner documentation, wiki or forum.
It is possible to use some switches along mysqldump, but those switches are not from mysqldump itself:
–quote-names
–quick
–single-transaction
–skip-comments
Can you explain to me what each of these switches do? If this info is published elsewhere, please link it here.
Thank you!
6:11 pm
September 26, 2010
Offline
Yes, you can use those switches, the mysqldump usage manual is here http://dev.mysql.com.....ldump.html
6:51 pm
October 5, 2012
Offline
I did not find any association between those switches and mysqldump in a quick Google search, that's why I assumed they were customized and asked for it. I will definitely make a donation in a few days. Thank you for your awesome support!
All RSS1 Guest(s)
