mysqlarchivemyisam
MySQL cannot convert its engine from MyISAM to ARCHIVE
The table whose engine needs to be converted is only for read purpose and its content will never change. So I want to convert the engine of the table as ARCHIVE, but when I tried to convert it, I got the error below.
Error Code: 1069. Too many keys specified; max 1 keys allowed
The version of MySQL is 5.5. Is this index related problem?
Solution
Looks like it definitely is a PK problem since archive does not support primary keys. You can simply drop the primary key and it should work.
Refer to this post for examples on how to convert your db
- is there any way to check with cumulative way to get month based on the amount fields
- How to compare using bcrypt in a db query using node.js and express
- SQL query to check if a name begins and ends with a vowel
- MySQL JSON_OBJECT() datetime format
- Why is MySQL Sorting by mp.id in This Query Execution Plan?
- PHPExcel download not working properly
- brew start and brew restart wont start service
- MySqlCommand().ExecuteReader().GetString() does not work
- how to sum rows together but also leave the original rows in the results?
- Postgres vs MySQL index locking: Should I expect MySQL to be more tolerant to parallel write-heavy applications?
- Java - Having a huge ArrayList (1 million +), how to create a String of it in a acceptable amount of time?
- SQL filter for same values in different columns
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- MySQL - Does the READ UNCOMMITTED isolation level use locks?
- convert mysql timestamp into actual date and time?
- Optimize order by rand()
- Change max_heap_table_size value?
- wordpress - Big post IDs, is it Okay in the future?
- Incorrect string value error for unconventional characters
- Cannot open include file: 'mysql.h': No such file or directory
- How do I connect Biostar V1.8 Suprema to MySQL?
- How to convert a string to date in MySQL?
- Duplicate records in MySQL. EXISTS check for the same data not working properly?
- How to define a custom ORDER BY order in mySQL
- On duplicate key ignore?
- How to fix MySQL providing duplicates that do not exist?
- What's the best MySQL alternative to dual?
- mysql SELECT issue with HAVING and/or WHERE
- How can I connect an externally hosted MySQL database to BigQuery?
- DBeaver error resolving maven dependencies