Forum DB Backup

@simplehuman,

If you're in the US send me your snailmail address in a PM, and I'll clean off my bookshelf and send you some old books which may be helpful.

Jeff
 
That is very kind of you JLasman :) Thank You for the offer.

I actually live in the United Kingdom.
 
Guys Can you please check these setting that I've done for automating the Database Backup process a bit.

http://i39.tinypic.com/15qojtx.jpg

Have I got all settings correct for doing a weekly backup of my Databases ? (this was done in Admin Level) Also day of the week [ 2 ] << what day is that ?

Thank you soo much for putting up with a n00b like me. I'm still looking for a good book that will teach me all this stuff.

Thank You.
 
It's hard to tell; we can't see what you see when you pull those sliders at the bottom down.

Are you just trying to back up databases? If so then you can remove most of those files and directories at the bottom.

If you're doing a full backup, then you should check all three settings under Configure Full System Backup.

Remember thast the sysbk system backup doesn't have any resotre capabilities; to use them you're on your own.

After doing a MySQL backup you should check to make sure you're backing up MySQL databases properly, not just backing up the files. It's been so long I don't remember which it does.

Jeff
 
jlasman said:
It's hard to tell; we can't see what you see when you pull those sliders at the bottom down.

Are you just trying to back up databases? If so then you can remove most of those files and directories at the bottom.
Click to expand...

Hi Jeff, Yep I am only trying to do a Database Backup. So I don't think you need to see what's at the bottom of the sliders, neither do I by the way, since I had not ticked the box for [ Backup directories and files listed below ]

jlasman said:
If you're doing a full backup, then you should check all three settings under Configure Full System Backup.

Remember thast the sysbk system backup doesn't have any resotre capabilities; to use them you're on your own.

After doing a MySQL backup you should check to make sure you're backing up MySQL databases properly, not just backing up the files.
Click to expand...

Nope I am not doing a full Backup, just the Database Backup. I understand regarding the Restore.

If I backup the MySQL files .. isn't that the same as Backuping the MySQL databases properly ? :confused:

PS. No body mentioned what Day, Day 2 of the week would be !!

Thanks Jeff.
 
man i suggest you to use admin lever backup/restore and not system backup, first cause got restore option, second cause he do backup in the right way, or, if you dont want to backup all data for each user, i suggest you a script using ssh for make backup automatically.. ofc ive read your not expert, if u need help, i can (if you want and for free ofc) log into your server and configure the same way of backup i got.

regards
 
SimpleHuman said:
If I backup the MySQL files .. isn't that the same as Backuping the MySQL databases properly ? :confused:
Click to expand...
After you get the backup, what file(s) do you get? Are they text files with data that MySQL uses to restore the database, or are they the actual database files? You want the former.
PS. No body mentioned what Day, Day 2 of the week would be !!
Click to expand...
On every system I've ever seen you get your choice of 0 or 7 for Sunday:

0 = Sunday
1 = Monday
2 = Tuesday
3 = Wednesday
4 = Thursday
5 = Friday
6 = Saturday
7 = Sunday

For the future, know you can always look at a file structure in the online manual, for file structures that are supported therein.

For exmple:
Code: 
$man 5 crontab
Jeff
 
You must log in or register to reply here.
Back
Top