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

2 votes305 views1 answer
Create table with primary key
SQL
25 votes372 views4 answers
Import mysql dump command line
SQL
0 vote303 views1 answer
Sql where time stamp is in between
SQL
24 votes325 views4 answers
Mysql datetime
SQL
6 votes318 views4 answers
Delete table sqlite
SQL
2 votes337 views2 answers
Postgres add column integer
SQL
0 vote298 views1 answer
How to check which sp is running in sql server
SQL
2 votes339 views2 answers
Get all tables using like
SQL
0 vote308 views1 answer
Criteria builder select subset of column
SQL
4 votes324 views2 answers
Linq join
SQL