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 vote170 views1 answer
Sql count null values in all columns
SQL
1 vote198 views1 answer
Oracle list data files
SQL
0 vote178 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote180 views1 answer
Create a sql server database programmatically
SQL
15 votes181 views2 answers
Sql order by multiple columns
SQL
3 votes175 views1 answer
Get all elements sql
SQL
0 vote190 views1 answer
Drop specific row postgresql
SQL
0 vote176 views1 answer
Java check if something is in mysql table
SQL
10 votes174 views1 answer
Query to find object dependencies in oracle
SQL
5 votes177 views2 answers
Get number of columns sql
SQL