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

10 votes141 views2 answers
SQL rounding numbers
SQL
1 vote149 views1 answer
How to run parallel queries in sql server with entity framework
SQL
0 vote166 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote151 views1 answer
Mysql installer no packages found
SQL
0 vote118 views1 answer
How to create an SQL save method in ruby
SQL
0 vote238 views1 answer
How to use select union and loop
SQL
4 votes130 views1 answer
What are the data types in sql
SQL
1 vote139 views1 answer
Show per page table in xampp
SQL
0 vote127 views1 answer
Sql get month from date
SQL
0 vote123 views1 answer
Create function syntax sql server
SQL