plus766 Posted February 14, 2007 Share Posted February 14, 2007 I am starting a new site which i am developing on my local machine. I exported my old sql database and imported it through phpmyadmin on local site. i went to the admin/includes/configure and includes/configure and changed the name of the database and the login/password to match the old database, but it just comes up with "unable to connect to database server!" what am I doing wrong? Striving to go beyond Novice-suggestions always welcomed Link to comment Share on other sites More sharing options...
GemRock Posted February 14, 2007 Share Posted February 14, 2007 I...changed the name of the database and the login/password to match the old database... You did not mention database server, which need to be changed as well? and all these (user name, pw, db server) are not necessary the same as your 'old' live server. Ken commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile). over 20 years of computer programming experience. Link to comment Share on other sites More sharing options...
plus766 Posted February 14, 2007 Author Share Posted February 14, 2007 You did not mention database server, which need to be changed as well? and all these (user name, pw, db server) are not necessary the same as your 'old' live server. Ken I changed the name to localhost for the database server. I can't seem to find where the default database is stored. It's oscommerce, but it's not in the apache triad htdocs, where is that stored? Striving to go beyond Novice-suggestions always welcomed Link to comment Share on other sites More sharing options...
GemRock Posted February 14, 2007 Share Posted February 14, 2007 I changed the name to localhost for the database server. I can't seem to find where the default database is stored. It's oscommerce, but it's not in the apache triad htdocs, where is that stored? Thats insteresting. you 'imported it through phpmyadmin on local site', how did you do it w/o knowing the name of the db? and how did you get into your local phpMyadmin w/o knowing the user name & pw fo ryour local MySql? all of thes trhee are what you need to use in configure.php. the only place you could see databases/db server is in phpMyadmin, and no where else. Good Luck! Ken commercial support - unProtected channel, not to be confused with the forum with same name - open to everyone who need some professional help: either PM/email me, or go to my website (URL can be found in my profile). over 20 years of computer programming experience. Link to comment Share on other sites More sharing options...
satish Posted February 15, 2007 Share Posted February 15, 2007 The coonection parameters need to be ok. Check includes/configure.php define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', '****'); define('DB_SERVER_PASSWORD', '****'); define('DB_DATABASE', '****'); Satish Mantri Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.