Solved

Renaming of WordPress Database

Posted on 2016-10-27
2
34 Views
Last Modified: 2016-11-01
Hi All

I want to rename the database and username of a WordPress site.  Although I will backup first I want to make sure it's done right.  Am I right by saying this can be done in 3 steps.

1) Rename the database in the My SQL section of the hosting package
2) Assign a user to the database
3) Change these lines to the correct DB name in wp-config.php

/** The name of the database for WordPress */
define('DB_NAME', 'z49te592_wp639');

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

Open in new window


I want to do this as I am adding more and more sites and some of the naming conventions are not very good and want to keep track of what relates to each-other.

Thank you in advance for your assistance
0
Comment
Question by:IM&T SRFT
2 Comments
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 total points
ID: 41862754
That should be all you need to do to ensure WP continues to work.
0
 

Author Closing Comment

by:IM&T SRFT
ID: 41868152
Thank you, I shall do this tonight!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
wordpress files link PDF open instead of download 5 94
Remove right text widget from smaller screens 15 110
Server time zone 4 23
Wordpress errors showing up, hacked? 4 33
Did you use a default hosting installation of wordpress with the intention of it being your actual site?  Maybe you’ve installed it as a Blog to your current site and recently converted it to be the main site and do away with the old .htm pages.  An…
So you have coded your own WordPress plugin and now you want to allow users to upload images to a folder in the plugin folder rather than the default media location? Follow along and this article will show you how to do just that!
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question