1.备份表:
mysqldump -hlocalhost -uuername -p DBName tableName > xxx.sql
2.还原表:
mysql -uusername -ppassword DBName < xxx.sql
3.查找my.cnf
mysql --help | grep my.cnf
/etc/inint.d/mysqld stop
mysqldump -hlocalhost -uuername -p DBName tableName > xxx.sql
2.还原表:
mysql -uusername -ppassword DBName < xxx.sql
3.查找my.cnf
mysql --help | grep my.cnf
/etc/inint.d/mysqld stop