nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Embedded mysql database location - version 3.4a

golash

Hello -

I have installed version 3.4a using the 64-bit linux installer using the embedded mysql that comes with the installer. Everything works fine, adding/deleting content etc on both Share & Explorer. The database is obviously functioning.

I am now trying perform backup tests. From what I have read, I have to back up the 'alf_data' directory and the database. However, when I cannot find the 'alfresco' database in mysql

for example, when I type: 'mysql -uroot -p password' and then 'show databases', I cannot see any database named 'alfresco'. I have also tried starting mysql as user 'alfresco' but can't log in.

Where is the database located when using the embedded mysql database? How can I back it up and also drop it?

Thanks.

Find more posts tagged with

Comments

golash

It appears that no one has run into this issue or my original post is unclear.

I have a fully functional Alfresco 3.4a installation (working really well). I had installed it using the standard community 3.4a Linux installer on a brand new server. I installed it as 'root'. Since there was no mysql instance on the server, I let alfresco install and configure the mysql database.

I don't understand the difference between the mysql that comes with the alfresco installer and if I had installed it before installing alfresco. However, now, I don't see any 'alfresco' database (or any other database other than 'mysql' & 'information-schema') when I type 'show databases'. It clearly exists, otherwise alfresco wouldn't work.

I figure that as 'root', you should be able to see the 'alfresco' database in mysql. Any idea on why I cannot? I installed everything as root, could this be a permissions issue?
Like I mentioned in my earlier post, I am doing this to be able to back up the alfresco database and the repository.

Thanks.

golash

If anyone is a Linux rookie like me, here's the answer:

I was logging into the default mysql copy running in my system (which I didn't recall installing with Ubuntu), therefore there was no Alfresco database there.

Since I had chosen to use the mysql packaged with alfresco, a seperate mysql instance was installed. To interact with this database you have to always type the complete path to the mysql directory, in my case: /opt/alfresco/mysql/bin/mysql -u username -ppassword

Then if you type "Show databases;" 'alfresco' database will be listed.