I messed up my database.

  • I’m not sure what exactly happened but here’s what I did; I needed a demo site I could use for customers. So I created a folder on the root of my domain.

    BTW this site is hosted on Hostgator… shared server.

    So the root folder of the site is ronc.me and it has WordPress installed. It was installed using Hostgator’s wizard. So to solve my problem I created this folder My-wp-site on the domain root. Then I ran the wizard and pointed it to this new folder. It installed WP and everything was working fine. I was tinkering with themes and having difficulties so I tried to backup one level i.e. instead of going to ronc.me/my-wp-site i tried to go to ronc.me and it gives me this error: Error establishing a database connection. And now neither site will work.

    After looking around it looks like the php-config files between the installations overwrote each other. i spent some time attempting to sort this out. Still no luck.

    So I’m thinking I should be able to edit the database and the config file and everything will be back to normal. But so far no luck. I’m perfectly OK with deleting the extra site but I really don’t want to lose ronc.me.

    Question # 1
    Is it possible to correct this problem directly from the database and the wp-config file.
    Also I’m using phpmyadmin to access the DB

    There is one other issue that is complicating this. I have several WP installations on this server and every DB is named myName_wrdpXXX

    That’s some number like myName_wrdp23,

    Question # 2
    Is there a way to find the actual name of the site the particular DB is for.
    Because inphpmyadmin it shows me a listof databases I.e.

    myName_wrdp23
    myName_wrdp24
    myName_wrdp25
    And so on.

    Is there a place in the DB that has the name ron.me or mySiteName. some place where I can identify what site the DB belongs to

    This would make working with this hugely more simple

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

  • In Row WP-OPTIONS col 1 should be site url

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    Is there a place in the DB that has the name [domain] or mySiteName. some place where I can identify what site the DB belongs to

    Yes, there is. It is in the wp_options table.

    Thread Starter ronc0011

    (@ronc0011)

    Thank you. That was just what I needed tosolve that problem.

    All that’s left is to sort out the database admin name and password

    One articial I was reading said I could just edit the hash in the users table. Said I could type in the password I wanted and select md5 and it would hash it automatically.
    Both of these sites only show one user.

    So if I can make the changes to the database There should be nothing left but to update edit the wp-config file ???

    Moderator Jose Castaneda

    (@jcastaneda)

    THEME COFFEE MONKEY

    That is correct. ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘I messed up my database.’ is closed to new replies.