Home  >  Article  >  Database  >  How to upload database in navicat premium

How to upload database in navicat premium

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-03 10:36:244015browse

How to upload database in navicat premium

First, connect the mysql database to which you want to export the database in Navicat Premium.

How to upload database in navicat premium

#After filling in the information for connecting to the database, you can connect to the database that needs to be exported.

How to upload database in navicat premium

Open the database to be exported.

How to upload database in navicat premium

Export the structure and data of the database into a SQL file.

How to upload database in navicat premium

Related recommendations: "Navicat for mysql graphic tutorial"

Wait patiently for the export to complete. Then you will get a SQL file named with the name of the exported database.

How to upload database in navicat premium

How to upload database in navicat premium

Connect to the database to be imported and create a new, empty database with the same name as the exported database.

How to upload database in navicat premium

How to upload database in navicat premium

Open this new empty database and run the SQL file exported above.

After the operation is completed, the exported database will be imported into the newly created database.

How to upload database in navicat premium

How to upload database in navicat premium

The above is the detailed content of How to upload database in navicat premium. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn