MySQL Forums
Forum List  »  Newbie

Cannot drop table
Posted by: John Doe
Date: July 06, 2021 07:01AM

Hi,

I've upgrade from Mysql 5.7 to 8.x and for some reason I managed to break a database.

When trying to restore the database - I want to DROP the old one (ab_mydatabase)

root@web01:/etc# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1704
Server version: 8.0.23 MySQL Community Server - GPL

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> DROP DATABASE ab_mydatabase;
ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

Anybody know how to solve this issue? I've been stuck at this all morning.
I can succesfully create new databases etc without any issues. This is on a debian machine.

Options: ReplyQuote


Subject
Written By
Posted
Cannot drop table
July 06, 2021 07:01AM
July 06, 2021 07:59AM
July 06, 2021 08:32AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.