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 vote291 views1 answer
Sql tabelle erstellen
SQL
0 vote279 views1 answer
Mssql now diff 90 day
SQL
0 vote293 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
0 vote284 views3 answers
Query string not ending with with vowels
SQL
0 vote299 views2 answers
Plpgsql
SQL
1 vote271 views1 answer
Postgresql last element of array
SQL
15 votes291 views4 answers
Mysql where value is null
SQL
0 vote299 views1 answer
Postgresql like
SQL
1 vote295 views1 answer
Convert to hexadecimal sql
SQL
0 vote279 views1 answer
Sqlplus change user
SQL