mysql dump file code example
Example 1: dump mysql
mysqldump -u username -p database_name > data-dump.sql
Example 2: mysql dump mysql db cli
DUMP:
mysqldump -u username -p dbname
Import:
mysql -u username -p dbname < filename.sql
Import external:
mysql -h host -u username -p dbname < filename.sql
Example 3: mysqldump
mysqldump -u [username] -p [database-to-dump] > [database-to-receive]
mysqldump -u [username] -P [port] -h [host] [database-to-dump] | mysql -u root -h 127.0.0.1 [database-to-receive]
mysqldump -u [username] -P [port] -h [host] [database-to-dump] [tabl1] [table2] [table3] | mysql -u root -h 127.0.0.1 [database-to-receive]
Example 4: mysqldump cli command
Press CTRL+C to copy shell> mysqldump