import-export MySQL database from a dump command line
- Angelo Schalley
- Nov, 03, 2009
- MySQL
- No Comments
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