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

11 votes185 views2 answers
Oracle saurce code
SQL
0 vote166 views4 answers
First max salary in sql
SQL
0 vote168 views1 answer
Vowels in sql
SQL
0 vote171 views1 answer
Group by 15 minute interval sql server
SQL
0 vote168 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote169 views1 answer
Database xml sql
SQL
1 vote177 views1 answer
Tsql get beginning of year
SQL
0 vote198 views1 answer
Remove mysql from centos 7
SQL
0 vote189 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote168 views1 answer
Do postgresql
SQL