TJFweb
06-08-2005, 11:33 AM
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!
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!