Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 08 Jun 2005, 12:33
TJFweb TJFweb is offline
 
Join Date: Dec 2001
Question Way to incrementally back up MySQL DB?

Hi,

I've had huge problems keeping backups of my forum database in the past, as I can never do a complete dump of all tables into one file - instead I get the error:

mysql error: MySQL client run out of memory

mysql error number: 2008

I've tried many different approaches, from third party PHP SQL programs (including phpmyadmin) to Windows executables to painstakingly backing up each table individually - which is often impossible because some tables are so large that they too cause this error. I even went to the trouble of trying to back up small ranges of rows in the big tables, but this proved to be too difficult.

Is there any possible way around this at all? Are there any programs that can incrementally backup a DB to a file?

Thanks!
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 14:35.

Layout Options | Width: Wide Color: