topic Backing up MySQL db from Alfresco Community in Alfresco Archive

Backing up MySQL db from Alfresco Community

trying2alfresco — Thu, 20 Jul 2006 14:57:10 GMT

Hello,I was wondering if anybody knows how to backup the MySQL db from the Alfresco Community version 1.2.1. I cannot do mysqldump when Alfresco is running, but if I turn of alfresco than I can't do the dump either. So I am not sure exactly how to proceed in performing the backup. Any help would be

Re: Backing up MySQL db from Alfresco Community

trying2alfresco — Thu, 20 Jul 2006 14:58:26 GMT

oops I posted in the wrong thread. anyways I can move this message to Installation.

Re: Backing up MySQL db from Alfresco Community

steve — Thu, 20 Jul 2006 16:42:21 GMT

Moved on your behalf.

Re: Backing up MySQL db from Alfresco Community

trying2alfresco — Thu, 20 Jul 2006 16:51:57 GMT

thanks.

I stopped alfesco for a bit and now when I am trying to starting it again I am getting the following error message.

/usr/local/alfresco-1.2.1/bin/alfrescoctl.sh : mysql started
chown: `mysql': invalid user
Starting mysqld daemon with databases from /usr/local/alfresco-1.2.1/mysql/data
STOPPING server from pid file /usr/local/alfresco-1.2.1/mysql/data/static-host.pid
060720 12:48:08 mysqld ended
Any idea why?

Re: Backing up MySQL db from Alfresco Community

trying2alfresco — Thu, 20 Jul 2006 16:58:35 GMT

and how to fix it?

Re: Backing up MySQL db from Alfresco Community

trying2alfresco — Thu, 20 Jul 2006 17:09:44 GMT

static-host.err contains the following error message. So it looks like the mysql user is missing, I don't know how to ad this user to any help would be appreciated.

060720 12:55:46 [ERROR] Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

060720 12:55:46 [ERROR] Aborting

060720 12:55:46 [Note] /usr/local/alfresco-1.2.1/mysql/bin/mysqld: Shutdown complete

060720 12:55:46 mysqld ended