Saturday, October 12, 2013

How to import-export database in mysql using command line

For Export:

mysqldump -u root(user_name) -p (database_name) > (database_file_name).sql
Then Enter your password:


For Import:

mysql -u root(user_name) -p (database_name) < (database_file_name).sql
Then Enter your password:

0 comments:

Post a Comment