DEV Community

Sandip Basnet
Sandip Basnet

Posted on

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

Top comments (0)