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

7 votes324 views2 answers
Create index mysql
SQL
0 vote383 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote327 views1 answer
Postgresql subquery
SQL
2 votes352 views1 answer
Oracle find unusable indexes
SQL
0 vote336 views1 answer
Mysql server not running
SQL
-1 vote365 views1 answer
Spring boot mysql connection properties
SQL
0 vote417 views1 answer
Kimball data warehouse sql calendar
SQL
1 vote341 views3 answers
Reset sql primary key
SQL
0 vote366 views1 answer
Compare two tables to find unmatched records
SQL
5 votes369 views1 answer
Mysql created at yesterdau
SQL