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 vote103 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote93 views1 answer
Sql select most frequent value in group
SQL
0 vote104 views1 answer
How to drop a trigger in postgresql
SQL
0 vote97 views1 answer
Create boolean column in MySQL with false as default value?
SQL
1 vote100 views2 answers
Sql convert datetime to year month
SQL
25 votes100 views3 answers
How to use a database to see tables mysql
SQL
0 vote106 views1 answer
Mysql 8 geo to json
SQL
0 vote130 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote99 views1 answer
Check connections to database postgres
SQL
0 vote93 views1 answer
Import mysql'
SQL