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

19 votes157 views6 answers
Sql server drop table if exists
SQL
0 vote178 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote192 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote185 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
5 votes192 views1 answer
Mysql last day of next month
SQL
0 vote168 views1 answer
Postgres reorder columns
SQL
4 votes161 views2 answers
Mysql delete user if exists
SQL
3 votes150 views1 answer
Sql server version query
SQL
1 vote155 views1 answer
Grab all records from one table to another oracle sql
SQL
1 vote156 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL