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

6 votes188 views2 answers
Mysql check auto increment value
SQL
1 vote187 views1 answer
Load mysql dumb
SQL
5 votes184 views1 answer
Oracle nls instance
SQL
0 vote200 views1 answer
Postgresql create table many-to-many
SQL
9 votes185 views4 answers
How to create new user and database postgresql in ubuntu
SQL
2 votes178 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote160 views1 answer
Create dabase postgresql
SQL
0 vote177 views1 answer
Power query case when
SQL
0 vote185 views2 answers
How to get json data mysql
SQL
1 vote190 views1 answer
Influxdb export to csv
SQL