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

0 vote164 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote145 views1 answer
Sql row number in result set
SQL
0 vote150 views1 answer
Sql server Cost Fifo query
SQL
1 vote142 views1 answer
Mariadb get column names from table
SQL
4 votes208 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
2 votes151 views1 answer
Node and mysql like
SQL
3 votes169 views1 answer
Set default today mysql
SQL
1 vote146 views2 answers
How to drop a unique constraint in sql
SQL
2 votes152 views1 answer
Oracle convert run_duration to number
SQL
8 votes136 views3 answers
Mysql alter table add index
SQL