mysqldump command fail

gdowrey — Thu, 24 Feb 2011 17:44:37 GMT

I have intalled Alfresco Community 3.4.d on an Ubuntu Server 10.04 server using the quick install with the bundled mysql database. The Ubuntu server only had ssh installed; mysql was not installed. When I use the mysqldump command: mysqldump -u root -p –default-character-set=latin1 -N alfresco >

Re: mysqldump command fail

sjoerdjump — Tue, 15 Nov 2011 12:48:53 GMT

Hi,

I dont think that this is still relevant but here it goes.

I had the same error, but after a couple of hours ( ) i managed to make the dump.

The mistake i made was this: wit ./opt/alfresco/alfresco.sh stop i also stopped the mysql server.

so, if you stop Alfresco using the script, make sure to restart mysql: ./opt/alfresco/mysql/scripts/ctl.sh start (from memory)
Recently i red somewhere that you can also stop the tomcatserver, but havnt tried this yet.

Also, i replaced /etc/my.cnf with the /opt/alfresco/mysql/my.cnf <- i'm not sure if this is really nececerly… I can imagine that it might muck up mysql as a whole on your server.

Hope this is helpfull for someone.

Cheers.

Sjoerd

topic mysqldump command fail in Alfresco Archive

mysqldump command fail

Re: mysqldump command fail