Koozali.org: home of the SME Server

Obsolete Releases => SME Server 7.x => Topic started by: Peterbo on March 09, 2009, 10:02:36 AM

Title: affa and mysql backup
Post by: Peterbo on March 09, 2009, 10:02:36 AM

HI

Someone who knows why affa is not making a backup of mysql?
has 2 sme 7.4 server running backup, is on the same server
but only one of them backup mysql.

hope someone can give an answer to my problem thanks in advance.

Title: Re: affa and mysql backup
Post by: Stefano on March 09, 2009, 10:21:32 AM

Hi Peterbo and welcome

could you please explain your setup and your issue?

Thank you
Ciao
Stefano

Title: Re: affa and mysql backup
Post by: janet on March 09, 2009, 10:35:05 AM

Peterbo

Affa uses the standard sme server backup scripts, which include doing a dump of the mysql tables as part of the backup routine. So by default Affa does backup mysql data.

What makes you think the mysql data is not being backed up ?

You do need to explain more fully and provide far more details

Title: Re: affa and mysql backup
Post by: Peterbo on March 09, 2009, 11:00:48 AM

hi

When i restore from tdsserver there is no tabel in the db when i look with phpmyadmin and the
homepages is not working.

var/affa/tdsserver/scheduled.0/home/e-smith/db/mysql it is empty, but on the other one
var/affa/atkiserver/scheduled.0/home/e-smith/db/mysql there is a dump for all the db

I am using 2 x Dell PowerEdge R200 Server and, 1 Dell PowerEdge R200 for the backup

i am not to good with sme server only used them for 2 months so are still learning  :eek:

Title: Re: affa and mysql backup
Post by: Stefano on March 09, 2009, 11:10:36 AM

Quote from: Peterbo on March 09, 2009, 11:00:48 AM

var/affa/tdsserver/scheduled.0/home/e-smith/db/mysql it is empty, but on the other one

please go to tdsserver console and digit

Code: [Select]

mysql

you should enter mysql's console mode (if so, exit with "quit")

then give

Code: [Select]

signal-event pre-backup

and look in /var/log/messages for any usefull info.

I suspect there's a problem with mysql password

anyway, please open a bug in bugzilla, thank you

ciao
Stefano

Title: Re: affa and mysql backup
Post by: David Harper on March 09, 2009, 11:48:21 AM

http://wiki.contribs.org/Bugzilla_Help#Reporting_Bugs

FYI

Title: Re: affa and mysql backup
Post by: Peterbo on March 09, 2009, 12:55:16 PM

ok i try that tomorrow when i go to work again

but thanks for the help for now

Title: Re: affa and mysql backup
Post by: Peterbo on March 11, 2009, 09:06:49 AM

Problem fixed i have a m8 who had change the mysql passwords
so after i reset the password the backup is working.

thanks for the help.

Title: Re: affa and mysql backup
Post by: cactus on March 11, 2009, 06:36:26 PM

Quote from: Peterbo on March 11, 2009, 09:06:49 AM

Problem fixed i have a m8 who had change the mysql passwords
so after i reset the password the backup is working.

Tell your friend not to do so again as this is not needed on SME Server to access MySQL. Mor information on this is in the MySQL section of the wiki: http://wiki.contribs.org/MySQL .