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 vote454 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote345 views1 answer
Many rows to 1 string mysql
SQL
0 vote395 views1 answer
Sqlcl format
SQL
1 vote337 views1 answer
Sql server reseed single table
SQL
0 vote365 views1 answer
Oracle select partition
SQL
1 vote394 views1 answer
Ora-01109 database not open in oracle 19c
SQL
2 votes393 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote360 views4 answers
Mysql on kubernetes
SQL
11 votes380 views6 answers
Mysql else if
SQL
0 vote377 views1 answer
Vbscript connect mssql
SQL