MySQL数据库表的导入导出
备份:
mysqldump -hhostname -uroot -ppassword dbName tableName> tableName.bak
还原:
mysq> use dbName
mysq> source /data/tableName.bak
备份:
mysqldump -hhostname -uroot -ppassword dbName tableName> tableName.bak
还原:
mysq> use dbName
mysq> source /data/tableName.bak