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 vote319 views1 answer
Psql check if value in array
SQL
4 votes326 views2 answers
Postgresql reset sequence
SQL
1 vote317 views1 answer
Sql delete all values in a column
SQL
3 votes353 views1 answer
Export postgres database linux
SQL
0 vote348 views1 answer
How to print some string in mysql
SQL
0 vote326 views1 answer
Oracle list proxy users
SQL
1 vote327 views1 answer
Mysql get latest duplicate rows
SQL
0 vote330 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote341 views1 answer
Sqlite commands
SQL
2 votes304 views3 answers
Mysql cheat sheet
SQL