단일 테이블을 백업하는 방법 :

mysqldump db_name> TABLE_NAME.SQL

mysqldump db_name table_name > table_name.sql

mysqldump -u db_username -h db_host -p db_name table_name> table_name.sql

mysqldump -u db_username -h db_host -p db_name table_name > table_name.sql

.sql 파일을 사용하여 :

mysql -u username -p db_name mysql & gt; 소스 full_path/table_name.sql

mysql -u username -p db_name
mysql> source full_path/table_name.sql

mysql -u username -p db_name

mysql -u username -p db_name
mysql> source full_path/table_name.sql

mysqldump db_name table_name | gzip> table_name.sql.gz

mysql -u username -p db_name
mysql> source full_path/table_name.sql