Linked Questions

I want to setup a cron job to run so that it will automatically backup my MySQL database, while the database is running, and then FTP that backup to my backup server. I assume I can do this using a ...

I'm am dumping a mysql wordpress database everyday as a backup. Since i don't want to end up with 365 .sql files after a year, i figured it would be decent only to keep the last 30 days of dump files. ...

Hi I need to create something automatic that connects to another server using a php library and then I need to load the data in a mysql database only the first file uploads a new file is uploaded ...

Is there any way to create an event in phpMyAdmin which will allow me to save database into the folder each week?

I try to transfer a huge amount of data (around 200k records every few minutes) from one to another database (also on two different servers). The tableschema on both tables is both dbs is the same. ...

I have WampServer 2.0 that is installed on Windows on my laptop. I'm running on it an application that I wrote. The application is working with MySQL database. I would like to make backups of this ...

I am trying to get a MySQL backup from the AWS RDS automated. I figured using AWS Command Line would be beneficial and I could use crontab on EC2 Red Hat to automate the trigger of the event. Now ...

I wanted to have database backup cron in webserver, I use following codes to output sql file: <?php include('connectdb.php'); $backupFile = 'database_backup_'.date("YmdHis").'.sql'; $command = '...

I'd like to automate a mysqldump to my computer from a remote host, and I cannot figure out how to do it. I suppose that I should run a mysqldump through an SSH tunnel, but this becomes complicated ...

Below is the BASH(Version 4.1.2) script i have placed on cronjob which runs daily at 23:59 to backup a table with records created on that particur day /usr/bin/mysqldump --single-transaction --no-...

I have zero bytes sql file (or gz) from this Cron Jobs command in cPanel (only cPanel Cron Jobs): /usr/local/mysql/bin/mysqldump --user=USERNAME --password=PASSWORD --host=localhost DATABASENAME > ...

This question relates to the file size resulting from phpmyadmin export. I am exporting a table using phpmyadmin export. I had exported the table with 10M rows a few days back. Now the table has ...

I need to execute mysqldump from within a django function. I can do so easily enough from the terminal command line, but when I try to run it from within the python script, I get an error: sh: ...

I am trying to create periodic backups (poor man's cron) of my database using mysqldump with exec() function. I am using XAMPP/PHP7 on macOS. $command = "$mysqldump_location -u$db_user -h$db_host -p$...

I need one script that when I open the script.php page for example, that export me one database from MySQL to an SQL document, and I don't know how to do it in PHP, can some one help me with that? ...