Can Someone Post a Backup Tutorial

[snnowwy]

Hi there,
I am on the verge of implementing my new helpdesk (a daunting prospect based on the posts here) but before I do I have to source the right server and backup hardware.

This would be a much simpler process if I were able to work out the best way to backup the system.
I want to be able to reinstate it in a disaster recovery situation.

I have searched these forums extensively but found nothing other than a few pieces of advice on how to restore a backup, not make one in the first place.

I'm a bit of a noob so if someone could compose a "for idiots" tutorial it would be great.

Perhaps this could inspire other tutorials on other common areas (such as active directory integration) which could form a quasi manual to supplement the (quite frankly insufficient ) official one.

We might even ask Kayako to publish them in their knowledge base.

Who's with me?
S.

[snnowwy]

Bump.

Nobody want to step up to the plate?

S.

[User Name]

If you have shell access:

Backup:

mysqldump -uUSER -pPASSWORD DATABASE > backup.sql

Restore:

mysql -uUSER -pPASSWORD DATABASE < backup.sql

You can put the backup code into a cronjob if you like.

[gerardo]

Hi,
I believe you also have to backup files dir, as well as config.php. Files directory contains attachments sent by users.

Note from a thread from Varun talking about an upgrade, nevertheless might be useful:
1) Make sure you backup before proceeding, You should backup both the database and files
2) Make sure you move the contents of files directory back and dont delete them when upgrading. This is very important, not doing so might result in loss of attachments and quick drop down menus not working

Hope this helps putting something together.

cheers,
gerardo

[User Name]

Yep, forgot about those. You could tar up a backup of the files directory.

cd /home/esupport/
tar -cfpz files.tar files