Discussion in 'XenForo Questions and Support' started by aiman.h.kallaf, Jun 14, 2012.
my forum data base is 166 MB
after backing up it become Forum.sql 17 MB
from 166 MB to 17 MB ??
How exactly are you backing it up?
from the server it self ( servage ) they have backing up futures , just chose the date base and click on backup
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?
yes it should back up everything ,
my forum have nothing much about 7000 topics made by me
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.
what are the best values for this picture
and how to back up the data base then from php my admin , or what is the best way to back my 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.
While using MySQL Dumper my backup is roughly 10% of the database size.
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:
so is it usable when i move to a different server or for full back up in case anything went wrong
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.
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.
Shell access is the best method.
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.
Separate names with a comma.