Useful if transferring tables between databases / servers
Backup table on 1st database / server
mysqldump –u<user> -p<password> database_one table_name > /tmp/table_name.sql
Restoring the table into another database
mysql –u<user> -p<password> database_two < /tmp/table_name.sql
No comments:
Post a Comment