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

0 vote196 views1 answer
We are intrested to work with your organization
SQL
5 votes194 views1 answer
How to check port number for postgresql
SQL
1 vote206 views1 answer
Sql order by timestamp
SQL
0 vote201 views1 answer
Replace multiple string in query sql
SQL
50 votes218 views4 answers
Sql alter type of column
SQL
0 vote246 views1 answer
Create table using the clause with as
SQL
0 vote202 views1 answer
Mysql table variables
SQL
0 vote180 views1 answer
SQL server select to get sum of hours
SQL
0 vote221 views1 answer
Import Data in MySQL without using any other software
SQL
-1 vote194 views1 answer
Sql syntax create timestamp column
SQL