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 vote317 views1 answer
Get week day name sql server
SQL
1 vote324 views1 answer
Oracle sql listagg
SQL
13 votes306 views2 answers
Sqlite rename column
SQL
0 vote335 views1 answer
Reona
SQL
1 vote325 views1 answer
Sqlite show columns in table
SQL
0 vote339 views1 answer
On delete set default
SQL
0 vote322 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote271 views1 answer
Sql table to store status
SQL
0 vote349 views1 answer
Firebase sql
SQL
8 votes324 views1 answer
Declare table variable sql server
SQL