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

Import mysql dump command line

mysql -u username -p database_name < file.sql

Source: stackoverflow.com

Database dump mysql command

mysqldump -h <hostname> -u <username> -p <database_name> > file-dump.sql

Similar codes

4 votes196 views5 answers
Primary key
SQL
3 votes191 views2 answers
Mysql HAVING
SQL
0 vote194 views3 answers
How to run sql query
SQL
17 votes196 views4 answers
Postgres list users
SQL
0 vote185 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
3 votes193 views2 answers
Check data in table mysql
SQL
0 vote230 views3 answers
Convert sql query to python pandas
SQL
0 vote283 views1 answer
Dockerfile example for Django
SQL
0 vote702 views1 answer
T sql less than date
SQL
1 vote146 views1 answer
Pagination sql
SQL