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

deleted-user-1175552 | 2 posts | Jan. 27, 2016, 2:50 a.m. | permalink

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
Staff harry | 2710 posts | PythonAnywhere staff | Jan. 27, 2016, 11:44 a.m. | permalink

Hi, it's solved now

Thank you! :D

deleted-user-1175552 | 2 posts | Jan. 28, 2016, 10:40 a.m. | permalink