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

5 votes116 views1 answer
Sql use database
SQL
0 vote108 views1 answer
Except in sql
SQL
1 vote107 views1 answer
Apex run 404
SQL
0 vote117 views1 answer
What is mysql_pconnect
SQL
56 votes204 views5 answers
Psql create user
SQL
0 vote119 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote127 views1 answer
Mysql exception output
SQL
1 vote116 views1 answer
Postgresql escape single quote
SQL
0 vote120 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote116 views3 answers
Postgresql connect to database
SQL