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.

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!

Find more posts tagged with

Comments

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