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 vote276 views2 answers
T sql get foreign key
SQL
1 vote262 views1 answer
Oracle user last connected
SQL
0 vote288 views1 answer
Supprimer les valeur d'une table mysql
SQL
5 votes301 views4 answers
Upload database mysql command line
SQL
1 vote289 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote274 views1 answer
How to print records of employees hired in particular month in oracle
SQL
0 vote276 views1 answer
Sql select rows with different values in one column
SQL
20 votes331 views4 answers
Sql count if
SQL
2 votes302 views1 answer
How to find table table in stored procedure sql server
SQL
13 votes312 views4 answers
What is sql
SQL