How to Import and Export databases in Linux

Using SSH, execute the following command:

# mysqldump -p -u username database_name > dbname.sql

Once executed, your database will be exported to your /home/username/public_html/ location.

Using SSH, execute the following command:

# mysql -p -u username database_name < file.sql

Now, just the opposite, upload your database raw file to your /home/username/public_html/ location.

Date: Jul 18, 2013

Filed Under: Linux

About the Author: Computer Repair, Freelancer, Blogger, Reviewer and all around nice guy!

Leave a Reply




Google PageRank