How do I update the catalog database?

[CrassOne]

I am trying to install the Echo payment module but don't understand what it wants me to do. It says update the catalog db with the included echodbmod.sql.

 

I have echodbmod.sql from the Contribution unzipped on my local drive. I also have phpMyAdmin. Now what?

 

I would appreciate a "Step 1, Step 2, etc.," type of explanation to keep me from screwing it up. :'(

 

Thanks in advance...

[seank123]

Don't worry - it's quite simple to do!

 

1> Go into PhpMyAdmin and select the database

2> You should now have a list of all the tables in the database - address_book, address_format etc....

3> Select the table that the module needs you to alter

4> In the right panel you should now see a load of options along the top - Structure, Browse, SQL, Select etc...

5> Click on SQL - you should now have something that says: 'Or Location of the textfile :' with a 'browse' button - click the button and find the sql file on your hard drive.

6> Click GO!

7> Hopefully - the sql file will load, make the changes and not report any errors!!!!

[CrassOne]

Don't worry - it's quite simple to do!

 

1> Go into PhpMyAdmin and select the database

2> You should now have a list of all the tables in the database - address_book, address_format etc....

3> Select the table that the module needs you to alter

4> In the right panel you should now see a load of options along the top - Structure, Browse, SQL, Select etc...

5> Click on SQL - you should now have something that says: 'Or Location of the textfile :' with a 'browse' button - click the button and find the sql file on your hard drive.

6> Click GO!

7> Hopefully - the sql file will load, make the changes and not report any errors!!!!

<{POST_SNAPBACK}>

Thanks. That did it.

 

I suspected that might do it, but didn't want to risk it without more info.