mysql, wamp, Joomla! newb problem
Posted by: jaatendi (---.accentprinting.ca)
Date: June 16, 2009 12:17AM

Hi, I have been really pulling my hair out for a week over this, and here are the steps I have followed thus far;

I created a website online using fantastico and have downloaded the site folder and db.

I created a new db in phpmyadmin, opened the old db, copied and pasted the data in the SQL pane of the new db. I moved the website folder to c:/wamp/www.

Then I altered the configuration.php file to try to accommodate the new settings.

When I attempt to view the site in Localhost, I get the following error:

Database Error: Unable to connect to the database:Could not connect to MySQL


I am absolutely at my wits end with this. Based on my little knowledge, I suspect that the configuration.php file is erroneous. Please please help!

Options: ReplyQuote
Re: mysql, wamp, Joomla! newb problem
Posted by: yfastud (Moderator)
Date: June 16, 2009 01:13AM

Quote

opened the old db, copied and pasted the data in the SQL pane of the new db
on your live host, you should use phpmyamdin to export that old db, then use phpmyadmin in wamp to import those old db into new db just created

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote
Re: mysql, wamp, Joomla! newb problem
Posted by: faltu780 (---.dsl.frs2ca.pacbell.net)
Date: June 16, 2009 01:50AM

Hi yfastud I am actually having a similar problem. I reinstalled wamp and moved my entire wamp foler and replaced the one I just installed.

Going to localhost gives me the same error

Database Error: Unable to connect to the database:Could not connect to MySQL

going to MySQL:lite manager works fine and all of my databases are there intact from my old site.

going to Phpmyadmin i get the following error:

Error

MySQL said: Documentation
#2003 - Can't connect to MySQL server on 'localhost' (10061)

I do not know how to gain access to the database on phpmyadmin from the old site I no longer have up.

Thank you for the help in advance.

Options: ReplyQuote
Re: mysql, wamp, Joomla! newb problem
Posted by: jaatendi (---.accentprinting.ca)
Date: June 17, 2009 08:57PM

Yes, I did get the db into my new environment fine, I just can't get it connected to the website. It's a joomla site and its configured to work on the server it was created on. The file directories are incorrect, or the maybe its a database username and password issue.

Here is some code from my configuration.php file. I think there is something wrong with this:

<?php
class JConfig {
var $offline = '0';
var $editor = 'jce';
var $list_limit = '20';
var $helpurl = 'http://help.joomla.org';
var $debug = '0';
var $debug_lang = '0';
var $sef = '1';
var $sef_rewrite = '0';
var $sef_suffix = '1';
var $feed_limit = '10';
var $secret = 'lX5IcMkV43NSIxyR';
var $gzip = '0';
var $error_reporting = '0';
var $xmlrpc_server = '0';
var $log_path = 'c:/wamp/www/GNOSISMEDIA';
var $tmp_path = 'c:/wamp/www/GNOSISMEDIA/tmp';
var $live_site = '';
var $offset = '0';
var $caching = '0';
var $cachetime = '15';
var $cache_handler = 'file';
var $memcache_settings = array();
var $ftp_enable = '0';
var $ftp_host = '127.0.0.1';
var $ftp_port = '21';
var $ftp_user = 'root';
var $ftp_pass = '';
var $ftp_root = '';
var $dbtype = 'mysql';
var $host = 'localhost';
var $user = 'root';
var $db = 'jaatendi_jo152';
var $dbprefix = 'jos_';
var $mailer = 'smtp';
var $mailfrom = 'info@gnosismedia.ca';
var $fromname = 'jaatendi';
var $sendmail = '/usr/sbin/sendmail';
var $smtpauth = '0';
var $smtpuser = '';
var $smtppass = '';
var $smtphost = 'localhost';
var $MetaAuthor = '1';
var $MetaTitle = '1';
var $lifetime = '55';
var $session_handler = 'database';
var $password = 'cOQxB1vMuTZ3';
var $sitename = '';
var $MetaDesc = 'Edmonton alberta web design graphic design video production multimedia and new media

Options: ReplyQuote
Re: mysql, wamp, Joomla! newb problem
Posted by: yfastud (Moderator)
Date: June 17, 2009 10:29PM

Quote

var $password = 'cOQxB1vMuTZ3';
this passwd is for *nix, and you should supply passwd that you used when created new db for joomla; follow this
to setup db, follow this
[blog.jlbn.net]

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote


Sorry, only registered users may post in this forum.