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

8 votes212 views3 answers
Connect python to mysql
SQL
0 vote196 views1 answer
Window function to forward fill
SQL
0 vote198 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote183 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote148 views1 answer
Postgres delete where id in
SQL
0 vote209 views1 answer
Tsql delete all rows
SQL
0 vote198 views1 answer
Mysql select smaller of two values
SQL
0 vote192 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote176 views8 answers
Convert sql query to linq online
SQL
2 votes235 views1 answer
Oracle find constraints referencing a table
SQL