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

2 votes153 views2 answers
Sqlalchemy return id after insert
SQL
0 vote142 views1 answer
Python sql last insertend
SQL
25 votes158 views4 answers
Metadata
SQL
0 vote150 views1 answer
Update top 100 order by sql server
SQL
0 vote160 views1 answer
Manage Database in MySQL
SQL
0 vote137 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
2 votes154 views1 answer
Oracle sql merge
SQL
0 vote160 views1 answer
Mql5 datetime get hour
SQL
0 vote130 views1 answer
Metada in sql
SQL
8 votes160 views2 answers
Grant all privileges database postgres to user
SQL