Mysql dump specific tables

#note by specifying -p flag without a password it'll prompt you for pass

#dump specific files to a SQL file
mysqldump -u userHERE -p --lock-tables=false database_name table1 table2 table3 > mydb_tables.sql


#if you want to import a file into the data use this
mysql -u userHERE -p database_name < file.sql

Similar codes

1 vote135 views3 answers
How to truncate foreign key constraint table
SQL
2 votes133 views1 answer
Postgresql update sequence next value
SQL
6 votes170 views1 answer
Postgresql get year
SQL
2 votes142 views2 answers
Postgresql get table names
SQL
0 vote158 views1 answer
No suitable driver found for sqlite
SQL
3 votes136 views3 answers
Into in sql
SQL
0 vote124 views1 answer
CREATE MULTIPLE FK
SQL
1 vote143 views3 answers
Default password of mysql
SQL
0 vote127 views1 answer
Running query in redshift
SQL
2 votes134 views2 answers
Mysql all columns
SQL