Convert MyISAM files to PostgresSQL online

Add file

Input file

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

Output file

The API will return a ZIP archive that contains a .SQL file. This .SQL is a PostgreSQL dump file and can be restored into your PostgreSQL installation.

Conversion methods

Using our Java tool

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=postgresql myisam-files.. output-dir/
Using CURL

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 'files[]=@products.frm' -F 'files[]=@products.myd' -F 'files[]=@products.myi' 'https://www.rebasedata.com/api/v1/convert?outputFormat=postgresql&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 'files[]=@products.frm' -F 'files[]=@products.myd' -F 'files[]=@products.myi' -F 'files[]=@orders.frm' -F 'files[]=@orders.myd' -F 'files[]=@orders.myi' 'https://www.rebasedata.com/api/v1/convert?outputFormat=postgresql&errorResponse=zip' -o output.zip
The file output.zip will contain a PostgreSQL data.sql file with your data or the error message if something went wrong.

How long does it take?

The conversion process takes between 15 seconds and multiple minutes. It depends on the size of the database.

You can also use your favourite tool

Why use RebaseData?

Terms