Hi, Sorry to open up an old thread but I need some help with this.
I also have the same issue with the usercss table being corrupt and not being able to backup my database.
I see you have fixed it and posted the directions however I need a little more hand holding to walk me through this.
Where/how do you do this?
Quote:
CREATE TABLE `usercss` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`selector` varchar(30) NOT NULL DEFAULT '',
`property` varchar(30) NOT NULL DEFAULT '',
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`userid`,`selector`,`property`),
KEY `property` (`property`,`userid`,`value`(20))
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
One question I have is "What is in the usercss table"? I looked at the good one in my 4.2.0 test site and it was blank. Is there anything important in there?
I just checked the table status and it's create and update date/time are the same so it looks like nothing has ever been done with this table.
Create: 2013-03-01 12:06:53
Update: 2013-03-01 12:06:53
Check: 2013-03-29 16:19:11
From PHPmyadmin can I just drop the corrupt usercss table or can I try to import the blank one from my test site?
Thank for any help you can provide.
Brian