Answers for "how to export the file in mysql server"

how to export db from mysql

mysqldump -u username -p dbname > dbexport.sql

Posted by: Guest on May-19-2020

mysql export and import

1. Export DB:
mysqldump -u root -p DB_NAME > 18_06_21.sql

2. import DB:
mysql -u root -h HOST_IP -p DB_NAME < 18_06_21.sql

Posted by: Guest on June-18-2021

Code answers related to "how to export the file in mysql server"