Mysql is used for the first time. please help

Source: Internet
Author: User
For the first time I used mysql, I used navicate. how can I back up the database in it and put it in another server? navicate is also installed in it.


Reply to discussion (solution)

Navicate has never been used. it is a graphical tool. There should be an import and export button to find it.

Navicate has never been used. it is a graphical tool. There should be an import and export button to find it. The exported SQL text is garbled.

Open it with any software to see what code the SQL text is.

Open it with any software to see what code the SQL text is. It's utf8. it's garbled to open a txt file, and it's garbled to open it with utf8.

Find the storage location of the navicate database and copy it to the corresponding location on the server.

Find the storage location of the navicate database and copy it to the corresponding location on the server. how can this problem be found?

Find the location where the navicate database is stored, and copy it to the corresponding location on the server. just put it in the same location on another server.

Paste the part that you think is garbled and open it with notepad ++. change the character set to see it.

Paste the part that you think is garbled and open it with notepad ++. change the character set to see it. It is correct to open it with notepad


Find the storage location of the navicate database and copy it to the corresponding location on the server. how can this problem be found?

Yes. copy a copy directly to the corresponding database location on the server.

Copied but opened navicat. the database is not displayed.

Refresh the file in navicat,
If not, the location may be incorrect,
Paste the path below

The newly installed mysql only has two databases: mysql and test files. The red box circled the one I want to copy, but there is no refresh.

The path is correct. if not, you can use the tool in navicat to export it and then import it to the server.

The path is correct. if not, you can use the tool in navicat to export the file, and then import the file to the server to export the file... Can I use qq for remote access? 631373000

If not, use phpmyadmin to export and import data.

You can import SQL files everywhere on another server.

The exported code is garbled and may be caused by inconsistent encoding.

If the encoding is inconsistent, it may be because the encoding of the database you created is inconsistent with the encoding of the imported data,
We recommend that you create a new database, unify the encoding into the data encoding you want to import, and then import the database again.

This is the encoding method of the original database. I exported the SQL file and imported it to the new database in the same way.


Paste the part that you think is garbled and open it with notepad ++. change the character set to see it. It is correct to open it with notepad

When the file is opened correctly, save it as a. SQL file, and import the file to see if the downstream file does not work.

If the data cannot be imported, you can use the query method to import the data.

Log on to your database remotely on the server ~~ Export the database again ~~ Import again

Observation topic discussion

If not, use phpmyadmin to export and import data.

++ Is not a good tool?
The export and import functions are also good.

Just export it directly. is it still so troublesome?

Log on to your database remotely on the server ~~ Export the database again ~~ Import again


I used navicate. how can I back up the database in it and put it in another server? navicate is also installed in it.

Navicat is a useful tool.

In particular, the "data transmission" function makes it easier to copy/back up data between different databases.

Two cases:
1. you can use navicat to connect to the databases on the two servers, so you can directly use the data transmission function.
For example, both xiudou and localhost servers can be connected


2. navicat cannot access both servers at the same time
Right-click navicat on the original database and select "dump SQL file" to obtain the SQL file.
Try to copy to another server
Then open navicat on another server to open the database connection, create the database (empty), right-click and run the SQL file

The better method is:

1. use MySQL's built-in mysqldump tool to export data:

X: \ mysql \ bin \ mysqldump-u [database user]-p [password] -- opt -- default-character-set = [Database encoding, generally, utf8]-R [Database name]> [exported file name]. SQL

2. after export, go to mysql and create a new database:

Mysql> create database [new database name];

3. finally, import the exported SQL file to the database again:

X: \ mysql \ bin \ mysql-u [database user]-p [password] -- default-character-set = [Database encoding, generally, utf8] [New database name] <[exported file name]. SQL

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.