Help: Cannot backup DB - Urgent

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

 

There should be no timeout issues through SSH.

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

Is it a MySQL database?

 

Yes Sir, a MySQL DB.

Getting a variation in sizes every time I try to Backup

 

Its ok. I will back it up table by table

 

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.

 

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

 

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");

 

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