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 vote149 views1 answer
Get cpu details sql
SQL
0 vote146 views1 answer
How to find symmetric pairs in sql
SQL
14 votes142 views2 answers
Sql cast
SQL
21 votes142 views5 answers
Oracle all tables
SQL
0 vote150 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote154 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote137 views1 answer
Firebase sql
SQL
3 votes142 views2 answers
Mysql HAVING
SQL
5 votes147 views1 answer
Sql integer to serial
SQL
1 vote140 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL