One of my websites has people signup for a service and the Country selection was unfortunately never set up properly. Instead of beginning with a complete list of countries, my programmers provided a very limited list to start and an Admin function where I can type in additions. BUT, this has resulted in a drop-down option list completely out of alphabetical order. Someone has provided me with a file "countries.sql". In my hosting control panel >Databases >phpMyAdmin I've located and clicked on the main database for the website and I see the table in question: tblcountry and clicked to browse it.
Editing A MySQL Database
8
One of my websites has people signup for a service and the Country selection was unfortunately never set up properly. Instead of beginning with a complete list of countries, my programmers provided a very limited list to start and an Admin function where I can type in additions. BUT, this has resulted in a drop-down option list completely out of alphabetical order.
Someone has provided me with a file "countries.sql". In my hosting control panel >Databases >phpMyAdmin I've located and clicked on the main database for the website and I see the table in question: tblcountry and clicked to browse it.
But, without guidance, I'm reluctant to progress any further.
Do I now click to Empty it, then browse and locate the file "countries.sql" on my computer and simply import it? These seem to be the logical steps, but I've never before messed with MySQL databases and I don't want to screw anything up.
Any advice would be greatly appreciated.
Thanks
Someone has provided me with a file "countries.sql". In my hosting control panel >Databases >phpMyAdmin I've located and clicked on the main database for the website and I see the table in question: tblcountry and clicked to browse it.
But, without guidance, I'm reluctant to progress any further.
Do I now click to Empty it, then browse and locate the file "countries.sql" on my computer and simply import it? These seem to be the logical steps, but I've never before messed with MySQL databases and I don't want to screw anything up.
Any advice would be greatly appreciated.
Thanks
- Manfred Ekblad
- theIMgeek
- [1] reply
- AnniePot
- stma
- Frank Wright
- [1] reply
- AnniePot
- Manfred Ekblad
Next Topics on Trending Feed
-
8