常用mysql命令

Posted on 2010/04/24 by 枯藤昏鸦

导入数据

Shell

mysql -h hostname -u username -p databasename source import.sql

1 2	mysql -h hostname -u username -p databasename source import.sql

导出数据

Shell

mysqldump -h hostname -u username -p databasename > export.sql

1	mysqldump -h hostname -u username -p databasename > export.sql

-EOF-