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

2 votes185 views3 answers
Current setting postgres timezone
SQL
0 vote159 views2 answers
Azure sql-datenbank
SQL
-1 vote174 views1 answer
Sql add column bit
SQL
0 vote178 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote182 views1 answer
How to run mysql on terminal mac
SQL
0 vote205 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote176 views1 answer
Oracle sql first day of year
SQL
0 vote171 views7 answers
Les jointures sql server
SQL
0 vote178 views1 answer
How to to get time in sql
SQL
1 vote158 views1 answer
Limit offset order by mysql
SQL