import-export MySQL database from a dump command line

import-export MySQL database from a dump command line

set password for root :
mysqladmin -u root password newpassword ( if never set )

mysqldump -p -u user dbname > dbname.sql

mysql -p -u userĀ -h DBSERVER dbname < dbname.sql

Leave a Reply

Your email address will not be published. Required fields are marked *

3 × 4 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.