7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

Error establishing a database connection

by Sornie Samante
5 replies
Hey there warriors,

PLEASE HELP ME, I am migrating a new site to a new server, so basically, I created a new database along with all other information, if you are familiar with BackupBuddy Restoration & Migration Tool, I always get stuck up in step 5, I really don't know where I went wrong on the process.

I have checked the wp_config.php file on my host but everything is correct.
DB_NAME, DB_USER, DB_PASSWORD, DB_HOST, and Stable_prefix

While testing the Database Setting using the information I have just created I have the following problems:
Code:
Logging in to server ... Success.
2. Verifying database access & permission ... Success.
3. Verifying no existing WP data ... Failed.
    Error: WordPress already exists in this database with this prefix.
4. Overall mySQL test result ... Failed.
I was thinking that maybe, there is an existing WP database which I really don't know as well, if there is, what are the possible ways to locate the previous database of my site. .. too bad as well, I don't have record on file ..

Very frustrating. HELP :confused:
#connection #database #error #establishing
  • Profile picture of the author Unomateo
    does the server have an admin tool like Cpanel?

    Do you have access to PHPMyAdmin?

    that will let you look at the database. Access the DB with the same credentials as the one's BB is trying to use and you will see if there is another WP install
    {{ DiscussionBoard.errors[4685800].message }}
    • Profile picture of the author Sornie Samante
      Originally Posted by Unomateo View Post

      does the server have an admin tool like Cpanel?

      Do you have access to PHPMyAdmin?

      that will let you look at the database. Access the DB with the same credentials as the one's BB is trying to use and you will see if there is another WP install

      Hey there, Cpanel is my admin tool, and I have access the PHPmyAdmin but I have a question where would I see that there are other existing WP installed?

      I can only see the previous database I am currently using on top of all the files of my site.

      Thanks for your help buddy!
      {{ DiscussionBoard.errors[4688043].message }}
      • Profile picture of the author Unomateo
        you would definitely see another wordpress database if you are logging into phpmyadmin...

        Another place to look would be the database section in cpanel. If you look there you will see all the db's that have been made. You might be logging into phpmyadmin as a different user then the script so you don't see the existing wp db, but backup buddy does.
        {{ DiscussionBoard.errors[4695398].message }}
  • Profile picture of the author lordspace
    you could try installing using a different db prefix.
    The default is "wp_" I think.
    Signature

    Are you using WordPress? Have you tried qSandbox yet?

    {{ DiscussionBoard.errors[4695652].message }}
    • Profile picture of the author Sornie Samante
      Originally Posted by lordspace View Post

      you could try installing using a different db prefix.
      The default is "wp_" I think.
      Thanks for your help, I have actually removed the prefix "wp_" and it works.
      {{ DiscussionBoard.errors[4707406].message }}

Trending Topics