1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

is this normal in backing up database

Discussion in 'XenForo Questions and Support' started by aiman.h.kallaf, Jun 14, 2012.

  1. aiman.h.kallaf

    aiman.h.kallaf Active Member

    my forum data base is 166 MB
    after backing up it become Forum.sql 17 MB

    from 166 MB to 17 MB ??
  2. MattW

    MattW Well-Known Member

    How exactly are you backing it up?
  3. aiman.h.kallaf

    aiman.h.kallaf Active Member

    from the server it self ( servage ) they have backing up futures , just chose the date base and click on backup
  4. MattW

    MattW Well-Known Member

    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?
  5. aiman.h.kallaf

    aiman.h.kallaf Active Member

    yes it should back up everything ,
    my forum have nothing much about 7000 topics made by me
  6. Chris D

    Chris D XenForo Developer Staff Member

    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.
  7. aiman.h.kallaf

    aiman.h.kallaf Active Member

    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
  8. Chris D

    Chris D XenForo Developer Staff Member

    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.
  9. DBA

    DBA Well-Known Member

    While using MySQL Dumper my backup is roughly 10% of the database size.
  10. Onimua

    Onimua Well-Known Member

    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:
  11. aiman.h.kallaf

    aiman.h.kallaf Active Member

    so is it usable when i move to a different server or for full back up in case anything went wrong
  12. steven s

    steven s Well-Known Member

    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.
  13. Onimua

    Onimua Well-Known Member

    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.
  14. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  15. faeronsayn

    faeronsayn Well-Known Member

    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.

Share This Page