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 vote288 views1 answer
Sql group by sum with condition
SQL
0 vote247 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote267 views1 answer
Drop all triggers oracle
SQL
0 vote297 views1 answer
Acutal month year
SQL
0 vote262 views2 answers
Check mysql timezone
SQL
0 vote274 views1 answer
Enable full text search mysql
SQL
0 vote270 views1 answer
How get data from database if id not found then search another column
SQL
2 votes275 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote272 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
52 votes469 views6 answers
Rename column sql
SQL