Database problems…

  • Resolved erikturner

    (@erikturner)


    13 years, 9 months ago

    In an attempt to download my database to try and link it with a local installation of wp for development purposes, I seem to have corrupted / erased / messed up my database. I have a .sql file that I downloaded via the “export” feature of phpmyadmin on godaddy’s site, but ever since I did that, my website doesn’t work and when you go to https://www.erikturner.net/wordpress it just says “database error”. When trying to log into my dashboard, it says either the username / password in the wp-config is wrong (I checked, it’s OK) or the database cannot be contacted.

    I tried uploading the .sql I have locally back to the server, but it gives me an error that indicates that it already exists. I can produce the details of this error if it matters, but I’m guessing I’m doing something more fundamentally wrong…

    help!!
    thanks ??

    Erik

Viewing 7 replies - 1 through 7 (of 7 total)
  • Alwyn Botha

    (@123milliseconds)

    >>>. I have a .sql file that I downloaded via the “export” feature of phpmyadmin on godaddy’s site, but ever since I did that, my website doesn’t work and when you go to https://www.erikturner.net/wordpress it just says “database error”.

    exporting will never cause a database error – you just made a copy now the orig. no longer works !!

    is sql running now?

    https://en.forums.wordpress.com/topic/error-establishing-a-database-connection-1

    Thread Starter erikturner

    (@erikturner)

    thanks for your reply… i didn’t see any links in that thread which dealt with diagnosing whether sql was running (it was mainly just shoving people over to .org instead of .com- I just learned the difference and glad I blindly chose the right one :). I’ll search around a bit here and see if I can’t find a way to verify this…thanks
    Erik

    Thread Starter erikturner

    (@erikturner)

    let me get the stupid question out of the way too… I want to make sure I have the right password in the wp-config.php file, as I think I do. That username and password should match the username and password set up with the MySQL database on your host’s server, correct? So I have godaddy… I’ve logged onto their site, gotten into the MySQL, and changed the password to make sure it matches with the wp-config.php file. That is correct, right?

    thanks!
    Erik

    Alwyn Botha

    (@123milliseconds)

    >>That username and password should match the username and password set up with the MySQL database on your host’s server, correct?

    yes

    I still do not understand how export messed any of this up?

    and changed the password to make sure it matches with the wp-config.php file.

    YES

    Thread Starter erikturner

    (@erikturner)

    I’m not sure either. My SQL database has a status of “setup” on godaddy. Does the .sql file encapsulate the whole database? Would it be best to just delete whatever I have on the server and try and upload what I exported?

    Alwyn Botha

    (@123milliseconds)

    >>>Does the .sql file encapsulate the whole database?

    only if you exported all tables and all its data

    >>would it be best to just delete whatever I have on the server and try and upload what I exported?

    Not until you are sure everything is in the export.

    ??My SQL database has a status of “setup” on godaddy.

    I do not know godad

    Thread Starter erikturner

    (@erikturner)

    123milliseconds- thanks for reading my thoughts here… i’ve realized that my wp-config.php file was actually not updating properly, so the password was what was not matching, and the database was fine. Thanks!

    Erik

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Database problems…’ is closed to new replies.

Tags