OScommerce help

[amdskip]

Ok, I guess you could consider me a php newbie but I have a little experience. I'm trying to set up OScommerce on my dixies site to see how it works and if I should purchase another account for just this site which I hope to set up to sell network cables. I know I should buy a seperate account for the simplicity of things but I know I should be able to set this up on my account still.

I have the necessary files uploaded to the server and I had a problem with the database name. Someone already had a database named catalog on server #6 so I went through the files and changed all the "catalog" to "catalogs" and everything else. I'm hoping this part is ok. I am stuck now though. Here is where I need some help:

3. Create the 'catalog' database and import the sample data:

mysqladmin create catalog
mysql catalog < ./mysql_catalog.sql

To check if the tables have been successfully imported, you
can list them by using mysqlshow:

mysqlshow catalog

I have created the database catalogs in plesk before uploading the files to the server. I go into phpadmin and get the pop up window where it is phpMyAdmin 2.2.5 . I am now stuck right here as the message I get is "No tables found in database." I obviously want to insert tables using the sample data provided. I have no idea how to do this or what to exactly type where. I'm a newbie so remember this please.

I may end up signing up for a new account and just pay someone to set this up for me. I really want to do this myself though. I could also use some examples as far as linkage where to go into the configuration and the catalog. I have tried www.skippysg.com/default.php, etc, etc with any luck but the no tables in the database may be holding me back. I appreciate any assistence anyone can give me.

Amdskip

 

[amdskip]

anyone

 

[teknodude]

OK, I think I get what you're saying, so I'll give it a shot...

This bit:

mysql catalog < ./mysql_catalog.sql

is basically a command at the shell to run the file mysql_catalog.sql on the database catalog (in your case you will obviously want to alter it to 'catalogs'). So, what you need to do is put the file mysql_catalog.sql (presumably generated by OSCommerce (of which I've never heard!). It will just be a plain text file with SQL in) on your server then go the shell, change to the directory your .sql file is in and type:

mysql catalogs < ./mysql_catalog.sql

That should import all the data fine. If you're not sure about doing this with the shell, then there shouldn't be any problem putting the .sql file on the server and importing it via phpMyAdmin. Once all that is done you can bring up the phpMyAdmin and check all your tables etc. are there. Then go remove the .sql file from your server as it's not needed anymore.

Hope that helps, don't be afraid to ask any more questions :-D

Simon Plenderleith