How to change the database name in navicat?
1. If the tables and settings in database A are relatively simple, just copy all the tables in database A and paste them into database B.
2. Right-click on database A -> Dump SQL file -> Structure and data; Right-click on database B -> Run SQL file.
Execution speed: slowest.
Related recommendations: "Navicat for mysql graphic tutorial"
3. Select the menu bar: Tools-> Data Transfer (the source library is A , the target database is B) –> Start, after the transfer is completed, refresh database B.
If there is a remote table in database A, the operation will report an error. The error message is:
[Err] [Dtf] 1432 - server name: '' doesn't exist!
Therefore, you need to first copy the DDL statements of all remote tables in the database to a txt file. , and then delete all remote tables in the database. Perform this operation again. Finally, execute all DDL statements saved in the txt file on library B. Implementation principle: copy and paste. Execution speed: medium.
4. Rename all tables in database A. The two libraries must be on the same server. (Recommended)
Execute the following SQL statement, and the query result is a collection of sql scripts to rename the table:
select CONCAT('RENAME TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' to ', 'B.',TABLE_NAME,';') from information_schema.`TABLES` where TABLE_SCHEMA = 'A';
Copy all the result rows and execute them as sql scripts. Execution speed: fastest.
The above is the detailed content of How to modify the database name in navicat. For more information, please follow other related articles on the PHP Chinese website!