PSiGate XML module -- special transaction table

[multibeatrecords]

the ReadMe that comes with the PSiGate_XML_osc module instructs:

 

=====

Run the attached SQL file 'psigate_xml_sql.sql' via a tool like phpMyAdmin

=====

 

I understand this to mean, "install the database archive into your osC database".

 

This .sql archive contains a single table used for logging the XML transactions with PSiGate.

 

This table needs to be imported into the main store catalog database.

 

I'm using MySQL 3.23.58.

 

How do i import the table from this sql file into my mbr_store DB ?

 

ISP says go to PHPmyAdmin to the Query Window, but that import seems to be only for .txt file import.

 

There doesn't seem to be any "sql archive table import from ext file" feature (or similar) in mysql 3.23.58

 

Does "run" mean something else? Do I need to execute the .sql archive?

 

Will I need to import this table to my db from the unix/mysql command line?

 

If so, roughly how?

 

Thoughts? Procedures?

 

I have combed the osC forum to no avail. Please help!

 

Thanks!

[multibeatrecords]

=====

Run the attached SQL file 'psigate_xml_sql.sql' via a tool like phpMyAdmin

=====

 

I'm going to answer myself here for future folks with same question:

 

- get a text editor

- copy the contents of 'psigate_xml_sql.sql'

- log yourself into your shop mysql database (using phpmyadmin) so you can see your list of tables

- choose SQL

- paste in the contents

- hit "Go" button

- table should be created

 

 

 

:blush:

[multibeatrecords]

=====

Run the attached SQL file 'psigate_xml_sql.sql' via a tool like phpMyAdmin

=====

 

I'm going to answer myself here for future folks with same question:

 

- get a text editor

- copy the contents of 'psigate_xml_sql.sql'

- log yourself into your shop mysql database (using phpmyadmin) so you can see your list of tables

- choose SQL

- paste in the contents

- hit "Go" button

- table should be created

 

 

 

:blush: