MySQL Backup

JeRicHoOL · Worker Joined: Jul 20, 2008 Posts: 125 Location: Germany

What is the best way to backup my website? I came across 2 programmes named "mySQLdumper" and "bigdump". What do you use or recommend?

I want a 100% backup of my site. This includes every single post and every single pixel.

slackervaara · Worker Joined: Aug 26, 2007 Posts: 111

I use MySQLDumper for backup and restores. It works very well. Bigdump can only be used to restore a backup and you can't backup with it.

jakec · Posted: Sun Aug 10, 2008 1:47 pm

If you are using cPanel you can backup through there.

Gremmie · Posted: Sun Aug 10, 2008 3:07 pm

If you have shell access to your server, or access to cron, just write a cron job to run mysqldump and compress it.

Code:

#!/usr/bin/perl
# mysqlbackup.pl - Gremmie Feb 22, 2008
# For backing up my MySQL databases

@dbs = (
{
db => 'dbname1',
user => 'dbuser1',
password => 'dbpass1',
},
{
db => 'dbname2',
user => 'dbuser2',
password => 'dbpass2',
},
{
db => 'dbname3',
user => 'dbuser3',
password => 'dbpass3',
},
);

chomp($date = `date +%Y%m%d`);

foreach $db (@dbs)
{
$outFile = '/var/local/backups/' . $db->{'db'} . $date . '.sql';
$cmd = "mysqldump --user=$db->{'user'} --password=$db->{'password'} $db->{'db'} " .
" > $outFile";
# print $cmd . "\n";
print "Dumping $db->{'db'}...\n";
`$cmd`;
print "Compressing $db->{'db'}...\n";
`bzip2 $outFile`;
}
print "Done.\n";

JeRicHoOL · Worker Joined: Jul 20, 2008 Posts: 125 Location: Germany

Can someone explain me how to do it with "mySQLdumber"? For a 100% backup I need the database tables and the files on my FTP, right?

slackervaara · Worker Joined: Aug 26, 2007 Posts: 111

You install MySQLDumper on your website and it will backup your database, when you launch a backup with it. It makes the backup from your MySQL-database, that you absolutely not need to upload, because it will find it where it is.

JeRicHoOL · Worker Joined: Jul 20, 2008 Posts: 125 Location: Germany

And do I have to download something or how will it save the backup or actually where will it save the backup?

I'll try this out soon. When I have updated my not finished site. Razz

slackervaara · Worker Joined: Aug 26, 2007 Posts: 111

MySQLDumper compresses the backup and saves it in a folder, where you installed it. I also download each day a copy of this backup to my PC.

The PHP-Nuke files of my site I never backup, but I keep a fresh copy always available on my PC in case a hacker will change the files of my web site, which can happen.