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 vote336 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote328 views1 answer
Mysql table variables
SQL
12 votes364 views6 answers
How to install sqlite3 in python
SQL
1 vote353 views2 answers
Mysql trim spaces
SQL
0 vote373 views1 answer
Stored procedure function relation
SQL
0 vote287 views2 answers
How to combine two sql queries in one result
SQL
1 vote269 views1 answer
How to run sql script
SQL
0 vote314 views1 answer
MySQL error code 2068
SQL
0 vote373 views1 answer
Write SQL in ruby on rails
SQL
0 vote333 views1 answer
Luu ckeditor vao mysql
SQL