How to migrate local mysql to server database

We can use the scp command of Linux (scp cannot be used in Windows), plus mysqldump that comes with mysql, to quickly complete the database migration.

Export the local database (music_db) as a sql file (music_db.sql)

mysqldump -uroot -p music_db > music_db.sql

Use the scp command to send the sql file to the server

scp music_db.sql remote login account@server ip:server directory/music_db.sql

SSH login server

ssh remote login account@remote ip

Log in to mysql on the server

mysql -uroot -p

Create a database with the same name (music_db) in the server's mysql, and then exit mysql

create database music_db charset=utf8;

exit;

Import the music_db.sql file transferred by the scp command into the database of the same name just created
mysql -uroot -p music_db < music_db.sql

Finish

Some students may ask if there is a simpler way. Don’t tell me there is! ! !

Method 2

The premise is that you have used Navicat to connect to the remote server. . . . .

For methods to connect to a remote server, see another blog: Remote connection to a server database

After connecting to the server, you can see the server database. We can right-click on the local data or server database, and the following will appear:

After selecting Data Transfer, you can see the following:

Just fill in the local and server related information to be transferred, click Start to display the log information, and wait for the upload to be completed!

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.