is this normal in backing up database

Hmm, not sure how that is doing it, but my Xenforo DB is ~170mb when I dump it using mysqldump, and even when compressed using bzip it's still 42mb.

Is it doing all the tables in your database?
 
Could this be like when you try to download a database using something like PHP My Admin and it just craps out after a few minutes?

Perhaps this system is having similar problems but suppressing the error.

As MattW says, mysqldump running from shell is probably the only real reliable way of backing up a database.
 
The best way is to get command line access to your server. This is usually done using telnet or ssh. Sometimes in your hosting cPanel you might have an option to open an SSH connection or Secure Shell connection, or similar?

If it's a VPS rather than a shared server then you might have something like kvm access to control it directly.

Your hosts might be able to give you more specific information.

PHP My Admin doesn't do a great job with backing up databases either unfortunately.
 
That's mainly due to the SQL file a (large) text file, in which are simply commands MySQL uses to restore data back to the database. If you open the file in a text editor, look at the end of the file and you should see something similar to:
-- Dump completed on 2012-06-12 08:23:17
 
from the server it self ( servage ) they have backing up futures , just chose the date base and click on backup
Be aware you may not be able to restore your database the same way.
One piece of advice, check your backup. I routinely backed up my database only to find that it wasn't backing up all the tables.
 
so is it usable when i move to a different server or for full back up in case anything went wrong
Generally, yes. Note this is only for SQL; you'll still need to back up the actual files on the server separately if you want a full backup. If there's little change in the files depending on how often you backup, it's not usually necessary to copy the files every time you do database backups.
 
My database is about 700MB or so, but when I export it fully compressed it comes out to be around 100MB. I can then completely restore it without problems, so the size might not be the problem.
 
Top Bottom