How to back up a database on my Dedicated server via SSH?
mysqldump DATABASE_NAME > BACKUP.sql
Change DATABASE_NAME with the actual name of the database you want to back up.
This will create a backup file of your database called BACKUP.sql that you can later use to restore your information from.
You need help managing your dedicated server? We got it! SiteGround experts not only write helpful articles, but also manage the servers for our clients so they don’t have to read articles like this one. Learn more.