First time using MySQL, ask for help
I use navicate, how to put the database back into the other server inside Ah, the inside is also loaded with navicate
Share to:
------Solution--------------------
Not used navicate, it is a graphical tool, should have the import and export button, look for it.
------Solution--------------------
References:
I use navicate, how to put the database back into the other server inside Ah, the inside is also loaded with Navicate
Navicat is a very useful tool.
In particular, the "data transfer" function, the most convenient between different databases to copy/backup.
Two cases:
1. You can connect to a database on two servers with Navicat, then use the data transfer function directly
For example, Xiudou and localhost two servers can be connected to a
2.navicat cannot access up to two servers at a time
Then first use the Navicat on the original database point right-click "Dump SQL File" to get the SQL file
Try to replicate it to another server.
Then open the Navicat on another server open the database connection, create the database (empty), then right-click, run the SQL file
