Topic: affa and mysql backup

[Peterbo]

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.

[Stefano]

Hi Peterbo and welcome

could you please explain your setup and your issue?

Thank you
Ciao
Stefano

[janet]

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

[Peterbo]

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 

[Stefano]

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

[David Harper]

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

FYI

[Peterbo]

ok i try that tomorrow when i go to work again

but thanks for the help for now

[Peterbo]

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.

[cactus]

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 .