Hi all

i have a VPS with wmh/cpanel

i was wondering what you guys think is the best way to back up my forum i have

at the moment im using the backup facility in whm to back up my cpanel account to a seperate server

i really wanted to keep a weeks worth of backups but it overwrites the one on the server all the time

this is also all new to me so i may need an idiots guide :D

thanks in advance

stu

Hi Stu_m,

I need more information about your case to help you:

- Which is the forum software that you use?
- Have you a direct access to the Server?
- Are you a newbie?

tell me about you and I will try to help you,

regards

Hi

thanks for the reply

i use phpbb3
yes i have full root access
and not so much a newbie to forum software its VPS im all new to

and i must say im all sorted now i posted in another section and got a few answers

im backing up through WHM to my back and using cron job on the back up server to move the files into daily folders so i can keep a full weeks back up

the only problem i can see with this is if i get 1 currupt file its not easy to restore that one file and same for the database if one table becomes currupt then same again its not easy to just replace that one table

so if you have any other solutions im all ears

Stu

Hi Stu

I will suggest you a simple command using the bash shell and mysqldump in order to dump all the db. If you execute this command the tables will be not corrupted.

try this:
mysqldump --database mydbname mysql > backup.sql -u root -p mypassword

regards

Regarding the corruption.
I would suggest after each backup to run something like
mysqlcheck -C -a -o --auto-repair

It will check, analyze and repair the Database if possible.
You could set this up in your cron so that you receive an email when an error occurs.
This way you would know immediately about corruption.

I would mysqldump and then rsync the static contents and dump'ed sql/data to an offsite location.
Actually VPS cost is so low nowadays, that having a warm standby site is also an option.

Hi,
I am having wordpress and forum I use is a BBpress, is there any plugin you can suggest? I dont want to do it from command line since I dont have root access. I need just a plugin (free) to carry out the same.

Hi,
I am having wordpress and forum I use is a BBpress, is there any plugin you can suggest? I dont want to do it from command line since I dont have root access. I need just a plugin (free) to carry out the same.
Hi there,
Please let me know incase some one knows the right plugin

I think the best way would be to make full account backup from your cpanel.

Try R1 Soft backup. It costs some $ but its best for your requirements!

Most vps systems have some type of image backup, but don't rely completely on this.
Always good to do a full backup of the accounts using whm/cpanel backup/restore tool (remotely or locally) if locally will only keep daily, weekly and monthly I think make sure you pull out the backups outta there with ftp.
You can also try r1 soft as an alternative for image type backup.