One of the things that irritated me about setting up mythTV (version 0.20) was having to manually re-arrange the channels using the channel editor into an order that seemed appropriate. This long and lengthy process soon became a chore after having rescan for channels then re-arrange them again.
So, to combat this problem, I created a simple .SQL script that basically alters the "channel" database to map each channel to a suitable number.
Please note that this guide is designed for UK DVB-T (freeview users) although the principle is the same, feel free to download the script and edit it to your requirements.
Also, it is worth noting that it's best if you have mythTV fully setup and ready before doing this (have all channels readily scanned and working)
So, how to install this script....
Step 1: Download the script
Put it somewhere that you'll remember.
Feel free to open it and edit it to suit your taste (the channels are ordered to my requirements)
Step 2: Apply changes to the database
Open a terminal and cd to the directory that you downloaded the script to. Then simply type the following command
Step 3: Check to see if it has worked!
mysql -uroot mythconverg < chan_numbers_update.sql > output.tab
Open up mythTV-setup again, open the channel editor and tell it to "sort by channel number", hopefully all your channels should be in order!
Step 4: Enjoy!
Please feel free to ask any questions