PHP MySQL WAMP - Database Error

Question

When I launch the website through local host, I get the following error:

Database Error: Unknown database 'db_name'

I'm having a dig around as to what the problem is. The website belongs to a friend of mine and he wants me to connect the website to the database. The database resides within the root directory. I'm merely trying to connect to it.

In most of the PHP files, there is a tag that includes the config file which contains the details of the database.

Any ideas as to how I can get it working and resolve the Database Error: Unknown database 'db_name' error?

Any help is highly appreciated.

Which website? Show us the part where you etablish the connection to the db. — j0k
– j0k, Commented Aug 2, 2012 at 13:08
What do you mean by the database resides in the root directory? — billyonecan
– billyonecan, Commented Aug 2, 2012 at 13:08
What do you mean the database resides in the root directory? MySQL is a database server, not a file. — Michael Berkowski
– Michael Berkowski, Commented Aug 2, 2012 at 13:08
If you are using PDO you need to specify the database name in the connection string. Are you sure that the database matches the name? Linux systems are case sensetive. — Fluffeh
– Fluffeh, Commented Aug 2, 2012 at 13:09

Kalpesh · Accepted Answer · 2012-08-02 13:33:57Z

1

Database should not reside in root directory, it should be imported to database (Mysql) server.

Check in Mysql databases, does your database resides there? If not, you can do so by phpMyAdmin or navigating to your mysql and importing it.

Create database in mysql and import the sql file as below by opening command-line terminal:

/path/to/mysql/bin > mysql -u username -p < /path/to/root/db.sql

answered Aug 2, 2012 at 13:33

Kalpesh

5,6952 gold badges25 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP MySQL WAMP - Database Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related