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 vote72 views4 answers
Sql limit 1 offset 1
SQL
0 vote130 views1 answer
Mysql root localhost run
SQL
1 vote120 views1 answer
Mysql list bigger table
SQL
0 vote122 views1 answer
Match end of string regex sql
SQL
-2 votes129 views3 answers
Sqlite reset autoincrement
SQL
0 vote108 views1 answer
Get records in sql according to month name and count
SQL
-1 vote115 views1 answer
Condition in orderby mysql
SQL
0 vote112 views1 answer
Online sql testing tool
SQL
4 votes116 views1 answer
To date oracle with time
SQL
0 vote121 views1 answer
Oracle webcenter content search enginer
SQL