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

2 votes209 views1 answer
Import large .sql files into lampp
SQL
0 vote203 views1 answer
Difference between db.query and db.execute
SQL
5 votes176 views1 answer
Invalid column name sql
SQL
-1 vote184 views1 answer
Mac mysql workbench console
SQL
0 vote352 views1 answer
The package java.sql is not accessible
SQL
0 vote188 views3 answers
Drop multiple columns in sql
SQL
1 vote197 views2 answers
Logical operators in sql
SQL
2 votes173 views2 answers
Join update query in sql
SQL
0 vote186 views1 answer
Oracle get running queries
SQL
0 vote184 views1 answer
Mysql date time string format python
SQL