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 votes167 views1 answer
To count number of rows in SQL table
SQL
0 vote135 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote145 views2 answers
Oracle list partitioned tables
SQL
2 votes181 views1 answer
Datefromparts mssql
SQL
0 vote147 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote173 views1 answer
Drop column if exists sql server
SQL
0 vote135 views1 answer
Oracle last character of string
SQL
0 vote149 views3 answers
Sql server import json
SQL
0 vote142 views1 answer
Set a value by excuting stored procedure
SQL
1 vote149 views1 answer
How to group by month using sql server
SQL