WordPress.org

1. Zappa365
   Member
   Posted 11 months ago #

   Hi,

   I have a site that I made for some people a while ago. I need to clone the site to a new server.

   I downloaded all the latest db tables and also the entire site files.

   I setup a new database via my sql databases on the new server. I edited the sql file as instructed in a guide to change the web address to my new address - I changed the domain name to mynewdomain.com/newsite (in a sub directory)

   I then uploaded all the files to this sub directory on the new server and tried to link the two by editing the wp-config file.

   I changed in the wp-confifg file : define('DB_NAME', 'my_sql_db_name');

   However I am having no luck and I have the message in my browser:
   "Error establishing a database connection"

   If anyone can please help me and advise where I am going wrong I would be very very grateful.

   Thanks

2. BODA82
   Member
   Posted 11 months ago #

   Make sure you have a sql username and password set on the new server, giving that user the proper permissions, and update those definitions in wp-config.php as well. Also make sure the database host is correct based off your hosts setup.

3. Zappa365
   Member
   Posted 11 months ago #

   Hi,

   I made a new SQL user for the database and I have changed the part in wp-config file which sits in the wordpress file directory to have the same info:

   /** MySQL database username */
   define('DB_USER', 'admin');

   /** MySQL database password */
   define('DB_PASSWORD', '***');

   What do you mean by making sure database host is correct based off your hosts setup?

4. govpatel
   Member
   Posted 11 months ago #

   DB_host
   normally this should be a localhost or some hosts use url check with your host

5. suhas93
   Member
   Posted 11 months ago #

   This might help you?

   http://suhastech.com/wordpress/wordpress-how-to-change-your-webhost-or-domain-and-still-retain-all-the-settings/

Reply

You must log in to post.