In this tutorial, we will see how you can export the database from SSH. In situations like moving your site this can be useful, as it can help you to export the entire database, or need to upgrade a website.<\/p>\n
Step 1:<\/strong>\u00a0Connect to your server via SSH.<\/p>\n Step 2:<\/strong>\u00a0In the command line enter the following code:<\/p>\n mysqldump -u dbusername -p databasename > nameofdbbackup.sql<\/p><\/blockquote>\n Make sure you replace:<\/strong><\/p>\n dbusername = with the database username for the database you want to export.<\/p>\n databasename = with the name of the database you want to export.<\/p>\n nameofdbbackup = enter a name for the exported database.<\/p>\n Step 3:<\/strong>\u00a0Once you Press the Enter key, it will ask you for your password. Provide your password and press Enter key again, the exporting process will begin. It may take some time to complete the process, depending on the size of your database. The SSH client will take you to the new line when this process is completed and the database will now be available for download in your home directory.<\/p>\n","protected":false},"excerpt":{"rendered":" In this tutorial, we will see how you can export the database from SSH. In situations like moving your site this can be useful, as it can help you to export the entire database, or need to upgrade a website. Generate a Database Backup: Step 1:\u00a0Connect to your server via SSH. Step 2:\u00a0In the command […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-3546","post","type-post","status-publish","format-standard","hentry","category-mysql"],"yoast_head":"\n