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

18 votes203 views2 answers
Sql comments
SQL
4 votes173 views2 answers
Sql vs mysql
SQL
3 votes199 views1 answer
Oracle cannot access v$session
SQL
1 vote125 views1 answer
Postgres division by zero
SQL
0 vote170 views2 answers
Sqlite unix timestamp
SQL
1 vote196 views1 answer
Events mysql
SQL
0 vote175 views1 answer
Array aggre distinct postgres
SQL
3 votes169 views1 answer
Créer une table sql
SQL
0 vote168 views1 answer
Sql server whoami
SQL
0 vote337 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL