# Erase All Routes?

**URL:** <https://forum.phpvms.net/t/erase-all-routes/4034>\
**Category:** phpVMS Legacy Support (v2/v5)\
**Created:** [February 7, 2011, 11:31pm UTC](https://forum.phpvms.net/t/erase-all-routes/4034 "2011-02-07T23:31:03Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![regional\_elite](https://forum.phpvms.net/letter_avatar_proxy/v4/letter/r/47e85d/32.png) [@regional\_elite](https://forum.phpvms.net/u/regional_elite)\
**Post date:** [February 7, 2011, 11:31pm UTC](https://forum.phpvms.net/t/erase-all-routes/4034/1 "2011-02-07T23:31:03Z")

</div>

I renumbered all my flights and want to kow how to erase all flights in my system before I upload the new CSV file. How do I do it? Also will this mess up all the pireps I have in the system already?

---

<div class="post-metadata">

**Author:** ![flyalaska](https://forum.phpvms.net/user_avatar/forum.phpvms.net/flyalaska/32/14_2.png) [@flyalaska](https://forum.phpvms.net/u/flyalaska)\
**Post date:** [February 7, 2011, 11:46pm UTC](https://forum.phpvms.net/t/erase-all-routes/4034/2 "2011-02-07T23:46:47Z")

</div>

You mean the PIREPS that have been flown?

---

<div class="post-metadata">

**Author:** ![regional\_elite](https://forum.phpvms.net/letter_avatar_proxy/v4/letter/r/47e85d/32.png) [@regional\_elite](https://forum.phpvms.net/u/regional_elite)\
**Post date:** [February 7, 2011, 11:49pm UTC](https://forum.phpvms.net/t/erase-all-routes/4034/3 "2011-02-07T23:49:55Z")

</div>

No I want to delete every flight in my system. Like all the flights. But I doon’t want to lose the pireps that have been filed.

---

<div class="post-metadata">

**Author:** ![Tom](https://forum.phpvms.net/letter_avatar_proxy/v4/letter/t/3d9bf3/32.png) [@Tom](https://forum.phpvms.net/u/Tom)\
**Post date:** [February 7, 2011, 11:55pm UTC](https://forum.phpvms.net/t/erase-all-routes/4034/4 "2011-02-07T23:55:01Z")

</div>

It will mess with your filed pireps, but you can probably just drop the schedules table and reset your auto increment.

---

<div class="post-metadata">

**Author:** ![regional\_elite](https://forum.phpvms.net/letter_avatar_proxy/v4/letter/r/47e85d/32.png) [@regional\_elite](https://forum.phpvms.net/u/regional_elite)\
**Post date:** [February 7, 2011, 11:58pm UTC](https://forum.phpvms.net/t/erase-all-routes/4034/5 "2011-02-07T23:58:06Z")

</div>

im new to this. could you maybe walk me thru how to do that?

---

<div class="post-metadata">

**Author:** ![Tom](https://forum.phpvms.net/letter_avatar_proxy/v4/letter/t/3d9bf3/32.png) [@Tom](https://forum.phpvms.net/u/Tom)\
**Post date:** [February 8, 2011, 12:04am UTC](https://forum.phpvms.net/t/erase-all-routes/4034/6 "2011-02-08T00:04:39Z")

</div>

In your cpanel/alternative, go to your phpmyadmin/other database management tool and navigate through to your phpVMS schedules table. There will be an “Empty” button or something similar. If you hit that it will basically remove all records from the table (and here’s where it’ll mess with the filed PIREPs because they have links and data based on these records).

I don’t know if resetting your auto increment is advised but I don’t seem to have any problems doing it. If you want to, you’ll have the option to run SQL somewhere. Run “ALTER TABLE phpvms\_schedules AUTO\_INCREMENT = 1” (without the quote marks and where phpvms\_schedules is your schedules table should the prefix be different).

---

<div class="post-metadata">

**Author:** ![regional\_elite](https://forum.phpvms.net/letter_avatar_proxy/v4/letter/r/47e85d/32.png) [@regional\_elite](https://forum.phpvms.net/u/regional_elite)\
**Post date:** [February 8, 2011, 12:25am UTC](https://forum.phpvms.net/t/erase-all-routes/4034/7 "2011-02-08T00:25:30Z")

</div>

sounds really complicated, i may wait till we redo our site and take care of it. that’ll be when the new acars comes out. thanks anyways. you can mark this as solved

---

<div class="post-metadata">

**Author:** ![Michael](https://forum.phpvms.net/user_avatar/forum.phpvms.net/michael/32/77_2.png) [@Michael](https://forum.phpvms.net/u/Michael)\
**Post date:** [February 8, 2011, 1:52am UTC](https://forum.phpvms.net/t/erase-all-routes/4034/8 "2011-02-08T01:52:19Z")

</div>

While we are here… I don’t necessarily need to know now, but let’s say my real-world counterpart changes up their schedules, and we want to match up with them. If I upload a .csv file, and it has information with the same flight numbers as what is already in the database, but different dep/arr airports, fleet, etc., will it override them, or create duplicate routes… or just send an error?

I’m just curious.

---

<div class="post-metadata">

**Author:** ![mark1million](https://forum.phpvms.net/user_avatar/forum.phpvms.net/mark1million/32/15_2.png) [@mark1million](https://forum.phpvms.net/u/mark1million)\
**Post date:** [February 8, 2011, 7:49am UTC](https://forum.phpvms.net/t/erase-all-routes/4034/9 "2011-02-08T07:49:34Z")

</div>

OK so if your flight numbers are the same they will just be updated, so if you currently have flights from 1 to 1000 then if you upload the same or more with the flight numbers they will be updated with the new information.

No need to delete anything.
