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 vote347 views2 answers
Mysql filter by date mount
SQL
0 vote343 views1 answer
Contact mysql column field
SQL
1 vote377 views1 answer
Epoch time converter in snowflake
SQL
0 vote376 views1 answer
Split string by comma in sql server
SQL
-1 vote338 views3 answers
Create temp table in sql
SQL
0 vote366 views1 answer
Suhaib
SQL
0 vote389 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
1 vote350 views2 answers
Test sqlsrv connection
SQL
0 vote328 views1 answer
Replace sqlalchemy
SQL
0 vote344 views1 answer
Sql server union if table exist
SQL