说明：mydb为当前要导出的数据库名称；mydb.sql数据导出的存放文件
mydb.sql内容如下：
-- mysql dump 10.9 -- -- host: localhost database: mydb -- ------------------------------------------------------ -- server version /*!40101 set @old_character_set_client=@@character_set_client */; /*!40101 set @old_character_set_results=@@character_set_results */; /*!40101 set @old_collation_connection=@@collation_connection */; /*!40101 set names utf8 */; /*!40014 set @old_unique_checks=@@unique_checks, unique_checks=0 */; /*!40014 set @old_foreign_key_checks=@@foreign_key_checks, foreign_key_checks=0 */; /*!40101 set @old_sql_mode=@@sql_mode, sql_mode='no_auto_value_on_zero' */; -- -- table structure for table `user` -- drop table if exists `user`; create table `user` ( `id` int(5) not null auto_increment, `name` varchar(20) not null default '', `password` varchar(20) not null default '', primary key (`id`) ) engine=myisam default charset=latin1; -- -- dumping data for table `user` -- /*!40000 alter table `user` disable keys */; lock tables `user` write; unlock tables; /*!40000 alter table `user` enable keys */; /*!40101 set sql_mode=@old_sql_mode */; /*!40014 set foreign_key_checks=@old_foreign_key_checks */; /*!40014 set unique_checks=@old_unique_checks */; /*!40101 set character_set_client=@old_character_set_client */; /*!40101 set character_set_results=@old_character_set_results */; /*!40101 set collation_connection=@old_collation_connection */; |
