Mysql dump mysql db cli

Database dump mysql command

mysqldump -u username -p dbname > filename.sql

Mysql dump mysql db cli

#note by specifying -p flag without a password it'll prompt you for pass

DUMP:
mysqldump -u username -p dbname --lock-tables=false > filename.sql

Import:
mysql -u username -p dbname < filename.sql

Import external:
mysql -h host -u username -p dbname < filename.sql

Similar codes

0 vote214 views1 answer
Sql select rows with different values in one column
SQL
14 votes211 views1 answer
Excel is not a database
SQL
0 vote200 views1 answer
Rabbitmq service not starting
SQL
0 vote231 views1 answer
Count in sql and diff
SQL
0 vote204 views1 answer
Find wordpress version in database
SQL
0 vote229 views1 answer
Sqlite explain plan
SQL
5 votes221 views1 answer
Sort order on two columns sql
SQL
0 vote214 views1 answer
Postgresql if else endif
SQL
0 vote178 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote231 views1 answer
Sqlalchemy query sql compiled
SQL