Backup and restoration

[Mag]

Hi,

I have a machine (CentOS v 4.3 ) running SugarCRM (v 4.0d) with mySQL (v 4.1.12)
I am backing up everyday MySQL database (InnoDB mode)

I tried to restore the database on a different machine.. it doens't work !!!!

1) My MySQL backup is OK,but if I try to restore the file file with NySQL Admintool, I have the error message :
The MySQL Server returned this error
My SQL Error Nr 1064 - You have an error in your SQL syntax; Check the manual

I didn't touch anything... I am restoring with a simple backup file

- Do you know what could be wrong ?

2) I've never used , in SugarCRM -> Admin -> Backup
I always TAR the folder directly instead of using the SugarCRM function ...
- is there a difference ?

3) I don't know if my database is corrupted or not... should I use before backuping up, the repair functions ?
I am scared to break everything now... It seems that I don't have a good backup !

- how do you backup your database ?

- How do you backup your Mysql databse ? innoDB ? or full backup ?


Thanks for your help ...

[stevec]

On thing I've found with some backup tools is that the comments placed within them are not always interpretted as comments when restoring - ending up with syntax errors.

Try editing the file and deleting the leading commented out text - there's normally a large block of comment code at the beginning.

As for the files backup - I always just tar it too - I believe the admin tool is there for hosted servers where the customer does not have shelll access.

For info - we dump the whole database via a schedule and back that up. We'll soon move over to a slave replicated server and back that up

[paikmoses]

Hi Mag,

To take the back-up check this out: http://sugarcrm.openapp.org/?p=141

To restore the back-up check this out: http://sugarcrm.openapp.org/?p=142

Hope this helps.

Regards,

[Mag]

THanks for the trick...

I just mad another test, I didn't use MySQL Admin software for Backup and restore, but I did use webmin to backup
then I came back on MySQL admin software to restore... that seems to be OK !!

I will push further the test but this is this bloody softwre, which is the cause of my problem

Thanks !!

[prismz]

hope this helps:
to transfer sugar crm application from one machine to another, install a fresh installation on the other machine. after installation is complete, do a backup and restore of database using the help from the following two links:
http://sugarcrm.openapp.org/?p=141
http://sugarcrm.openapp.org/?p=142

remember to drop the database on the new machine before doing a restore so that its a fresh restore

to copy the modules and rest of the changes u made, stop the sugarcrm so that all the services stop, rename the oss on the new machine to oss2 and then copy the oss from the original machine to the new machine.
u should be good to go with all the previous configurations and changes u made in the modules