Help: Cannot backup DB - Urgent

[Blinksy]

Hi.

I have been trying to get a backup of my DB, but every time it gets to the main part(when downloading), it stops the export short. I believe this may be a timeout?

Provider are also having the same problem through ssh. I cannot get it through phpmyadmin.

Uploading is no problem as i use bigdump, but i cannot get a complete copy.

Any ideas?

Thanks

[Will.Spencer]

There should be no timeout issues through SSH (http://www.tech-faq.com/ssh-secure-shell.shtml).

That makes me think to look elsewhere, like a database corruption issue or a drive failure.

Is it a MySQL database?

[Blinksy]

Yes Sir, a MySQL DB.

Getting a variation in sizes every time I try to Backup :(

[Blinksy]

Its ok. I will back it up table by table :)

[gandaliter]

Isn't it possible in phpmyadmin to export the entire database and have it display the code, rather than download a file? I think you go to export and then select all of the tables, and choose not to save as a file.

[Blinksy]

Yes that is possible. However, I believe the browser times out at a certain time, and it is not possible for large DBs, or slow connections.

My DB is over 100meg.. So yeh, hard to manage

[alamster]

if possible, install php exec plugin then use passthru (if supported) to backup your database like in ssh environment.

passthru("mysqldump -uuser -ppassword db_name > result_db.sql");

[JEET]

If nothing works, you can also try and create "files" on your hosting account using "php".
---
Select a table (can do in 1 query), start a loop.
fetch all data for a single row.
Form an INSERT query. (do not run)
Append to file.
Loop continues till all records are written.
---
Do with next table.

Then you can download the files with FTP.
regards :)