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 vote215 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
1 vote197 views1 answer
Select not matching data from two tables
SQL
6 votes196 views1 answer
Oracle trigger after logon on schema
SQL
0 vote217 views1 answer
Data types mysql vs postgresql
SQL
0 vote233 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote209 views1 answer
Function plsql
SQL
0 vote183 views1 answer
Myswql show full processlist
SQL
5 votes268 views1 answer
Oracle sysdate - 1 month
SQL
0 vote199 views1 answer
Mysql Like(searching in the string)
SQL
0 vote220 views1 answer
Oracle db timestamp auto add
SQL