search

Ysurac / FlightAirMap

Open source project displaying live aircrafts, ships or trackers on 2D/3D map. Browse through the data based on a particular aircraft, airline, airport, tracker or vessel to search through the database or see extensive statistics. Can use ADS-B in SBS1 format (dump1090, Radarcape,...), VRS, VA (VATSIM, IVAO whazzup.txt, phpvms,...), ACARS (acarsdec, acarsdeco2), APRS, AIS as datasource.
https://www.flightairmap.com/
GNU Affero General Public License v3.0
516 stars 157 forks source link

Importing old data #391

Open me2tkt opened 6 years ago

me2tkt commented 6 years ago

I ran FlightAirMap until about the middle of 2017. Then my hard disk failed and I spent some time getting everything back.

I only restarted using FlightAirmap again in January 2018

My question is there a way to merge the old databases with the current one ? I have the old SQL files, can I just import them ? If so which ones ?

Ysurac commented 6 years ago

It should be possible to import data from the spotter_output table into the new DB, but you need to remove the spotter_id column from imported data. This column is auto incremented. You can also import data from spotter_archive and spotter_output_archive the same way, if they are not empty.

me2tkt commented 6 years ago

Ok - first I'll make a backup ;-) Then I will test and report what happened.