Cannot retrieve resultset data I created a folder in "MySQL Server 5.7\Data" And copied frm,myd,myi files there from another database folder ( mysql 5.1 )
However the data is encrpted and there is a program that sends queries, decrypts and displays the result. ( written in Delphi 7, db component Zeoslib )
Whenever i try to search a big table, i get "Cannot retrieve resultset data" error. I am a total noob and dont know how to solve this.Any suggestions ?

edit: I am not particularly concerned about efficiency and i didnt write the decryptor program, i just downloaded it along with mysql 5.1 data files.Because the data is encrypted i am stuck with using this program for queries.I know several people managed to get this to work so it should be possible.I want to change mysql settings such that the program wont complain when searching big tables ( 50 million entries )
The main issue you are seeing is based on the nature of the encryption.  The Delphi application appears to not be using any native MySQL encryption/decryption mechanisms for the data.  This will result in certain disadvantages when querying for data.  Although the decrypted data is visible to the application while in use, native to MySQL, it has no what of indexing any encrypted data fields in any optimized way as the values would be unknown.  This would result in long query times as most likely all queries would be scanning the whole table to deliver any results.

If you can, use the Delphi application, or similarly developed application to export the data unencrypted into a file, easily parsed by MySQL (csv, SQL statements, etc.) that can be imported into your MySQL 5.7 database instance.  

This will allow you to create indexes on the unencrypted data to run your queries as necessary.

If you need to reencrypt the data, you can use the native functions of MySQL:

https://dev.mysql.com/doc/refman/5.7/en/encryption-functions.html

However, you will still be unable to index those columns in any workable way to query on those columns.  I would recommend if possible that any queries be done on any columns that can remain unencrypted and therefore be indexed accordingly to optimize the execution plans.