Support

My host just points me to an article about managing a php.ini file, but what should be in it. They say I can just put a copy in my local folder.

Can you just list what lines of code must be in this php.ini so I can fix this?

The display errors should be an optional setting, it isn't preventing your restore. You can create a php.ini file in the root of your site containing just:

error_reporting = E_NONE

Hi

Thanks. Tried that. Did not change anything. Still YES. Still get failed to connect to database.

Mike

Ah, now we get to it. :) The "display errors" and the "can't connect" are not related. The local php.ini technique can be tricky, it doesn't inherit from a higher folder like the .htaccess file does. The display errors can cause problems, but they aren't subtle, you get errors all over the place, hence the name "display errors".

There are several usual suspects for a "can't connect" error:[ul][li]Not all servers use "localhost" for the MySQL server address. GoDaddy, for example, uses a named or numeric server address.[/li][li]Some hosts prefix the host account name to the database and user names that you create. This can be confusing because the database isn't really named what you named it.[/li][li]Non-alphanumeric characters in your password can cause problems. Accented characters, Cyrillic or Greek letters, things like that.[/li][/ul]

This is part of the configuration file in the folder I am restoring to:

var $dbtype = 'mysql';
var $host = 'localhost';
var $user = 'worksho5_jo151';
var $db = 'worksho5_jo151';
var $dbprefix = 'jos_';
var $mailer = 'mail';
var $mailfrom = '[email protected]';
var $fromname = 'workshop-uk.org';

worksho5_jo151 is the database name brom the archive file. The database name in this folder is worksh46_jo151. That is the information I am putting in the screen just before it says cannot connect. The password I enter is w0rksh0p, no strange characters, though I notice in the config file the password appears to be coded.

Any suggestions welcome, thanks.

Something that I should add to the usual suspects list, Akeeba never has sufficient rights on a commercial host to create a database, only to restore tables and data to an existing database. So you have to create the database through your host account before you do the restore. You would enter the new database's connection information in the screen when prompted.