Backup problems in 1.4

[Chad]

When I try to run the backup I get an Error Return Code 2.

I haven't seen this anywhere else in the forums.  I do have the db.sql showing up in /tmp/backup but there is nothing in the file.

Any ideas?

Thanks much all

[Frits]

Yesterday I has a simular problem, but with return code 1.

Connecting to an existing database  from another installation solved the problem.
So, I reinstalled the package with a fresh datbase and now it is working. Don't ask why.

[Filip]

I have the same problem (return code: -1)

I can't start with a fresh database there is already to much data available.

someone has a solution?

[Dutchie]

If you're having database backup issues and are using mysql on a *nix, you can do what I'm doing.
Requirements:
ssh access to your database server
vi editing skills 
the script: automysqlbackup.2.5.sh (google it)
Edit the script to your liking, be sure to read it all through until you reach the actual execution part!
Try it, verify that the backups are there...
Make sure it's executed by cron every night, preferably have the files copied onto another machine.

All done...
Happy backupping! 

[Frits]

What you also can try is chmod 777 on the directories backup and saveatt in tmp.

When I uploaded OpenGoo via ftp, this solved my backup problem (err code 1).

[Filip]

I have changed the settings but still get the same error. (An error occurred while creating the database backup: Return code -1) even after installation of OpenGoo 1.4.2 

[Karl]

I changed (chmod) folders "backup" and "saveatt" in folder "tmp" to 775 and then the backup works.

[Filip]

the problem persists even after changing the folder properties 

the project OpenGoo is beautiful, but it is not reliable as long as I can't take backups. (company policies)

[Karl]

I have installed OpenGoo within 2 different domains on the same server (CentOS). But the group and owner of the folder "backup" differs:

The first installation: Group an owner is the site owner.

The second installation: Group and owner is "apache".

I don't know why there is this difference. But on the second installation (group and owner "apache") the backup works fine without changing the folder properties.

Maybe you should change group and owner too.

[Filip]

Karl,

thanks for the reply

I'm running the OpenGoo on a Synology DS207+.
* MySQL 5.0.51b
* Apache 2.28

I get directory information with the FTP-client "FireFTP" (add-on Mozilla FireFox)
I use the default backup folder from OpenGoo
* tmp-folder
   - group = users
   - user = guest
* backup-folder
   - group = nobody
   - user = nobody
* saveatt-folder
   - group = users
   - user = guest

I do not know how I must change the owner and/or user.

Filip

[Pet]

Filip, don't forget that you can always make backups from outside of OG.  Use any mysql backup tool, then all you have to do is reinstall OG and restore your db. This can at least get you around your company policy until you get OG backup working.

[Filip]

yes, the unfortunate thing is that I always have to backup manually instead of automatically. (through Cron settings of OpenGoo) 

Can I configure/schedule phpMyAdmin for making backups?

[fcoauga]

the problem persists even after changing the folder properties 

I have the same problem, nothing happens with CHMOD changes...

[Pet]

Can I configure/schedule phpMyAdmin for making backups?

I don't believe so, Export is a manual procedure.