By med103 on

Hello,
I just launched a Drupal site and I'm trying to install a few modules I downloaded from this site. The question I have is about the .sql files. I keep seeing instructions like 3. Install the mysql file (mysql -u user -p database < amazon_items.sql). Where do I input this? I just dropped the .sql file in the database folder, but I don't think this is right. I have a host with c panel, do I find the database there and make the modifications? Can I use something like http://cocoamysql.sourceforge.net/ to manage this? I'm pretty new to the whole database thing so any help would be greatly appreciated.
Thanks,
Mike

Comments

bjornarneson’s picture

bjornarneson commented

I have a host with c panel, do I find the database there and make the modifications?

Yes, your control panel should have an option to administer the database through a tool like phpmyadmin.

You can then use the "import SQL" functionality (or something with a similar name) to choose the amazon_items.sql code from your local machine and apply it to the remote DB.

Make a backup of your database first in case something goes awry.

--
Bjorn | choirgeek.com

med103’s picture

med103 commented

Awesome, it looks like it worked. Now one last question about the Amazon Items module. I installed the AmazonProduct.class.inc, AmazonSearchEngine.class.inc and Snoopy.class.inc files in the includes folder. I ran the amazon_items.sql file in the phpmyadmin and added it to the database and I installed the amazon_items.module file in the modules folder, but what do I do with the amazon_items.css file? Do I leave the amazon_items.css and the module file in a folder and put it in the modules folder?
Thanks again,
Mike