Alfresco Database

[johnny23]

Hi all,

I am new to Alfresco, so please be patient to me.

I have a big issue with my Alfresco Database.

Few days ago, my database have been corupted, at least some tables. Now mysql won't start and if it starts, after I access some files, it stops. I've tried to repair the database using some of the following methods:
- mysqlcheck
- repair
- dump
- force recovery
I can force mysql to start, without using undo or redo logs but I can't access tha data from tables.

I have an older back-up of the Alfresco Database, but I need all the data since that back-up too.

Please help me with this issue.

Thank you!

[bisana]

If are able to have the MySQL up, take data from it using mysqldump

mysqldump -uuser -ppassword urdb > urdb.sql ‍‍

Later you drop the DB, create a new DB with the same name and permission and import it back

 mysql -uuser -pwelcome urDB < urDB.sql ‍

[johnny23]

Thanks, but the problem is that I cannot run even a "select" command. All commands that I'm trying to run on the database will crush.

When I tried to use mysqldump, I've received the following:
"Trying to get some variables.
Some pointers may be invalid and cause the dump to abort…
thd->query at 6AAEDDB8=CHECK TABLE `alf_access_control_entry`
thd->thread_id=2
thd->killed=NOT_KILLED".

[bisana]

I am not sure about this suggestion
When you started ur machine did u see any error message or warning message about inodes
I think, you can solve this using "fsck" . I am not sure about this, I advice you to take advice from others also before trying my advice

[johnny23]

Do you mean a check disk? If so, I've already done that and nothing happened. I mulst mention that certain areas on the disk may be corrupted.

Thanks,

[bisana]

u said SQL commands are showing error, what about
trying "mysqldump" , it is done from the OS prompt, it should work

[johnny23]

Hi,

In the post above, I've shown you the message I get when I try to do mysqldump. I'm working only in OS prompt.

Thank you for answering,

[bisana]

Did any chance u changed  the user / group permission of /var or any directory where MySQL has been installed

 /var/lib/mysql ‍

can u do ls -l there and see the permission