Take the 2-minute tour ×
Drupal Answers is a question and answer site for Drupal developers and administrators. It's 100% free, no registration required.

I am using Drupal 7 site on a remote server (bluehost). I cleared the cache before the backup.

  • When I am using the backup and migrate module, and use admin -> config -> back up - the size of the file is 456 kb.
  • When I am using the my php admin interface, and Export the specific database - the size of the file is over 22 MB.
  • When I am looking at the database interface of bluehost, it's written that the same database is over 176 MB.

I know that I am missing something, but I can't figure out the answer.

What is the difference between the databases? Which one should I save?

share|improve this question
add comment

1 Answer

up vote 8 down vote accepted
  • 456kb does sound very small, maybe you don't have much content/field data? Backup and migrate will exclude data from core cache tables, and the sessions and watchdog tables (though not cache tables installed by contrib modules) by default; so that might account for it. It's also probably gzipped.
  • An export through phpmyadmin will include all those tables (and perhaps isn't gzipped), so it should be larger than the backup and migrate version
  • The size of the database on disk, on the server, isn't and can't be proportional to the size of an SQL dump file. There are indexes and other meta data which take up space, so it will almost always have a larger footprint.

You don't need the cache table data, so as soon as you've confirmed that the dump from backup and migrate has the content you need in it (always a good idea to check), you should use that one going forward.

share|improve this answer
    
Thank you for the great and fast answer. I don't have a lot of content - the site is very new. what is "field data"? Can you please what is the "dump" and where is it? –  EB84 Feb 20 at 22:45
    
Sorry, by "dump" I just mean the file that you get from backup and migrate (probably a .sql, .gz or .tar.gz), as in "data dump". "Field data" is the data for fields that you may have attached to content types (the body field, image fields, other text fields, etc) –  Clive Feb 20 at 22:47
1  
Backup and MIgrate will skip the data for core cache tables, watchdog, and sessions by default. Cache tables created by contrib modules will be backed up by default. –  MPD Feb 20 at 23:47
    
Thanks @MPD, I've added that in –  Clive Feb 21 at 1:44
    
Thanks @Clive. Just to be on the safe side, all I need is the backup file I download from the "Backup and Migrate" module? That, with the Drupal folder (The drupal folder of my site with all sub folders inside - e.g. "sites" folder) from the remote server is all I need? –  EB84 Feb 22 at 22:26
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.