Editing Joomla database

[JTQ]

I've got to add one more thing to my Joomla database before I can get things working properly for my online shop, using VirtueMart. The instructions say this:

Australia Post Manual Flex Shipping Rates for VirtueMart 1.0.4

Usage: dump the data into your Mambo/Joomla database under the 'mos_vm_shipping_rate' field.

1st Note : You will need to enter your database name into the beginning of the dump document.

2nd Note: The dump is setup to add data to existing tables.
               Should you requre to delete old manual shipping rates.
               Just add:
                              DROP TABLE IF EXISTS `mos_vm_shipping_rate`;

               Directly before the text :

                             CREATE TABLE `mos_vm_shipping_rate`

3rd Note : Packaging fee is set to $3.70 to cover the cost of sending the box/carton itself & buying the box/carton. (packaging)
                Should you need to change this price, simply find and replace (Ctrl H in Notepad) :   , 3.70, 9,   and replace with your
                own value.. ie : , 2.45, 9,   (the 9 is the AU currency id.)

How and where do I edit the Joomla database?

[Tonie]

Most hosters give their customers the opportunity to use Phpmyadmin to administer databases.

[JTQ]

I've got phpMyAdmin in my domain's cpanel. I have gone through and found jos_vm_shipping_rate (not mos_vm_shipping_rate). But when I open that, it's got a bunch of "keys" in there, which the instructions don't say anything about.

I have no idea how to edit it or where to put it.

[Tonie]

You mentioned you have a dumpfile you have to import? Open this, and check if mos_vm_shipping_rate is in there. If so, replace this with jos_vm_shipping_rate. You should then be able to import this through the 'Import' button on Phpmyadmin.

[JTQ]

All done... imported and going fine. Cheers

Problem I had with it, the table jos_vm_shipping_rate already existed, so I couldn't upload a new one. I renamed the existing table, so it's still there (as a backup) if I need to restore it, then imported the new one.

Works fine.

[purplywurply]

i have the same problem and know how to use the host sql editor.... but it says no sql database exists. i just want to make a small tweak to the joomla databse to fix a bug that has stopped my admin login from working. any ideas?