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 vote203 views1 answer
List all triggers in SQL Server
SQL
1 vote213 views1 answer
How to unlock table in mysql
SQL
0 vote205 views3 answers
How to increase size of column in sql
SQL
0 vote290 views1 answer
Run docker container with database as rds metabase
SQL
2 votes196 views1 answer
Get first n letter of department name in sql
SQL
0 vote284 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote247 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
-2 votes284 views1 answer
Mysql not empty
SQL
0 vote207 views2 answers
How to save result of sqlite query in a table
SQL
0 vote213 views2 answers
Sql 2 way of select unique
SQL