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

5 votes330 views1 answer
Oracle get nls settings
SQL
0 vote329 views1 answer
Exclude last comma separated string mysql
SQL
1 vote377 views1 answer
Concat first name and last name in mysql
SQL
-2 votes335 views1 answer
Use of where in left join in mysql
SQL
5 votes376 views4 answers
Mysql update column with value from another table
SQL
0 vote344 views1 answer
Oracle temporary table
SQL
0 vote359 views1 answer
Oracle NLS_CHARACTERSET
SQL
9 votes321 views6 answers
Sql insert into
SQL
0 vote355 views2 answers
Import .sql into postgres db command
SQL
0 vote335 views1 answer
Postgres reorder columns
SQL