Following are the mentioned steps for taking the backup of back-end files which are mostly known as MySQL database on Dedicated servers. Many of us know that SSH (Secure Shell) is one of the best utilities for establishing connections with web servers.
- Log in to your Dedicated server using SSHMake sure that you log in as root via SSH
- Use following command to perform backup”mysqldump DATABASE_NAME > BACKUP.sql“
- Change the name as you want for the Backup file to be saved with.
- The file called as BACKUP.sql will be created here and you get completed the process of backup your database which can be utilized to restore later on whenever required.