By yosemite on

I have had drupal 5.10 running now for about a year at 1and1 and could always back up my db through phpMyAdmin into a bzipped file. recently i was unable to do that and it returned a zero bytes file.

i talked to 1and1 and they said that once your db gets to big you can not export it compressed as it places to much load on their server. the db is only 28 megs and i am able to export uncompressed.

is there any way to reduce the size of the db? like delete temp entries or something?

⋅ Categories: Drupal 5.x

Comments

jastraat’s picture

jastraat commented

You can truncate the cache tables (cache, cache_content, etc). Also - if you have the search module enabled, you might be able to save some space by truncating the search tables.

------------------------------
http://fraggles.artsci.wustl.edu (Drupal user documentation and development blog)

mcjim’s picture

mcjim commented

If you haven't been running cron, try running that first to see if it reduces the db size.

yosemite’s picture

yosemite commented

I think it was the search and other cached info. I used the backupandmigrate module to export the db minus the cached tables, dropped the db and the imported the newly saved one. It cut the size drastically!