MySQL数据库管理

备份单数据库

mysqldump -u username -p dbname

table1 table2  ···

> backupname.sql

备份多数据库

mysqldump -u username -p --databases

dbname1 dbname2 ···

> backupname.sql

备份所有数据库

mysqldump -u username -p --all -databases

> backupname.sql

还原数据库

mysqldump -u username -p dbname < backupname.sql

导出到文本

select [column] from table where condition into outfile 'filename'

mysqldump -u username -p password -T file_dir dbname table_name

mysql -u username -p password -e 'select * from table' dbname > filename;

导入数据库

load data infile file_name into table table_name;

mysqlimport -u here -p password dbname file_name