restore mysql backup
 

I'm backing up a joomla site .Because it's the first time i do this what's the general procedure i have follow to restore the site on an another host,still debian.I'm backing up by a really nice script which is a mix of rsync , ssh , mysqldump and few more unix commands.
I have backups sorted by date from when the backup started up to current.My doubt is:it is an incremental backup so where is going to be the complete list of files?Do i have the overwrite all the directories in the backup folder ?
From the command line how do i backup the database ?Which one is the complete one? sorry for the silly question but i can't afford to loose all he work on this site.thanks !

Whoa! That's a pretty good collection of backups, but pretty much useless if you can't figure out which one to use.

You'll need to figure out which one contains your last FULL backup, restore that first using
mysql -u username (-h hostname) -p your_joomla_database_name < fullbackup.sql
Use the -h hostname only if you're connecting to a different mysql server from the machne where you execute this..

After you've done that, you'll need to restore each incremental in the same order in which they were taken.

Alternately, just take a fresh full backup with
mysqldump -u username (-h hostname) -p your_joomla_database_name > fullbackup.sql
and simply restore it with the command above.

Hi

Just wanna give another tip I learned from somoneone. If you have those files, and the server completely dies, it will probably take you a little while just to get another Debian server up with all the packages that you use.

In the backup script, add the line, e.g.
dpkg --get-selections >/etc/debian.packages.txt

The file "debian.packages.txt" now has a list of all packages on the system. If you need to set up a new server, set it up with just a base system, then do a:
dpkg --set-selections </etc/debian.packages.txt

Then start e.g. dselect, select install and you have the same stuff installed. I think this could be more useful than a backup of the kernel.

Hate to burst your bubble but mysqldump doesn't do incremental backups, just full dumps, unless you've got some nifty script that is picking up just the changes from the binary logs that you had to enable in order to get incremental type backups running. If not, then you're latest dump would be the backup you'd want to reinsert into the new host mysql server, or depending on the size, disable your site and take a snapshot now to transfer over and bring the site up on it's new host.