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 vote114 views1 answer
Django mssql backend
SQL
0 vote151 views1 answer
For select oracle
SQL
0 vote126 views1 answer
Sql select column name like from multiple tables
SQL
0 vote112 views1 answer
Sql server udf performance
SQL
6 votes126 views1 answer
SQL insert all columns
SQL
1 vote164 views1 answer
SQL server query column yes or no
SQL
0 vote75 views1 answer
Select all domains of database firbird
SQL
3 votes119 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote128 views1 answer
How to install Firebird
SQL
0 vote119 views1 answer
Mariadb mysql root access denied
SQL