Mysql dump mysql db cli

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

Similar codes

1 vote138 views2 answers
Oracle list partitioned tables
SQL
1 vote144 views2 answers
Postgresql truncate cascade restart identity
SQL
1 vote131 views1 answer
Pl sql create table from another table
SQL
9 votes132 views4 answers
Mysql show table fields
SQL
0 vote147 views3 answers
Mysqli count down
SQL
1 vote140 views2 answers
Mysql remove first and last character from string
SQL
0 vote166 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
0 vote132 views1 answer
On update current_timestamp jpa
SQL
0 vote132 views1 answer
Mysql set variable to today's date
SQL
2 votes120 views1 answer
Wait delay in sql server
SQL