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 vote254 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote276 views1 answer
Running percentage of total postgres
SQL
10 votes285 views4 answers
Mysql if else
SQL
0 vote249 views1 answer
Java mysql date format
SQL
0 vote255 views3 answers
Above average salary in sql
SQL
2 votes285 views1 answer
Postgresql create table as select
SQL
1 vote276 views1 answer
Spark sql concatenate string and int
SQL
12 votes250 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote253 views1 answer
Time mysql w3
SQL
0 vote268 views1 answer
Zerar auto increment mysql
SQL