Announcement

Collapse
No announcement yet.

SQL getting smaller?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL getting smaller?

    my MySQL data just seems to be getting smaller and smaller! and it all has been happening since i changed servers! any idea why? at was at like 50MB now its down to like 28MB thanks in advanced

  • #2
    Are you taking your backups through the AdminCP or from SSL with MySQL commands?

    It has been reported here, over and over, that using the AdminCP is completely unreliable except for very small backups, because the php script times out as the database gets larger.

    As Steve Machol has posted many times:

    "The only consistently reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeout errors and an incomplete backup file.

    Please see the instructions here:

    Backup:
    http://www.vbulletin.com/docs/html/m...nce_ssh_backup

    Restore:
    http://www.vbulletin.com/docs/html/m...ce_ssh_restore

    If you don't have telnet or SSH access, some people have reported success with these scripts:

    MySQLDumper:
    http://www.mysqldumper.de/en/index.php

    MySQLHotxcopy:
    http://www.vbulletin.com/forum/showt...t=mysqlhotcopy

    Bigdump (restore only):
    http://www.ozerov.de/bigdump.php

    "


    Regards,
    Slappy

    Comment


    • #3
      no no no! my data base was uploaded via ssh and is fine! my question is, why is my SQL data base getting smaller? it was at 50+ MB when i uploaded to the server now its down to like 25MB

      Comment


      • #4
        That depends on how the backup was made. SSH backups are smaller than phpMyAdmin backups. Also backing up and restoring a database optimizes it and gets rid of overhead (unneeded space.)

        If you are not missing any data then I wouldn't worry about it.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Originally posted by smiralles View Post
          no no no! my data base was uploaded via ssh and is fine! my question is, why is my SQL data base getting smaller? it was at 50+ MB when i uploaded to the server now its down to like 25MB
          If you're talking about the binary size of the database files then a drop in total size is to be expected after a server move, although 50% is larger than I've seen in most cases.

          When you delete or update from a SQL table empty space is left behind. Running an OPTIMIZE TABLE or restoring from a backup will remove that empty space.
          Jason Litka - Utter Ramblings

          Comment

          Loading...
          Working...
          X