Historical data
Import from MeteoTemplate
Connect directly to a MeteoTemplate database and import its history.
Import from MeteoTemplate
Use this guide if your weather history is already stored in a MeteoTemplate MySQL database and you want to import it directly.
Meteobreeze connects to the database, reads the available rows, previews the date range, and imports the selected records into your station.
Recommended: connect your live source first, then import from MeteoTemplate. This keeps Meteobreeze up to date while you backfill the older records.
When to use it
- You still have access to the MeteoTemplate database
- You want to avoid exporting to CSV first
- You want the fastest path from MeteoTemplate into Meteobreeze
Before you start
- Have your MySQL connection string ready
- Know the database name
- Know whether your table is called
alldataor something else - Have the station ready in Meteobreeze
The connection string must use mysql:// or mysqls:// and include the database name.
Step-by-step
- Open the historical import flow and choose
MeteoTemplate. - Enter the MySQL connection string.
- Change the table name if your data is not in
alldata. - Test the connection.
- Review the detected date range and field coverage.
- Continue to the preview screen.
- Choose the station and import range.
- Start the import.
Common issues
- If the connection fails, check the protocol, host, username, password, and database name.
- If Meteobreeze cannot find the table, confirm the table name and spelling.
- If the range looks wrong, check that the MeteoTemplate
DateTimevalues are what you expect. - If the database is remote, make sure the network and credentials allow access from Meteobreeze.
FAQ
- Do I need to export to CSV first? No.
- Does Meteobreeze need write access to the database? No, it only reads data.
Related pages
Image needed: a screenshot of the MeteoTemplate connection form and a preview screen showing the detected row count and date range.