Backup MySQL Database Online Tool
Easily back up your MySQL database with this Apify actor. It securely connects to your database, performs a full backup, and saves the output in SQL format. This actor supports multiple storage and sharing options, including Apify Key-Value Store, Google Drive, and FTP servers, ensuring your data is safe and accessible.
Use this tool for Free (Limited Time offer): https://apify.com/worldunboxer/backup-mysql-database
Overview:
This MySQL Backup Tool:
1. Connects to a MySQL database using the provided credentials.
2. Backs up all tables and data from the specified database.
3. Saves the backup as an SQL file.
4. Supports multiple storage options, including Apify Key-Value Store, Google Drive, and FTP servers.
5. Optionally sends the backup to the specified email address.
6. Retains backups longer than 7 days if configured with Apify Key-Value Store.
How this tool Works?
Connects to check here the Database:
The actor connects to the MySQL database using the provided credentials.
Queries Tables:
It retrieves all table names using the SHOW TABLES command.
Performs Backup:
Backs up all tables and their data into an SQL file containing INSERT statements.
Saves Backup:
Saves the backup locally and uploads it to the configured storage options.
Shares Backup:
Optionally sends the backup via email or uploads it to Google Drive and/or FTP servers.
Key-Value Store Integration:
Retains the backup in the Apify Key-Value Store for longer-term storage (if configured).
Closes Connection:
Safely terminates the database connection after the backup is completed.