[opencms-dev] MYSQL Dump corrupt

[Joachim Arrasz]

Hy Thomas,

that`s the problem, the structure as sql is correct, i can play it into
the mysql. But Opencms crashes with the errors i pasted in the last
thread("Urgent...") a few days ago. So now we tried a new installation and
it wasrunning correct. Then we played the old dump in it and the servlt
crashes again after the mysql request
"SELECT PROJECT_ID, PROJECT_NAME, PROJECT_DESCRIPTION, TASK_ID,
 USER_ID, GROUP_ID, MANAGERGROUP_ID, PROJECT_FLAGS,
PROJECT_CREATEDATE, PROJECT_TYPE FROM CMS_PROJECTS WHERE
PROJECT_ID=1 ORDER BY PROJECT_NAME;"

But on the developer enviroment this line is exactly the same!!!

So i`m not sure but i think it`s a error which belongs to a failed entry
from opencms itself.
thx in advance

Achim
-- 
Questions about OpenCMS?
--> www.synyx.de/board


> Thomas März>
> "Joachim Arrasz" <info at arrasz.de> writes:
>> Does anybody know how to check the MySQL structure for Opencms?
>
> | mysqlcheck
> |   This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE
> (-a) |   or OPTIMIZE (-o) tables. Some of the options (like -e or -q)
> can be |   used same time. It works on MyISAM and in some cases on BDB
> tables. |   Please consult the MySQL manual for latest information
> about the |   above. The options -c,-r,-a and -o are exclusive to each
> other, which |   means that the last option will be used, if several
> was specified.
>
> Copy (e. g. use mysqlhotcopy) your database to a safe place before
> using mysqlcheck. Check also if there is enough space on the hard disk.
> (I ran in this mistake some times.)
>
> Best Regards,
> Thomas Maerz
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit http://mail.opencms.org/mailman/listinfo/opencms-dev