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 vote136 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
2 votes111 views5 answers
Alter table primary key postgresql
SQL
0 vote142 views2 answers
Insert into
SQL
8 votes170 views1 answer
Oracle add datafile to tablespace
SQL
2 votes160 views1 answer
Drop sequence
SQL
0 vote150 views1 answer
Mysql in clausule string array
SQL
0 vote167 views1 answer
Oracle pl/sql check if file exists
SQL
29 votes144 views5 answers
Mysql show table structure
SQL
0 vote203 views1 answer
SQL Server Altering Column to be Unique
SQL
3 votes137 views1 answer
Sql select all
SQL