Backup / Export a Database from SSH

                        In this tutorial we will show you how to export a database from SSH. This is useful for many things such as when you are moving your site, since it exports the entire database, or?before you attempt to upgrade a website, since it is essentially a backup of the database. ?

                        Don’t have time to read the article. Watch our walk-through video.

                        Generate a Database Backup

                        1. Connect to your server via SSH.
                        2. In the command line enter the following code:
                          mysqldump -u dbusername -p databasename > nameofdbbackup.sql --no-tablespaces

                          Be sure to replace:
                          dbusername = with the database username for the database you want to export.
                          databasename = with the name of the database you want to export.
                          nameofdbbackup = enter a name for the exported database.

                        3. Hit the Enter key and it will ask you for your password. Type your password and hit the Enter key again, it will begin exporting, this may take some time to complete, depending how large your database is. Your SSH client will take you to a new line when this process completes.The database will now be available for download in your home directory.
                        ?
                        Congratulations, now you know how to Export / Backup your database from SSH!
                        JB
                        John-Paul Briones Content Writer II

                        John-Paul is an Electronics Engineer that spent most of his career in IT. He has been a Technical Writer for InMotion since 2013.

                        More Articles by John-Paul

                        Thoughts on “Backup / Export a Database from SSH

                        Was this article helpful? Let us know!

                        艳妇雪白细嫩的艳妇