Uploading the local database to the server using Navicat for MySQL

The server system is basically Linux-based, the way the database is uploaded to various versions of Linux, such as Ubuntu and CentOS (although the two versions of the pit pits, but at least in the database transport consistency) of course, the local database is uploaded to the server, the premise is that The server is already installed MySQL database 1. On the server side: 1.linux How to check if MySQL is started

Service MYSQLD Status

Mysqld is stopped that means the MySQL service is in a stopped state

Mysqld is running that means the MySQL service is in the boot state

2. Restart MySQL

Service mysqld Restart

3. Log in to MySQL

# if it is just installed MySQL, the password is empty, press Enter directly (enter) go in, if you have set the password, fill in the password login mysql-uroot-p

4. Set permissions for remote access

# where 123456 is the password used for the connection, the reader can set it up more complex ' Root '@'%'123456' with GRANT OPTION; FLUSH privileges; # set the password, if it is a new installation of MySQL need to set the password here, if you already have a password is not set password =password ('123456'  ); flush privileges;

5. Exit MySQL

Quit

2. On-premises: 1. Install Navicat

Although this software is charged, but gave a 20-day trial period, so can be assured of bold use of genuine, after all, upload database This kind of thing, only in the project on-line deployment when used, 20 days how also enough.

2. Establish a connection 1. Create a new connection, connect to the local database, and the connection name can be a random one.

Figure 1

Figure 2

Figure 3

2. Create a new connection, connect with the server database, the connection name can also be a casual one,

Figure 1

Figure 2

3. Data transfer,

Figure 1

Figure 2

Figure 3

At this point, the completion of the local database transfer to the server process can go to the server side, into MySQL to see if it has been uploaded successfully:

Uploading the local database to the server using Navicat for MySQL