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

2 votes112 views1 answer
Oracle kill job by sid
SQL
0 vote126 views1 answer
Insert into select with group by
SQL
59 votes288 views6 answers
Alter table sql
SQL
0 vote136 views1 answer
Full outer join in mariadb mysql
SQL
0 vote113 views1 answer
Mysql timediff
SQL
16 votes118 views3 answers
T-SQL Add Column
SQL
23 votes111 views6 answers
Delete all rows from table sql
SQL
4 votes110 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote114 views4 answers
Mysql desactivar trigger
SQL
1 vote118 views1 answer
Mysql alter decimal precision
SQL