Backup whole SugarCRM folder enough?

[pierre123]

Hi, I have Sugar running on a Windows machine.
I want to create a backup of everything, including the database etc.
Is a backup of the SugarCRM folder enough to cover everything?

Thanks in advance,
Pieter

[kbrill]

Not generally, you still have to backup the database. I have tools for linux but not Windows. I am sure there are scripts available to export the database to a file.

[TakeMarket]

1)You need to backup the DB/DB's separately.

2)You need to take a "traditional backup" notice the quotes right?, because there a many flavors of server backups and methods depending on your company's individual needs - but basically you need to take full/or differential backup of the server it selves or whatever data you want to protect on the server on a day basis - from server--> disk -->> disk --> tape or what ever your data backup method you/your company are using.

[pierre123]

Hi Kbrill, thanks for your answer. That clears up the question.
Now I will start looking for a tool to get the database out somewhere.

Regards,
Pieter

[pierre123]

1)You need to backup the DB/DB's separately.

2)You need to take a "traditional backup" notice the quotes right?, because there a many flavors of server backups and methods depending on your company's individual needs - but basically you need to take full/or differential backup of the server it selves or whatever data you want to protect on the server on a day basis - from server--> disk --disk --> tape or what ever your data backup method you/your company are using.

Hi Takemarket, you are right. I need to make a total backup in case the hardware ever crashes or something like that.
So I do a traditional folder backup, and I look for a tool so I can make a backup of the database which seems to be hidden somewhere .

Regards

[MilSp3c]

Get's a little more advanced as far as what information we should be requesting from you.

A.) Are you using a binary package that was available from the SugarCRM website on your windows install?

B.) If you're using a standard install. Meaning installing all applications seperatly, then you'd want to check where the files are saved.

I see you are using a windows box. Let me say, cmd rocks.

On your keyboard, press and hold win + r then release.
same result: click start, click run.

Type cmd
hit enter

type cd \
hit enter

will take you to the root of your C drive.

type dir *.MYD /s
hit enter

that will return all the MYD files located on your system. The folder you will be trying to locate is the folder of the database name that you have your sugarcrm contained in.

This folder, as well as the web folder containing the files will provide you with a complete back up. You just need to remember to recreate the user account within the new mysql database.

Hope this gives you a little more insight on what you need to do.

If you locate the exact folders, can show you how to write a quick batch script, and include it in your start up files to create a back up everytime your pc starts up

Best of luck.
MilSp3c

[pierre123]

Get's a little more advanced as far as what information we should be requesting from you.

A.) Are you using a binary package that was available from the SugarCRM website on your windows install?

B.) If you're using a standard install. Meaning installing all applications seperatly, then you'd want to check where the files are saved.

I see you are using a windows box. Let me say, cmd rocks.

On your keyboard, press and hold win + r then release.
same result: click start, click run.

Type cmd
hit enter

type cd \
hit enter

will take you to the root of your C drive.

type dir *.MYD /s
hit enter

that will return all the MYD files located on your system. The folder you will be trying to locate is the folder of the database name that you have your sugarcrm contained in.

This folder, as well as the web folder containing the files will provide you with a complete back up. You just need to remember to recreate the user account within the new mysql database.

Hope this gives you a little more insight on what you need to do.

If you locate the exact folders, can show you how to write a quick batch script, and include it in your start up files to create a back up everytime your pc starts up

Best of luck.
MilSp3c

Hi MilSp3c, sounds great . Thx!

I will check/try it out. Will message the results when I'm done.

Regards,
Pieter

Btw, yes, I am using a binary package that was available from the SugarCRM website on my windows web server.

[MilSp3c]

Hi MilSp3c, sounds great . Thx!

I will check/try it out. Will message the results when I'm done.

Regards,
Pieter

Btw, yes, I am using a binary package that was available from the SugarCRM website on my windows web server.

I haven't looked at the binary installs in a little while. Try running those commands, or possibly someone else might have some extra input.

[pierre123]

I haven't looked at the binary installs in a little while. Try running those commands, or possibly someone else might have some extra input.

Hi MilSp3c. Unfortunately the dir *.MYD /s is not recognized. So I will have to try something else .

Regards

[TakeMarket]

Hi MilSp3c. Unfortunately the dir *.MYD /s is not recognized. So I will have to try something else .

Regards

Note that it's always better to manually install software (not only) like for example SugarCRM, but generally (php, perl, forums ect. or whatever...) for many reasons which we will not mention here.

But fact is; If you run the DB on MS SQL server 2005 express you will have the backup feat. available out-of-the-box *

* the full automatic backup scheduler is only included in the full version of sql server 2005, but you can find a guide on how make automatically backups with sql server express ed. here:-->> Automating Database maintenance in SQL 2005 Express Edition Part I

And here: -->> Automating Database maintenance in SQL 2005 Express Edition Part II

You can grab the sql server express here: --> Microsoft SQL Server 2005 Express Edition