mysql dump database tables only 1

mysql dump database tables only

mysqldump db_name table_name --where="id > 1"

Here is what the above code is Doing:
1. It’s dumping the database db_name
2. It’s dumping the table table_name
3. It’s dumping only the rows where the id is greater than 1

Similar Posts