Backup times out even selecting just 1 table

**knows MySQLDumper** Joined: 06 Aug 2011 Posts: 5

Hello masters,

I really hope you could help me out.

I have a 2gig DB and I'm having trouble making a back up of it. Basically as the subject indicated the back up is timing out. My first attempt was to use mysqldumper to backup the entire 2 gig DB with Multipart backup enabled (10mb per part). When it timed out I tried to select a single table only (size 16kb) then hit start backup. It still timed out. error:

"Gateway Time-out

The gateway did not receive a timely response from the upstream server or application.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request."

I know my installation works because I was able to backup (using mysqldumper) another DB which has a size of 1.2mb. Not sure what else to check. I simply need to be able to back-up this entire 2gig DB

My specs:

linux
apache 2.2.19
PHP 5.3.6
MySQL 5.1.56
mysqldumper 1.24.4

Oh btw I also tried it locally coz I have a copy of the DB (a few months old around 1.6 gig) I can't even reach the part where I can select tables.

specs locally:

win7
wampserver 2
apache 2.2.17
php 5.3.5
mysql 5.5.8

thanks and more power

Posted: 2011-08-06, 14:00 (No subject)

Without knowing the kind of data you are trying to backup I can only try to get some hints which may or may not be a help. Wink

Set the speed params to 100/10000 and disable the optimize option. Does this change anything?

**knows MySQLDumper** Joined: 06 Aug 2011 Posts: 5

Hi DSB,

Thanks for the response. Silly me amongst all the settings I haven't turned off optimization. Now I'm at least seeing the progress bar. Thanks so much.

Regarding the kind of data. Not really sure what you meant. All my data are just text information, no picture blob or music files. The previous guys maintaining this system hasn't heard of the word "Archiving" that's why data got this big. Now I have to transfer it to a dedicated server.

Thanks again

Posted: 2011-08-06, 17:59 (No subject)

So the optimizing process takes too long because it haven't been executed for a long time. That's why you are getting a 404 error (browser or PHP times out).

It would be best if you can turn on the automatic optimization. This will also speed up your database.

You could manually optimize all tables until they are in a good state again. Do so under Home / Databases / select your db and hit the button "optimize tables". You will get timeouts or blank screens because the process takes too long. Don't get confused and reload the site after 5 minutes. Repeat this until you won't get timeouts but the list of tables. Then your tables are optimized and you can reactivate the setting for the backup process.

**knows MySQLDumper** Joined: 06 Aug 2011 Posts: 5

Big thanks

Ok will do. Im currently processing the backup now. Will let you know the results.

**knows MySQLDumper** Joined: 06 Aug 2011 Posts: 5

I got one quick question. Im working from home and its stormy here lately. What if my power and net went down what happens to the backup progress? Will it still go on or it will stop? If so how do i resume it (dont want to begin from the start)

thanks

Posted: 2011-08-06, 19:01 (No subject)

**knows MySQLDumper** Joined: 06 Aug 2011 Posts: 5

thanks for the help