Results 1 to 4 of 4
  1. #1

    different db size

    as you know we can use followins to back up db

    1- HMS [(hosting Managemen Script = cPanel / Plesk/vDeck]
    2-phpmyadmin adn 3.th party script
    3-SSH/Telnet

    but why db size is differrent after backing-up?

    db in server is for example 120MB

    When i use SSH to back up db is 75MB
    // // phpmyadin-------------120 mb
    HMS ---------------------110MB

  2. #2
    Join Date
    Nov 2000
    Location
    Holland
    Posts
    246
    That depends a bit on how the backup is made.

    On my own servers I make MySQL backups using mysqldump, which outputs a SQL file (full of SQL statements). This text file is usually much larger than the database size because of the overhead of the SQL code. However it is then compressed using gzip, which cuts it down to site a lot.

    So one reason the backups maybe smaller is because compression is used.

  3. #3
    Quote Originally Posted by GHDpro
    That depends a bit on how the backup is made.

    On my own servers I make MySQL backups using mysqldump, which outputs a SQL file (full of SQL statements). This text file is usually much larger than the database size because of the overhead of the SQL code. However it is then compressed using gzip, which cuts it down to site a lot.

    So one reason the backups maybe smaller is because compression is used.
    do you know which compression algorithm or factor ?

  4. #4
    Join Date
    Nov 2000
    Location
    Holland
    Posts
    246
    Quote Originally Posted by zodehala
    do you know which compression algorithm or factor ?
    No, because I have no clue how the backups are made on your server. Also compression factor probably depends on what kind of data you store in the database, if you store say, JPEG files in BLOB fields (not recommended), then the compression ratio would be far less good than text data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •