Automate your conversions using the RebaseData API
Open a terminal. Run the following command to make sure you have the packages curl and libreoffice-calc installed:
apt-get install curl libreoffice-calcThen you can use CURL to convert the MyISAM files to CSV. You have to replace table1.frm table1.myd table1.myi with the files you want to convert.
curl -F 'files[]=@table1.frm' 'files[]=@table1.myd' 'files[]=@table1.myi' https ://www.rebasedata.com/api/v1/convert?outputFormat=csv -o output.zipNow try to open the file output.zip. It will contain CSV files. You can open these CSV files with LibreOffice Calc. Make sure you specify "comma" as column separator.
If you cannot open the file output.zip, there was probably an error and the file contains the error message. Open it with gedit to see the error.
That's it! You successfully read your MySQL MyISAM files.
The RebaseData PHP-Client internally uses our API to convert the MySQL MyISAM files to a standardized format. Then you can read the data using PHP as shown above.