How to open a JSON file online
Three steps, a few seconds, no software.
Open your .OPT file
Drop it on the box, choose it from your device, or paste the data straight in.
View the structure
Your .OPT file opens as a tidy, foldable tree, with the exact line of any error pointed out.
Search, copy or download
Search keys and values, copy any path or value, switch to a table, or download a clean copy.
What is a .OPT file?
The most common data format on the web.
In MySQL, an OPT file is the internal db.opt file that stores a database's default character set and collation. You can open it in any text editor to read it, but you should not edit it by hand. MySQL 8.0 (2018) removed this file entirely, so its absence on newer servers is normal.
Programs that open .OPT files
| Full name | MySQL Database Options File (db.opt) |
|---|---|
| Developer | Oracle Corporation (MySQL; originally MySQL AB) |
| First released | Early MySQL (db.opt has existed for many MySQL versions in MyISAM/legacy data directories) |
| Category | Text & Code |
| MIME type | text/plain |
Related viewers
Every viewer is free to use.
Frequently asked questions
Is my .OPT file uploaded anywhere?
No. The file is opened directly from the copy you pick.
My .OPT file is invalid. Can you fix it?
We show the exact line and column of the first error. For common problems like comments, trailing commas, single quotes or Python-style True/False/None, click Try to repair and download the fixed file.
How large can the file be?
Up to 50 MB. The tree only builds the branches you open, so even multi-megabyte files stay responsive.
What is JSONPath?
A path like $.orders[3].customer.email that points to one value inside the data. Click any node to see its path and copy it for code, jq or your API docs.
Can I see my data as a table?
Yes. Any array of objects can be shown in the Table view and downloaded as CSV.
Was this tool helpful?
Your rating helps us decide which tools to improve next.