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

0 vote213 views1 answer
Oracle exchange subpartition
SQL
4 votes228 views2 answers
Oracle last day of month
SQL
1 vote210 views1 answer
Search for tables with name postgresql
SQL
0 vote227 views1 answer
Get date ISO in psql
SQL
0 vote364 views1 answer
Get first match in each group mysql query
SQL
0 vote216 views1 answer
Learn sqlite dart
SQL
3 votes200 views1 answer
Oracle wait
SQL
1 vote227 views1 answer
Too many connections mysql
SQL
1 vote212 views2 answers
Sql now - 1 day
SQL
0 vote212 views4 answers
Mysql replace regex
SQL