DEV Community

Sandip Basnet
Sandip Basnet

Posted on

4 4

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)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay