MySql BackUp
Permalink
Hi,
my back up through mysql admin kept crashing, obviously, its a huge 166 tables database. doing some research i found that straight mysql code will help, but where to run this code. is it just a php script ??
any help would be much appreciated
Thanks
my back up through mysql admin kept crashing, obviously, its a huge 166 tables database. doing some research i found that straight mysql code will help, but where to run this code. is it just a php script ??
any help would be much appreciated
Thanks
Are you running the backup from within the dashboard? If so, what error message(s) are you getting?
im exporting from phpMyAdmin, after i hit go i get
"the website cannot display the web page"
i also tried doing it from dashboard and had this error :
Fatal error: Maximum execution time of 30 seconds exceeded in /usr/home/axsapt/www/htdocs/concrete/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php on line 73
"the website cannot display the web page"
i also tried doing it from dashboard and had this error :
Fatal error: Maximum execution time of 30 seconds exceeded in /usr/home/axsapt/www/htdocs/concrete/concrete/libraries/3rdparty/adodb/drivers/adodb-mysql.inc.php on line 73
That would be an issue on either the db or the server it is on. I would contact your hosting provider, this is an issue on their end.
I edited the PHP.INI file and changed the maximum execution time from 30 to 120 just to fall in to another issue... could not allocate memory etc.. so again I edited the memory to maximum allowed by the host 528M but didn't do the trick.
now i downloaded PUTTY and I was told to be careful running Linux commands. would be much appreciated if any one could give me a step by step directions on backing up the database.
thanks
now i downloaded PUTTY and I was told to be careful running Linux commands. would be much appreciated if any one could give me a step by step directions on backing up the database.
thanks
was not that complicated
set the working directory
cd /usr/home/domaine/backup/...
and then back up the database
mysqldump --add-drop-table -u db_username -p db_name > mybackup.sql
set the working directory
cd /usr/home/domaine/backup/...
and then back up the database
mysqldump --add-drop-table -u db_username -p db_name > mybackup.sql
