Jump to content

Alter mysql table column length


softlab

Recommended Posts

Hi.

 

I'm bfpsw on johnny.

 

I'm trying to modify the length of a column in a table of my database (bfpsw_jaw) using phpMyAdmin, but the response is:

 

"#1874 - InnoDB is in read-only mode".

 

It seems it is not possible to rename the table; if I try to drop it, the error is:

 

"#1051 - Unknown table bfpsw_jaw.UTENTI".

 

Can you help me?

 

Thanks

Link to comment
Share on other sites

Johnny's innodb tables were corrupted because of the power outage yesterday. This is why we always recommend people use myisam instead. Innodb is really delicate and is easily corrupted. Make a backup if you can, or if you already have a backup you'll be good. After people have taken their backups we'll repair the innodb tables, but it will likely result in data loss.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...