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

Import mysql dump command line

mysql -u username -p database_name < file.sql

Source: stackoverflow.com

Database dump mysql command

mysqldump -h <hostname> -u <username> -p <database_name> > file-dump.sql

Similar codes

0 vote134 views3 answers
Between keyword sql
SQL
0 vote123 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
4 votes119 views1 answer
Search column by name mysql
SQL
0 vote125 views1 answer
Oracle activate program
SQL
0 vote137 views2 answers
How to count codition
SQL
4 votes124 views2 answers
Mysql delete user if exists
SQL
0 vote135 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
49 votes204 views6 answers
Get duplicate records in sql
SQL
1 vote142 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote127 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL