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

14 votes320 views1 answer
Excel is not a database
SQL
1 vote327 views3 answers
Getdate function in postgresql
SQL
48 votes378 views3 answers
Psql create database
SQL
5 votes304 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote314 views1 answer
Call function in query sql server
SQL
0 vote308 views1 answer
Select value from previous row in postgresql
SQL
0 vote285 views3 answers
Mysql calculate age from date of birth
SQL
1 vote329 views1 answer
Sql in array query
SQL
7 votes340 views5 answers
Sql remove spaces
SQL
8 votes341 views2 answers
Mysql get first x characters
SQL