AnsweredAssumed Answered

Alfresco MySQL Account & Data Move

Question asked by bensewell on Jun 13, 2011
Hi just setting up a new MySQL server to hold the Alfresco data and transfer our current live server.  What permissions does the account associated with alfresco need?  Just checking the permissions of the alfresco local user that installs during the process has the following rights:

OBJECT RIGHTS:
SELECT
INSERT
UPDATE
DELETE
EXECUTE
SHOW VIEW

DDL RIGHTS:
CREATE
ALTER
REFERENCES
INDEX
CREATE VIEW
CREATE ROUTINE
ALTER ROUTINE
DROP
TRIGGER

OTHER RIGHTS:
CREATE TEMPORARY TABLES
LOCK TABLES

Lastly the plan to move the data was to shutdown the alfresco service, start up the MySQL database, use MySQL Dump to export all the data off, import to the new server then change the global config file to point to the new location.   Does this sound correct?

Thanks, Ben

Outcomes