1
russtik
Database Backup - reducing a table size?
  • 2005/11/28 19:05

  • russtik

  • Just popping in

  • Posts: 70

  • Since: 2004/8/13


Hi,

I'm trying to backup my database and there's at least one table that is causing a problem:

xoops_priv_msgs

...it's 35.3mb in size and won't export. Is there a way I can clean up the data in the table and reduce it in size?

Also, I'm thinking of moving the site to another server with a 2mb limit on sql queries. Is there a way I can batch automate a backup of a bunch of tables in 2mb chunks?

Thanks.