Forums

Backup MySQL to local

Hi,

How to backup mysql database to my local PC? I cannot find the tutorial on help page... Only postgresql.

Thank you

Hi there, you can use the mysqldump command from a Bash console to save your database to a backup file, and then you can download that to your own PC. The command should look something like this:

mysqldump -u UserName -p -h UserName.mysql.pythonanywhere-services.com --databases 'UserName$default' > /home/UserName/database-backup.sql

Hi, it's solved now

Thank you! :D