Database Backup CLI

Forum - Software
#1

Greetings, I apologize if this has been asked before (I could not find it in the forum), but is there a method to backup the database to an exportable zip file via the command line as opposed to the web interface? I’m in the process of transitioning between servers and suspect a database backup export may be corrupt, and because I’ve moved IP addresses and certs already I’m not (currently) able to log into the original server web interface. I can still connect via ssh so instead of spending time troubleshooting the web connection I’d rather just export from the CLI.

Thanks,
Greg

#2

Hello Greg,

You can do simple mysqldump, but it is not recomended way to do the backup since backup via browser doing some additional magic. You need to change variable called CRON_URL in settings table to correct url.

#3

Thanks for the information. I’ll stick with the browser.