CODEWITHSUNDEEP
joomla
shin
shin

Reputation: 32721

How to change database name for Joomla?

I am tranferring Joomla website from my local server to a live server.

I need to change the database name when I do so.

Can anyone tell me which file I need to change please?

Thanks in advance.

Upvotes: 0

Views: 13879

Answers (6)

abdullah altaf
abdullah altaf

Reputation: 1

simple process: 1.open configuration.php

2.change all database value 

public $host = 'localhost';
public $user = 'root';
public $password = '';
public $db = 'Old_database_Name';

Upvotes: 0

Gopal Patel
Gopal Patel

Reputation: 1

you can see below parameter into configuration.php file which is at your root joomla site

public $host = 'localhost';

public $user = 'root';

public $password = '';

public $db = 'database name';

with

public $host = 'localhost';

public $user = 'server username(which you create for database connection)';

public $password = 'server password (which you enter during user create)';

public $db = 'New_database_name';

Note : you can change prefix of database also using $dbprefix

Upvotes: 0

Wide Vision
Wide Vision

Reputation: 15

Just replace in the configuration file present in the root of joomla folder :

public $db = 'old_database_name';

with

public $db = 'new_database_name';

You can also change the database username and password from the same file.

Upvotes: 0

Anil Bikram Thapa
Anil Bikram Thapa

Reputation: 1

log in to your c panel .. your back end will open..

go to the file manager you will find all the pages you have created..

find out configuration.php page

go to the online html editor or just download the file and open it from you html editor software such as notepad++ or dreamweaver or other

also check var $db and replace the old with new name..

hope this will help..

Thanks Anil BIkram Thapa

Upvotes: 0

kumar satyam
kumar satyam

Reputation: 21

configuration.php in the root of the joomla install, replace the line

public $host = 'localhost';
public $user = 'root';
public $password = '';
public $db = 'Old_database_Name';

with

public $host = 'localhost';
public $user = 'Server_host_user_name';
public $password = 'Server_host_password';
public $db = 'New_database_name';

Upvotes: 2

ridecar2
ridecar2

Reputation: 1957

configuration.php in the root of the joomla install, replace the line

var $db = 'old-database'

with:

var $db = 'new-database'

Upvotes: 6

Related Questions