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

-1 vote132 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote140 views1 answer
To_date sql
SQL
1 vote128 views1 answer
Oracle case
SQL
4 votes114 views4 answers
Rollback in sql
SQL
3 votes166 views2 answers
Brew restart mysql
SQL
1 vote130 views1 answer
Date_part mysql
SQL
9 votes118 views1 answer
Mysql check date range
SQL
2 votes130 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
2 votes118 views1 answer
Sql like variable
SQL
1 vote122 views1 answer
Mysql how to reset primary key
SQL