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 vote330 views2 answers
Mysql extract month
SQL
0 vote355 views1 answer
Mysql show category once count how many products
SQL
0 vote361 views1 answer
SQL-Arten
SQL
0 vote340 views1 answer
Sql server python connection
SQL
0 vote336 views3 answers
Joins and views sql
SQL
2 votes299 views1 answer
Sql select in list
SQL
0 vote347 views1 answer
How to select a row in sql
SQL
0 vote310 views1 answer
How to check replication lag in mySQL
SQL
11 votes329 views4 answers
Round in sql
SQL
0 vote308 views1 answer
Mysql group rows with same value
SQL