Our API uses .FRM, .MYD, .MYI files as input. These files are MySQL Server MyISAM files. Usually, a single table is comprised of all three of these files. You can upload files for multiple tables.
Max file size for web uploads: 50 GB
The API will return a ZIP archive of .XLSX files, one for each input file. Since Excel has a limit of about one million rows, it could be that the rows are divided into several files.
Download the RebaseData client Java tool . To convert your database using RebaseData, run the following command:
java -jar client-0.0.5.jar convert --output-format=xlsx myisam-files.. output-dir/
Let's imagine there's a table called products. You typically would have the files products.frm, products.myd and products.myi. The curl command would look like this.
curl -F 'firstname.lastname@example.org' -F 'email@example.com' -F 'firstname.lastname@example.org' 'https://www.rebasedata.com/api/v1/convert?outputFormat=xlsx&errorResponse=zip' -o output.zip
It's also possible to convert multiple tables at once. Let's assume we also have an orders table. Check out the following command.
curl -F 'email@example.com' -F 'firstname.lastname@example.org' -F 'email@example.com' -F 'firstname.lastname@example.org' -F 'email@example.com' -F 'firstname.lastname@example.org' 'https://www.rebasedata.com/api/v1/convert?outputFormat=xlsx&errorResponse=zip' -o output.zipThe file output.zip will contain a Excel file, one for each input file. If something went wrong, output.zip contains the error message.
The conversion process takes between 15 seconds and multiple minutes. It depends on the size of the database.