How to Change Your Panel and FTP Password for cPanel?

Exporting a database over SSH can be particularly useful for handling large databases or automating backups. Here’s how to do it:

Step 1: Access SSH

1. Open Your Terminal:
• Use a terminal application (like Terminal on macOS/Linux or PuTTY on Windows).
2. Connect to Your Server:

Enter the following command to connect via SSH:
bash
Copy code
ssh [email protected]

• Replace username with your SSH username and yourserver.com with your server’s IP address or domain name.

1. Enter Your Password:
• Type your password when prompted to log in.

Step 2: Export the Database

1. Use the mysqldump Command:

To export the database, use the following command:
bash
Copy code
mysqldump -u database_user -p database_name > backup_filename.sql

• Replace:
• database_user with your MySQL username.
• database_name with the name of the database you want to export.
• backup_filename.sql with the desired name for your backup file.

1. Enter the MySQL Password:
• When prompted, enter the password for the MySQL user to start the export.

Step 3: Verify the Export

1. Check the Output File:
• After the command executes, you can verify that the file backup_filename.sql has been created in your current directory.
2. List Files:

Use the ls command to list files and ensure your backup file is present:
bash
Copy code
ls -l

Step 4: Download the Exported File (Optional)

1. Transfer the File:

If you need to download the backup file to your local machine, you can use scp:
bash
Copy code
scp [email protected]:/path/to/backup_filename.sql /local/directory

• Replace /path/to/backup_filename.sql with the full path to the backup file on your server and /local/directory with the path on your local machine.

Conclusion

Exporting a database over SSH on cPanel is a straightforward process that can greatly facilitate your backup strategy. By following these steps, you can efficiently create a backup of your database. Always ensure to keep your backups organized and secure for future use!