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

4 votes194 views2 answers
Show all database inside postgresql
SQL
3 votes238 views1 answer
Export postgres database linux
SQL
0 vote197 views1 answer
Oracle sql date summer time
SQL
1 vote296 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote217 views1 answer
Get total and distict row diff in sql
SQL
20 votes199 views3 answers
How to open postgresql in mac
SQL
0 vote189 views1 answer
Docker export psql sql
SQL
31 votes208 views3 answers
Sql count
SQL
-1 vote302 views1 answer
Brisanje dupliranih konatakata
SQL
1 vote188 views1 answer
What is intersect
SQL