big problem

Status
Not open for further replies.

frenzi8

New Member
Messages
4
Reaction score
0
Points
0
I am trying to fix a wordpress installation. I removed the directory only and kept the databases. however I forgot to take note of the database password. The new installation created a new database but I need to be using the old database. Am I screwed? How can I fix this?
 

descalzo

Grim Squeaker
Community Support
Messages
9,373
Reaction score
326
Points
83
cPanel -> phpMyAdmin
Choose the old WP database
Export and download it.

Do the same for your new WP database.

Then, delete all the tables in the new DB.

Then, Import the copy of the OLD DB into the new DB.

Conversely, you can try to use the OLD db. Edit the WP files to use the old db. Use your cPanel username and password for the username & password. NOTE: Not really recommended.
 
Last edited:

frenzi8

New Member
Messages
4
Reaction score
0
Points
0
cPanel -> phpMyAdmin
Choose the old WP database
Export and download it.

Do the same for your new WP database.

Then, delete all the tables in the new DB.

Then, Import the copy of the OLD DB into the new DB.

This is what I did, it doesn't work. now when I go to my wordpress page it shows absolutely nothing at all. :confused:
As for the second part I'm not sure what you mean exactly. I tried putting in the old db name in the wordpress installation details but it need the old db password as well. which I don't have.
 

descalzo

Grim Squeaker
Community Support
Messages
9,373
Reaction score
326
Points
83
I tried putting in the old db name in the wordpress installation details but it need the old db password as well. which I don't have.

Use your cPanel username for the db username. Use you cPanel password as the db password.
 

frenzi8

New Member
Messages
4
Reaction score
0
Points
0
I'm tellin ya, that doesn't work either. and I know I have the correct db name too. As well as the correct password. Can't an admin just retrieve the db password some way for me?
 

frenzi8

New Member
Messages
4
Reaction score
0
Points
0
nevermind, I figured out the problem. I had to upload my theme again. everything seems to be working now :)
 

descalzo

Grim Squeaker
Community Support
Messages
9,373
Reaction score
326
Points
83
I think I had a brain fart.

cPanel -> mySQL Databases

You should see the name of the db user assigned to the old WP database

Create a new user with a new password.

Add that user to the old WP database. (remember the full name is cPanelUserName_whatever)

Use that info in the WP config file.
 
Status
Not open for further replies.
Top