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

12 votes221 views2 answers
Find duplicates mysql column
SQL
0 vote135 views1 answer
Print boolean in plsql
SQL
-2 votes134 views3 answers
Oracle tablespace usage
SQL
3 votes181 views1 answer
Sql several or
SQL
7 votes144 views5 answers
Sql remove spaces
SQL
0 vote150 views1 answer
How to move a column to different spot mysql
SQL
0 vote133 views1 answer
Postpresql relation not found
SQL
0 vote148 views1 answer
TSQL function split string
SQL
0 vote175 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote141 views1 answer
SQL add a totals of differemt rows of the same id
SQL