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 vote193 views2 answers
Mysql get day of week
SQL
0 vote215 views1 answer
Sql server create constraint
SQL
0 vote184 views1 answer
Mysql repair a table
SQL
0 vote182 views1 answer
Acual month sql
SQL
0 vote213 views1 answer
Pgadmin save data greyed out
SQL
0 vote191 views1 answer
Get the next column of a table in mysql
SQL
0 vote195 views1 answer
Max mysql
SQL
0 vote194 views1 answer
Drop all procedures sql server
SQL
8 votes192 views2 answers
Update sql server from another table
SQL
0 vote191 views2 answers
How to generate a unique random number in mysql
SQL