I'm trying to database backup localhost
so i go advanced system setting/environment variables/system variables and
new add C:\xamp\mysql\bin
when i click create backup file in admin area ,
show "please wait" and can't do anymore..
and show
" Our website is currently down for maintenance
We expect to be back in a couple hours. Thanks for your patience." when reload current page.
what should i do for this page start normal
and how to database backup in localhost
localhost database backups error
Re: localhost database backups error
This was the advice I received when asking about " Our website is currently down for maintenance
We expect to be back in a couple hours. Thanks for your patience."
During backup, the site is put temporarily into maintenance mode till the backup finishes. It seems that the backup hanged and never got out of maintenance mode. You can disabled that mode by deleting the file ".maintenance" from the admin folder.[/i]
I have also added the C:\xampp\mysql\bin to the path and I still can not do backups with Windows. I was looking for an answer myself.
We expect to be back in a couple hours. Thanks for your patience."
During backup, the site is put temporarily into maintenance mode till the backup finishes. It seems that the backup hanged and never got out of maintenance mode. You can disabled that mode by deleting the file ".maintenance" from the admin folder.[/i]
I have also added the C:\xampp\mysql\bin to the path and I still can not do backups with Windows. I was looking for an answer myself.
Re: localhost database backups error
Hi,
is it possible that you have not set a password for your DB as you use it localy? If this is the case, the backup will start, but mysqldump will prompt for a password which causes the command to hang.
You can modify the create_backup() function in the admin/pageBackupRestore.php file and set
That could help.
!! Please note that this file gets overwritten if you recreate your project.
is it possible that you have not set a password for your DB as you use it localy? If this is the case, the backup will start, but mysqldump will prompt for a password which causes the command to hang.
You can modify the create_backup() function in the admin/pageBackupRestore.php file and set
Code: Select all
$pass_param = ((empty($config['dbPassword']) || $config['dbPassword']=='""') ? "" : "-p{$config['dbPassword']}" );
!! Please note that this file gets overwritten if you recreate your project.
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: localhost database backups error
That worked!
Thanks
Thanks