Thread

You’ll need to modify it in config.php:

EE 1 - system/config.php
EE 2 - system/expressionengine/config/config.php

Thanks! done

1. I try importing my database and I get this error:

http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html#error_er_no_db_error

Any ideas? How can I fix this?

2. I am trying to follow http://expressionengine.com/wiki/Moving_servers_-_ExpressionEngine_site_to_the_new_host/

but I am at II, 2 and I cannot find that line.

2 problems. any help?

Alright! I figured out how to import the database.

But now I get this error.
“Database Error: Unable to connect to your database. Your database appears to be turned off or the database connection settings in your config file are not correct. Please contact your hosting provider if the problem persists.”

This is because my config file was different. So I modified it appropriately by replacing ‘localhost’ with my previous root domain. Same error shows up.

What else should I do? This is on XAMPP.

THANKS!

I’d guess that your database export just is a dump of all the tables within your database (that would explain why the line they say to comment out is not there).
When you go to import the database, you should have a new database set up and be in that database when running the import - the error message suggests that the import does not know which db to put the data into.
Hope this helps 😊

Just replied to your earlier import post there as had not seen this stating it was resolved. 😊
Maybe try to keep all the migration issues in the same topic so that people can follow where you’re at.

You need to make sure that 4 pieces of info in the config are correct: database host, database name, username and password. You can confirm the correct host to use in your hosting control panel or with your host - that’s most likely the one that is incorrect as you choose the others yourself.

See other post

I think I have all the right information in my config.php file.

I have…

<?php

if ( ! defined('EXT')){
exit('Invalid file request');
}

$conf['app_version'] = "169";
$conf['license_number'] = "";
$conf['debug'] = "1";
$conf['install_lock'] = "1";
$conf['db_hostname'] = "http://localhost/";
$conf['db_username'] = "*******";
$conf['db_password'] = "*******";
$conf['db_name'] = "*******";
$conf['db_type'] = "mysql";
$conf['db_prefix'] = "exp";
$conf['db_conntype'] = "0";
$conf['system_folder'] = "directory";
$conf['cp_url'] = "http://localhost/*******/directory/index.php";
$conf['doc_url'] = "http://expressionengine.com/docs/";
$conf['cookie_prefix'] = "";
$conf['is_system_on'] = "y";
$conf['allow_extensions'] = "n";
$conf['multiple_sites_enabled'] = "n";
?>

Where I cam 100% sure that all of the ‘*******’ are correct. I ******* them for personal information. Is there a problem with my hostname? It is located on XAMPP on my computer.

Any ideas?

- Thanks!

I have merged all of your posts (6 or so?) into one thread so that this can be more easily followed.  Please keep your XAMPP troubleshooting to this thread.

Thanks!

Sorry about all the posts. They seemed slightly different so I placed them in different threads. I guess I will keep them all in one from now on.

Does anyone see anything wrong with my config.php?

If not, then whats the problem? Why isn’t EE connecting to the database on XAMPP?

- Thanks!

$conf['db_username'] = "*******";
$conf['db_password'] = "*******";

If you haven’t made any changes to the default setup of the XAMP, the username will probably be ‘root’ and pword will be empty (”“).

THANKS YOU VERY MUCH! IT WORKED!

haha thanks! =]

THANKS YOU VERY MUCH! IT WORKED!

haha thanks! =]

Great!