How do I update database with PHPMyAdmin

[marinachristine]

I'm a novice teaching myself this as I go and everyone's threads have been immensely helpful thus far. I'm at the point of installing Paypal's payments pro from the contribution here and I'm stuck on what seems to be a very simple task but one that is lost on me:

 

 

* Import the file "paypal_wpp.sql" into your database using phpMyAdmin.

 

I see the document I need to import but what database is this referring to and what is phpMyAdmin and how do I use it? Is the database the catalog on the server (i.e. www.mydomain/store//catalog?), or something else entirely? Where do I put this thing and how do I get it there? Do I need to download a client for phpMyAdmin? Right now I'm using dreamweaver and cyberduck (on a mac).

 

Thanks guys - you've been awesome so far just keep your instructions simple for me!! :)

[Guest]

I'm a novice teaching myself this as I go and everyone's threads have been immensely helpful thus far. I'm at the point of installing Paypal's payments pro from the contribution here and I'm stuck on what seems to be a very simple task but one that is lost on me:

* Import the file "paypal_wpp.sql" into your database using phpMyAdmin.

 

I see the document I need to import but what database is this referring to and what is phpMyAdmin and how do I use it? Is the database the catalog on the server (i.e. www.mydomain/store//catalog?), or something else entirely? Where do I put this thing and how do I get it there? Do I need to download a client for phpMyAdmin? Right now I'm using dreamweaver and cyberduck (on a mac).

 

Thanks guys - you've been awesome so far just keep your instructions simple for me!! :)

Go to your phpMyAdmin

Choose your osC database on the left in the pull-down menu

On the right side, click on the SQL tab at the top

Then paste the code into the textarea on that page

Click on the GO button and you are done

[ashras99]

If like to undo the query from phpmyadmin then there is any possible way like sometime any extra field is added...? or all the added fields in different tables of the database (sql query) like to remove

[marinachristine]

Go to your phpMyAdmin

Choose your osC database on the left in the pull-down menu

On the right side, click on the SQL tab at the top

Then paste the code into the textarea on that page

Click on the GO button and you are done

 

Hi Coopco,

 

Thanks for that help! Unfortunately I'm relying on my host server for a lot of the coding resources (I'm using netfims). Is what you described true if I have downloaded the phpMyAdmin software? If so, I don't have that. However on my server's control panel it does let me browse the databases of OSC - which database within OSC am I looking for that I need to upload this sql to?

 

Does anyone use netfirms and could help with this?

 

Thanks everyone!

[marinachristine]

Hi Coopco,

 

Thanks for that help! Unfortunately I'm relying on my host server for a lot of the coding resources (I'm using netfims). Is what you described true if I have downloaded the phpMyAdmin software? If so, I don't have that. However on my server's control panel it does let me browse the databases of OSC - which database within OSC am I looking for that I need to upload this sql to?

 

Does anyone use netfirms and could help with this?

 

Thanks everyone!

 

 

Ok, I'm in the MySQL database for the OS Commerce store. There is a list of 30+ tables on the left hand side. They include titles like address book, configuration, newsletters, orders, products, taxes, etc... It looks like I can import the sql string into one of those tables. Which one do I want to import it to, the configuration one? Is this the correct way to do it?

 

Love to hear other ideas on how to handle this - you guys have all been great - thanks again! :)

[Jack_mcs]

This thread may give you a better idea of how to do it.

 

Jack

[ashras99]

edit: sorry posted in wrong thread.