<\/span><\/h3>\nFirst, open your terminal or PuTTY and login to your hosting account. Once logged in, navigate to the directory where you wish the SQL database to be exported and type in this command below:<\/p>\n
mysqldump -u DBUSERNAME -p DBNAME > dbbackup.sql<\/p>\n
Make sure to replace the DBUSERNAME with the correct database username and DBNAME with the correct database name.<\/p>\n
Here\u2019s the breakdown of the command:<\/p>\n
mysqldump is the initial command to export the MySql database.<\/p>\n
-u clarifies the username of MySQL database<\/p>\n
-p specifies the need to use the database password<\/p>\n
dbbackup.sql : the result of the export<\/p>\n
After typing the command above, you will then be asked to enter the database password. If the password is correct, the export progress will start. Once finished, type in the command ls and the dbbackup.sql should be visible.<\/p>\n
Here\u2019s a screenshot taken from Terminal for reference:<\/p>\n
![\"\"](\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8273.jpeg\")
<\/p>\n
<\/span>Importing<\/strong><\/span><\/h3>\nLuckily, importing a MySQL database via SSH includes almost the same exact steps as exporting one. Once you are logged in to your server via Terminal or PuTTY, navigate to the directory where you store the SQL file that you wish to import to an existing empty database. Then run this command:<\/p>\n
mysql -u DBUSERNAME -p DBNAME < dbbackup.sql<\/p>\n
Don\u2019t forget to replace the DBUSERNAME and DBNAME to the correct database username and name accordingly.<\/p>\n
Command Breakdown:<\/p>\n
mysql is the initial command to import the MySql database.<\/p>\n
-u clarifies the username of MySQL database<\/p>\n
-p specifies the need to use the database password<\/p>\n
dbbackup.sql : the SQL file that will be imported<\/p>\n
You will then be prompted to input the correct password and afterward the import progress will be initiated. Depending on the database size, it can take a few seconds or minutes for the database import to finish.<\/p>\n
Here\u2019s another screenshot that can help you:<\/p>\n
![\"\"](\"https:\/\/zalvis.com\/docs\/wp-content\/uploads\/2024\/06\/IMG_8274.jpeg\")
<\/p>\n
<\/span>Conclusion<\/strong><\/span><\/h2>\nNow that you see how impeccably easy it is to import or export a MySQL database, there\u2019s no need to worry if there comes a day when you need to do either. For the beginners, it\u2019s always recommended to export or import the databases via phpMyAdmin as it\u2019s much easier and GUI based. For the more experienced users out there, feel free to type in those commands above from your terminal and voila! Your SQL database will be exported\/imported in no time!<\/p>\n
If you enjoyed this article, then you\u2019ll love Zalvis's Cloud Hosting platform. Turbocharge your website and get 24\/7 support from our veteran team. Our world-class hosting infrastructure focuses on auto-scaling, performance, and security. Let us show you the Zalvis difference!
Check out our services.<\/a><\/div>