Mysqldump 1 table only

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

Mysqldump 1 table only

mysqldump -u <db_username> -h <db_host> -p db_name table_name > table_name.sql

Source: stackoverflow.com

Mysql dump with table query

mysqldump db_name table_name --where="id > 1"

Mysqldump 1 table only

mysqldump db_name table_name > table_name.sql

Source: stackoverflow.com

Similar codes

6 votes349 views3 answers
Mysql create database utf8
SQL
0 vote331 views1 answer
User defined variables in sql
SQL
0 vote377 views1 answer
Mysql create index lost connection
SQL
1 vote339 views1 answer
Raise application error in oracle
SQL
0 vote313 views1 answer
Get time component of datetime sql
SQL
0 vote396 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote327 views1 answer
Add current timestamp in mysql
SQL
0 vote373 views1 answer
Snowflake drop column
SQL
1 vote401 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
1 vote410 views1 answer
Mysql get max value and id
SQL