alf_content_data and alf_content_url diferent total row??

[pablobenavides]

Hi everyone!

I have a question with my alfresco database, tables alf_content_data and alf_content_url no matches in total rows.

alf_content_url rows = 976 352
alf_content_data rows = 1 361 987

it's normal ?  how make equals rows?

-Pablo Benavides

[mrogers]

It is not a problem.    

One factor is that content_url_id can be null if there's no content.    I'd also anticipate that you could have shared content if nodes are copied.

[pablobenavides]

The problem is that in the mysql server dedicated the hard disk has damage and had to move emergency database. We replace the IP in the new server mysql with configurations equals of the server damaged. In theory, is ok! but, files are no found when looking from applications developed than before if they were. We apply reindex thinking so would be solved but it did not work. We have no backup mysql, just one copy the database of the another server. What happened ? No way to generate the alf_content_data and alf_content_url from contentstore directory? the contentstore have all files.

Help me!


-Pablo

[rjohnson]

Reindex fires up Lucene or SOLR to re-index your content. It finds that content by querying your database. These indexes are entirely separate from the database that contains the metadata and pointers to the actual documents on the disk. You have to back up your content, indexes and database regularly if you want to be sure you can recover from failure and you need to do it all at the same time whilst Alfresco is stopped or follow a very rigid pattern to create a hot backup. If you are virtualised you can snapshot the entire machine.

If you have no backup of your mySQL database you have a big problem. About all you could do would be to use the bulk importer to do an in-situ import of your content from your existing repository but this would give you essentially meaningless file names, a folder structure from hell and no metadata.

Do you really have no copy at all of your mySQL database files?