mysql数据库附加（Additional MySQL database）.docVIP

mysql数据库附加（Additional MySQL database） In the SQLyog 6.56 graphical interface, how to import a MYsql database, the database file format is: frm and MYD, and MYI, not SQL scripts, how to import them?. Dont tell me that: Export the entire database (the command is executed in the DOS directory of mysql\bin) Mysqldump -u user name, -p database name export file name Mysqldump, -u, root, -p, aaa, aaa.sql Mysqladmin -uroot -p create database; / / create database MySQL -uroot -p databasedatabase.sql; / / import database No use, optimistic about the problem, in answer to high reward! How do I use SQL statements to separate and attach databases? For separating a database, we can use the Manage Studio interface or stored procedures. But for each approach, you must ensure that no user uses the database. The next thing is to separate or append a database with commands. For Manage Studio, you can handle the operation by looking at the interface yourself. Detach database: For the separation of the database with stored procedures, if it is found that the user cannot stop the link, you can use the ALTER DATABASE command, and the use of a link can interrupt existing termination options to the database set to SINGLE_USER mode set to SIGLE_USER Code: ALTER DATABASE, [DatabaseName], SET, SINGLE_USER, WITH, ROLLBACK, IMMEDIATE, CMD, the following is the separate command for the database EXEC sp_detach_db DatabaseName, when a database is separated successfully, there is no difference from the SQL Server point of view and the deletion of this database. Additional database: To attach the database, you can use the sp_attach_db stored procedure, or use the ATTACH option with FOR CREATE DATABASE command in SQL version Server2005 or higher is recommended in the latter, the former is to forward compatible, it is gradually eliminated, and the latter provides more control of documents. CREATE DATABASE databasename ON (FILENAME =D:\Database\dbname.mdf) FOR ATTACH FOR ATTACH_REBUILD_LOG | However, f