Import database missing tables and values

[moy2010]

Good evening. I recently upgraded from PS 1.4.8.2 to 1.5.6 and had some issues with the installed modules (I deactivated them before upgrading the e-store). 

 

One of these is Google Rich Snippets + customer ratings & reviews from Businesstech.fr, which lets our customers to write reviews for the products that they have purchased and also displays snippets for the products in google search.

 

Well, I had some issues with this module and uninstalled it. These issues have been resolved now, but since the module had to be uninstalled, all the reviews were lost.

 

I still have the backup of the database, so I could import the missing tables and values. The main questions is... how to do it? >.<

 

I've already asked for support to the developer, but they answered that they cannot assist me since this isn't an issue related to a problem with the module.

 

If anyone could help me with the SQL lines that I have to type in to import these missing values, I would really appreciate it.

 

Thanks in advance .

[vekia]

 

 

and had some issues 

what kind of issues you had and how you fixed them?

[moy2010]

The website stopped working when the module was activated. I had to uninstall and reinstall the module to get it working (The same version works for PS 1.4 and 1.5).

 

Unfortunately, I lost all the reviews by doing it. All I need is to import these missing reviews to the database.

[vekia]

have you got database backup? it will be necessary to copy tables related to reviews

[moy2010]

Yep, I have the backup . It's in a zip file

[vekia]

can you show installation function of your rich snippets module ? only public function install() - nothing more

[moy2010]

Yep. Here's the public function install:

 

public function install()

{

require_once(_GSR_PATH_CONF . 'install.conf.php');

require_once(_GSR_PATH_LIB_INSTALL . 'install-ctrl_class.php');

 

// set return

$bReturn = true;

 

if (

!parent::install()

||

!BT_InstallCtrl::run('install', 'sql', _GSR_PATH_SQL . _GSR_INSTALL_SQL_FILE)

||

!BT_InstallCtrl::run('install', 'config')

||

!BT_InstallCtrl::run('install', 'tab')

) {

$bReturn = false;

}

 

return $bReturn;

[vekia]

im interested in this part: 

!BT_InstallCtrl::run('install', 'sql', _GSR_PATH_SQL . _GSR_INSTALL_SQL_FILE)

this part is related to sql file, you will see there what tables you need to re-import