Guest Posted June 2, 2003 Posted June 2, 2003 I'm trying to install the shopping cart (v 2.2) and am having problems with the msql database. the auto-load function won't work because my host (iPowerWeb) says that i can only access the mysql databases thru something called 'phpmyadmin' which is part of cpanel6. so i tried the manual installation and couldn't get the mysql commands to work. i kept getting a syntax error. anybody have any ideas? thanks
Guest Posted June 2, 2003 Posted June 2, 2003 phpmyadmin is used for manually managing the db but has nothing to do with direct OSC use if you are having a problem connecting, then it sounds like your configure.php files (in admin/includes and catalog/includes) may not be setup properly or that your username/pw for the db may not be correct
Guest Posted June 2, 2003 Posted June 2, 2003 thanks for the response... i called tech support and asked them for the mysql server info (i tried several things myself with no success). tech guy told me what i posted above re phpmyadmin. i'm relatively new at this and can believe whatever anyone tells me. but, when i got into phpmyadmin and found the area where i could manually enter the mysql commands, i kept getting syntax errors when using the commands given with the osc instructions.
Guest Posted June 2, 2003 Posted June 2, 2003 using phpmyadmin to create the db is basically a 3 step process 1) create the db (with whatever name you like) 2) import the oscommerce.sql file in the install folder 3) go but then all of this is handled in the catalog/install/install.php file which if you call if from a browser will step you thru the installation process - you need to know your mysql username and password and you can name the db anything you want
Guest Posted June 2, 2003 Posted June 2, 2003 importing the oscommerce.sql file is where i had the problem with the syntax errors. how do i do this? i created the db, but couldn't import the above file. i know my user name and p/w, but don't know the server (i tried using the ip of the server where my site is, but that didn't work). the instal.php file asks for the server info, which is why i called for tech support in the first place.
prosto Posted June 2, 2003 Posted June 2, 2003 it would help if you post the errors you are getting...
Guest Posted June 2, 2003 Posted June 2, 2003 my database name is 'sorrycha_osCommerce' and i tried to upload the .sql file using the following command (per the install file): mysql sorrycha_osCommerce < . / install / oscommerce.sql MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql sorrycha_osCommerce < . / install / oscommerce.sql' at
prosto Posted June 2, 2003 Posted June 2, 2003 I a not sure if it is the way you typed this here but . / install / oscommerce.sql should have no spaces and be like this ./install/oscommerce.sql May this be a problem?
Guest Posted June 2, 2003 Posted June 2, 2003 nice try prosto, but nogo. what you saw in my previous post was a copy and paste of the error message that was returned. the original command had no spaces. i tried it again, making sure that there were no spaces, and got the same result.
prosto Posted June 2, 2003 Posted June 2, 2003 I see. I sort of overlooked it - but you are using phpMyadmin right? You can select your database there, go to SQL tab on the top, and you can either copy the contents of the oscommerce.sql into the text field there or browse to the file on your local machine and run it this way. the command you are trying to execute is used when you are accessing mysql via command prompt (telnet or ssh).
Guest Posted June 2, 2003 Posted June 2, 2003 prosto, it worked. thank you, thank you, thank you. it's amazing how easy things are when you know what you're doing.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.