user backup failed

G

genexis

Verified User
Joined
Mar 25, 2006
Messages
35
I've been trying to backup a user with a huge mySQL database, around 5 gig. I log into reseller and use the userbackup script to do it. I am saving the file into a local drive, meaning that i am not using ftp.
However, i am always getting an error saying that the backup has failed, as it is unable to backup the 5 gig database.

i am using centos 4.3, with directadmin1.26.6. No edits in php.ini yet, please help. Thanks!
 
i don't think so. I'm able to see a 5gig plus file in the backup directory after that, but i get an email saying that there has been an error while backing the 5 gig mysql db.
 
Correct me if wrong, but didn´t user level backup use PHP to get a mysql dump?

Combine that with a 30 sec timeout and dynamically changing data, and you have a nice cocktail for problems.

What's the size of the file the system leaves behind?

Can you perhaps follow the dump by logging in to phpmyadmin as da_admin (password can be seen by typing:
Code: 
cat /usr/local/directadmin/conf/mysql<tab><enter>
)

Then go to the process list in phpmyadmin and start refreshing when the backup is running. It should be done table by table, if it's not at the last table when it stops, you can assume it's the php timeout.
 
You must log in or register to reply here.
Back
Top