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 vote298 views1 answer
Sql find column name like
SQL
1 vote291 views1 answer
Lpad function in sql oracle
SQL
16 votes315 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote294 views1 answer
Check for directory in bash
SQL
0 vote311 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
3 votes313 views1 answer
Export postgres database linux
SQL
1 vote297 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
1 vote334 views3 answers
Read all columns of a table sql
SQL
1 vote277 views1 answer
Find logged in users mysql
SQL
2 votes295 views2 answers
Oracle no data found error code
SQL