Backup MySQL database locally

sandipbasnet

Sandip Basnet

Posted on May 24, 2022

Backup MySQL database locally

1) Make sure remote connection is enabled :MySQL remote access

2) If remote access is allowed:

mysqldump --host <host_address or ip> -P <Port Number(3306)> -u <db username> -p <database_name> > offgrid.sql

Enter fullscreen mode Exit fullscreen mode
💖 💪 🙅 🚩
sandipbasnet
Sandip Basnet

Posted on May 24, 2022

Join Our Newsletter. No Spam, Only the good stuff.

Sign up to receive the latest update from our blog.

Related

Backup MySQL database locally
mysqldump Backup MySQL database locally

May 24, 2022