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 vote140 views1 answer
How to access to mysql without root
SQL
0 vote117 views1 answer
Mysql last 6 months
SQL
0 vote142 views1 answer
Soql last week
SQL
10 votes152 views2 answers
Select nextval from sequence oracle
SQL
0 vote127 views1 answer
Oracle list proxy users
SQL
4 votes161 views2 answers
Oracle unliock account
SQL
1 vote132 views1 answer
Sql order by where condition
SQL
0 vote133 views1 answer
Where name ends in SQL
SQL
1 vote150 views2 answers
Intersect sql
SQL
0 vote196 views1 answer
Connect google bigquery connect using sqirrel
SQL