I have a Drupal site backup which I need to restore after I migrated my web testing server OS (Fedora 11 to 15). I was able to import all of my sites but for one. Actually I was “able” to import the data, only there is nothing there–no records. And yet the file size is 2MB (nearly 4x larger than another site I have of comparable size).
Then the question, What’s in this database? What’s taking up all this memory? Its so tedious to open the individual tables in phpmyadmin or via command line, there’s over 50 tables.
While I’d love to hear your cool tricks for juggling your databases, I’d be happy with a quick way to summarize the following:
- The total number of records in the database.
- The number of records in each table–sort descending.
- Sort the records by memory size (to find which tables have the most data).
