topic copy mysql db to new server in Alfresco Archive

copy mysql db to new server

simonmags — Mon, 16 Jul 2007 00:53:30 GMT

Hi, I have a problem with my old server (solaris 10) and it will not start alfresco anymore. I am building a complete new server on suse linux 10.1 and want to get all the information from the old server to the new server.I thought that finding and copying the mysql database would copy everything th

Re: copy mysql db to new server

simonmags — Mon, 16 Jul 2007 00:56:51 GMT

Also I forgot to ask, what is the default database name for an alfresco server and is there a way to tell which database it is using if there are more than one installed. i.e. I have two mysql databases, only one is running but i want to make sure I backup the right one.

Is this process documented somewhere already?

Re: copy mysql db to new server

simonmags — Tue, 17 Jul 2007 23:29:37 GMT

bump,

is this something that's hard to do? Is that why no one is answering?

Re: copy mysql db to new server

kevinr — Wed, 18 Jul 2007 14:03:25 GMT

Default schema name is 'alfresco'.

You need a copy of the DB dump plus the alf_data directory (which contains the lucene-indexes and the content structure).

Thanks,

Kevin