Help

[php_dev]

Hi all,
today i have deleted a table of my db . Do Hostgator have a copy of backup?

Originally Posted by php_dev

Hi all,
today i have deleted a table of my db . Do Hostgator have a copy of backup?

Depending on how recent the database was created, we may have a backup. Likely it would be from last weekend.

Just fill out the restore form at www.hostgator.com/restore.php

[Impavidus]

Hi php_dev,

Why aren't you doing regular backups?

[php_dev]

Thank you for the fast reply. I have just filled the form and now i hope for the backup (47000 rows).

[esl]

Hello php_dev,

Originally Posted by Impavidus

Hi php_dev,

Why aren't you doing regular backups?

He/she may be. There could have been numerous amounts of changes within the last 24 hours.

[php_dev]

Originally Posted by Impavidus

Hi php_dev,

Why aren't you doing regular backups?

Hi Impavidus,
my db is more than 90mb and i don't have adsl but a connection with a gps (190kbs). From today i will doing regular backups every 2 days.

[slapshotw]

You can get a different account to send the backups to..when I was a reseller I used a dreamhost plan ($20 for the first year) to store backups.

[esl]

Hello php_dev,
Please see:

http://forums.hostgator.com/showthread.php?t=18501
http://forums.hostgator.com/showthread.php?t=12786
http://forums.hostgator.com/showthread.php?t=17075

[php_dev]

Originally Posted by esl

Hello php_dev,
Please see:

http://forums.hostgator.com/showthread.php?t=18501
http://forums.hostgator.com/showthread.php?t=12786
http://forums.hostgator.com/showthread.php?t=17075

Hi esl Very useful your tips! With a cronjob i can backup big tables on my db in the night. What is the cron string to a file? For example: i write a script for backup my db a named it backup.php. What is the string for the cron to start this file every night to midnight?

[php_dev]

i have see a rsync example but i want to be able to set the time to start the file.

[esl]

Hello php_dev,
Cron jobs aren't my thing.. but check out these threads.

http://forums.hostgator.com/showthread.php?t=18338
http://forums.hostgator.com/showthread.php?t=14628

[Impavidus]

Min Hour Day Month WeekDay Command
0 0 * * * php /home/username/backup.php

You can use cpanel's Cron Manager to create a job and run this command:

php /home/username/backup.php

I am using perl mysql backup script for our backups, but I create a php verison which creates backups to the localhost or to a remote server. I can look for it if you want.

[slapshotw]

Use rsync with the cron...you'll save a LOT of resources and bandwidth.

[php_dev]

Originally Posted by Impavidus

Min Hour Day Month WeekDay Command
0 0 * * * php /home/username/backup.php

You can use cpanel's Cron Manager to create a job and run this command:

php /home/username/backup.php

I am using perl mysql backup script for our backups, but I create a php verison which creates backups to the localhost or to a remote server. I can look for it if you want.

YES .Look for it! i am afraid to manage cronjob (i don't want to do another mistake).
0 0 * * * php /home/username/backup.php.
The asterisks are for the day,month and weekday.
And so the string should be:
0 0 22 6 * php /home/username/backup.php
to start the cronjob to midnight of 22 June.It is true?

[php_dev]

Originally Posted by slapshotw

Use rsync with the cron...you'll save a LOT of resources and bandwidth.

Hi slapshotw,
i have already seen your example on another post about rsync but i don't know how to manage linux and so i don't know the differences for rsync and sync. But my db is really big and so if rsync can save resources can you explain me about it?

[php_dev]

Hi GatorJay,
Google is spidering my site just now.... how many time for the backup?

[slapshotw]

Originally Posted by php_dev

Hi slapshotw,
i have already seen your example on another post about rsync but i don't know how to manage linux and so i don't know the differences for rsync and sync. But my db is really big and so if rsync can save resources can you explain me about it?

Rsync only sends over the changed parts of the database. Even with a 90db database, you have to assume that at least 50-70% of it isn't changing day after day. Rsync only sends the new and changed bits.

[php_dev]

Originally Posted by slapshotw

Rsync only sends over the changed parts of the database. Even with a 90db database, you have to assume that at least 50-70% of it isn't changing day after day. Rsync only sends the new and changed bits.

Thank you slapshotw.This is ok for me. Every day are inserted 1000 new rows and i want to backup only the new rows. In this way i can have updated backup without donload big files every time. What is the string for the rsync?

[Impavidus]

PHP Code:

<?php 
if($_SERVER['REMOTE_ADDR']) { header("HTTP/1.1 404 Not Found"); exit; } // Allows only the Local Server

// DB Setting
$dbuser = "";
$dbpass = "";

// Settings
$time = date("Y-m-d-H-i-s");
$filename = "mysql_backup_" . $time . ".sql.gz";
$localpath = "/home/username/mysqlbackups/";
$localfile = $localpath . $filename;
$nbackups = 7; // Number of days to keep backups

// Remote Setting
$mode = 0; // 0 = Remote Server Disabled; 1 = FTP;
$server = "";
$remoteuser = "";
$remotepass = "";
$remotepath = "path_on_remote/";
$remotefile = $remotepath .  $filename;

exec('find ' . $localpath . ' -mtime +' .$nbackups . ' -exec rm -f {}');
exec('mysqldump --user' . $dbuser . '  --password=' . $dbpass . ' --all-databases --single-transaction | gzip > ' . $localpath . $filename);

if($mode == 1) {
    $ftp = ftp_connect($server); 
    $ftp_login = ftp_login($ftp, $remoteuser, $remotepass); 
    
    if (!$ftp || !$ftp_login) { 
        echo "FTP connection has failed!<br />";
        echo "Could not connect to $server<br />";
        if($ftp && !$ftp_login)
            echo "Incorrect username and/or password<br />"; 
    } else {
        echo "Connected to $server for user $remoteuser<br />";
        $upload = ftp_put($ftp, $remotefile, $localfile, FTP_ASCII);
        if (!$upload) {
            echo "FTP upload has failed!<br />";
        } else {
            echo "Uploaded $localfile to $server as $remotefile<br />";
        }
    }
    ftp_close($ftp);
}
echo "Done $time";
?>

[Impavidus]

I want to backup only the new rows

I do not think that is possible. You would still need to do a mysql dump and use rsync to transer the change part of the file to a remote server. I not good at rsync yet!

[php_dev]

Thank Impavidus. Great script.

[php_dev]

Hi Impavidus,
If the script allow only local server how i do to start the file?

[Impavidus]

cron job with the following command:

php /home/username/path_to_backup_script/backupmysql.php

You can comment out the first line to test it in a browser, but I would not recommend keeping it commented out.

[php_dev]

Originally Posted by Impavidus

cron job with the following command:

php /home/username/path_to_backup_script/backupmysql.php

You can comment out the first line to test it in a browser, but I would not recommend keeping it commented out.

Done! I have just uploaded the file and started the cronjob. It work fine! Thank you.I am sure your script will be useful for more others users too.

[Impavidus]

I glad that the script works fine and everthing else works.