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

4 votes269 views1 answer
Id primary key auto generated
SQL
12 votes276 views5 answers
Sql merge
SQL
0 vote332 views1 answer
Sqlite schema structure of a relational database
SQL
9 votes305 views3 answers
Sql delete where in
SQL
10 votes317 views6 answers
Mysql set root password
SQL
1 vote282 views1 answer
Mysql add fields
SQL
5 votes313 views2 answers
Functions
SQL
0 vote255 views1 answer
Postgresql copy backup table
SQL
0 vote253 views2 answers
Avg() sql
SQL
6 votes272 views3 answers
Mysql change auto_increment start value
SQL