17.4 Mb MySQL database won't backup from Dashboard
Permalink
Hi
Problem with backup and running out of allocated memory.
I've checked the MySQL database size and it is 17.4 Mb and the allocated memory is 32Mb. When I backup from the Dashboard it tells me that "allocated memory is exhausted" - I know what it feels like, this problem is exhausting me!
I'm running 5.4.1 (I think).
Any ideas how to get it running again?
Thanks
Vern
Problem with backup and running out of allocated memory.
I've checked the MySQL database size and it is 17.4 Mb and the allocated memory is 32Mb. When I backup from the Dashboard it tells me that "allocated memory is exhausted" - I know what it feels like, this problem is exhausting me!
I'm running 5.4.1 (I think).
Any ideas how to get it running again?
Thanks
Vern
You could log in to your hosts cpanel and use the mySQL administration tool to download a copy to your local machine. Otherwise it might be a php.ini file setting causing the problem.
Thanks for the suggestion. Backup through cPanel would be fine for me but not for my clients who backup their database, the one in question, themselves.
Take a look with phpmyadmin, there is a table in your database that stores the statistics for the graph in the dashboard. It get huge over time, if you clear it out your db will probably be much smaller and backup and restore will work from the dashboard
This sounds like it might work as I've found a table called PageStatistics which is over 13Mb! Is this the one?? If so, what should I do with it?
