MySQL uses Navicat to export and import databases

Source: Internet
Author: User

System environment: Win7 x64
Software preparation: Navicat premium_11.2.7 Simplified Chinese version
Download URL: http://www.cr173.com/soft/419023.html

Now I'll introduce you to MySQL. Use Navicat to export and import data.

1. Export the database:
Open Navicat, right-click on the database we want to export, then click "Dump SQL File" on the shortcut menu that pops up, and select the first "data and Structure" in the submenu item that pops up again.


Then, a Save box will pop up where you choose to save, select a good location, click OK, OK

2. Import the database:
Open Navicat Premium, then right-click to select New database with the same name as the database we want to import.


Click OK, we can see the left side of the database we have just established, and then right-click to select "Run SQL File" will pop up a box, click "..." to select the path of the file,


Click Start, the file will be imported successfully!

At this point, MySQL uses Navicat to export and import the database has been completed! I wish you success!

MySQL uses Navicat to export and import databases

Related Article

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.