clawsonsa Posted July 22, 2012 Report Share Posted July 22, 2012 Fellow members, Is there and easy way to remove a large number of unwanted airports from your database with removing them one at a time in the edit area of the admin panel? Thank you. Scott C Quote Link to comment Share on other sites More sharing options...
RogerB Posted July 22, 2012 Report Share Posted July 22, 2012 MySql Quote Link to comment Share on other sites More sharing options...
Moderators mark1million Posted July 22, 2012 Moderators Report Share Posted July 22, 2012 Yes there is, i done it with my lot a while ago through phpmyadmin, i cant remember the exact query now but do a backup of that table just incase things get screwed, they you can restore if it goes wrong. You can use wild cards so, DELETE FROM `phpvms_airports` WHERE `icao` =LP** Something like that "NOT TESTED" so make sure you test first Quote Link to comment Share on other sites More sharing options...
PilotJordan Posted July 22, 2012 Report Share Posted July 22, 2012 The easiest way is if you have phpMyAdmin which most hosts do. Just go to your cPanel and click the icon the says phpmyadmin and click on your tables, find the phpvms_airports table select the checkbox for the ones you wish to remove and remove them. Although the alternative if you don't have phpmyadmin is using an SQL query. Quote Link to comment Share on other sites More sharing options...
clawsonsa Posted July 22, 2012 Author Report Share Posted July 22, 2012 Thank you I appreciate the help! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.