Fix mysql error 1069
$10-30 USD
Betales ved levering
I have a windows server with “wamp” and a mysql database that has a table with many columns, and I want to add index to all the columns:
Using sql, for example:
ALTER TABLE ticks ADD INDEX v65_index (v65);
ALTER TABLE ticks ADD INDEX v66_index (v66);
ALTER TABLE ticks ADD INDEX v67_index (v67);
…
But I get the following error:
#1069 - Too many keys specified; max 64 keys allowed
You must solve this problem
Thanks
Prosjekt-ID: #17793776
Om prosjektet
19 frilansere byr i gjennomsnitt $56 for denne jobben
Hi There, How are you doing? how can I access your wamp ? could you please come over chat I will try to fix now. Thanks
I can start right now, I'm interested in this project, I have experience in Mysql - Linux server. Thanks Puedo comunicarme en español
Hi, I have read your requirements, I will definitely help you in configurations and setting up the Project as per your requirements. If you can give opportunity then I will do this job for you. Have a look at my exp Mer
Hi, I did 500+ websites and web applications in 9+ years in CakePHP, Zend Framework, LARAVEL, YII, Wordpress, Core PHP, so i have knowledge of PHP, MySQL, Rest API, AJAX, JAVA SCRIPT, JQUERY... i will do anything as Mer
This is an easy fix, but you should really consider if having a table with that many columns is necessary. If you just want a fix, it will take me a few minutes to do this if I have access to the server.
Hi, it seems you overpassed the maximum table number of indices limit. You might want to do either of 2 things: 1) consider using another DB engine 2) Change your DB relational design. I recommend changing the DB desig Mer
Hello I am an expert in MySQL to maintain a database and fix Issues. I am ready to start work now to Fix Database. I will also Fix Issues, Design and Develop Website, Custom Plugin, Integrate API's, Optimize for SEO Mer
hi please let me know more about this , i will run the indexes . ping me for more info and your exact requirement
I seem some limitation, my opinion to check alternative solution it seem the database is too much normalized, try to normalized as alternative solution , I am ready to discuss further.
Hi, I understand you want to add an index to all the columns. It is one of the worst things you can do to database. It will affect your insertion time and read time highly. If you want a cost effective consultation a Mer