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 vote245 views1 answer
How to check event scheduler status mysql
SQL
1 vote235 views1 answer
Oracle finding duplicate records
SQL
0 vote228 views1 answer
Mysql shell set time_zone
SQL
6 votes233 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote256 views1 answer
Oracle webcenter content search enginer
SQL
6 votes230 views1 answer
Oracle desc table primary key
SQL
0 vote218 views1 answer
Heavy table in mysql
SQL
0 vote266 views1 answer
Netstat -tln mysql
SQL
3 votes224 views1 answer
Oracle apex warning message
SQL
0 vote218 views1 answer
Low level operator in dbms
SQL