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.

[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.