mysql导入导出

1. 首先确定目标库的参数值:
   show variables like 'max_allowed_packet';
   show variables like 'net_buffer_length';
2. 导出：C:/>cd D:/Program Files/MySQL/MySQL Server 5.0/bin
            C:/>d:
            D:/Program Files/MySQL/MySQL Server 5.0/bin>mysqldump -uroot -p 000 -e --max_allowed_packet=1048576 --net_buffer_length=16384>d:db.sql
3. 导入：C:/>cd D:/Program Files/MySQL/MySQL Server 5.0/bin
            C:/>d:
            D:/Program Files/MySQL/MySQL Server 5.0/bin>mysql -u root -p db_name
            D:/Program Files/MySQL/MySQL Server 5.0/bin>***
            D:/Program Files/MySQL/MySQL Server 5.0/bin>source d:/db.sql