Database issue, need cli mysql help

  • I just finished posting early this afternoon and then got a message that said…

    WordPress
    Error establishing a database connection
    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost.
    * Are you sure you have the correct username and password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

    I tried going into my GUI Control Panel, and could not get phpmyadmin to accept me. Later the Control Panel was inaccessable, and still is. PHPWebhosting is clearly having a bad day…&^) And they aren’t returning messages sent to support.
    I do have ssh access, and so was wondering how I might reach in that way and make a backup of my DB for possible salvage.
    I know this skirts the limits of interest on this forum, but an odd thing is that my abandoned Movable Type install still works, and is now doing duty as a “site down” poster. MT was also using a DB on the same server, and it’s still working.
    I saw another post here about a lost DB, and am wondering if there’s a larger problem.
    I’m using v. 1.3alpha4, IIRC.
    Thanks for any assistance, going back and working in MT was a good reminder of how much better WP is.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator James Huff

    (@macmanx)

    I think you should leave this alone for about twenty-four hours, and send a support email to your host, asking them what’s going on. As you mentioned, they’re having a bad day. You mentioned that you couldn’t access your database through phpmyadmin. Therefore, MySQL is probably down, which is why WordPress can’t connect to it. As long as MySQL is down, you’ll never be able to access it to make a backup. So, just wait and see if your host can clear it up in twenty-four hours.

    Thread Starter cdkrall

    (@cdkrall)

    Just came back, 8 hours later…
    Which reminds me, would be great to have a way to backup our DB from within the admin panel of WP. I had a plugin last summer that promised to do that, but it didn’t work.
    Thanks for replying and being the voice of reason while I panicked…&^)

    Moderator James Huff

    (@macmanx)

    Just follow the phpmyadmin instructions. Once again, if phpmyadmin can’t access your MySQL database, then neither can WordPress or any other backup feature. https://www.tamba2.org.uk/wordpress/backup/

    Thread Starter cdkrall

    (@cdkrall)

    Thanks for that link. Right after the site came up yesterday it went back down.
    I tried the instructions on the CLI page, and after some experimenting, found what my server needed, but by then had exceeded my connection attempts limit..&^)
    This command is what would have worked for me…
    mysqldump -uusername -p --opt mydatabasename > dumpname.sql
    If nothing else, I learned more about CLI.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database issue, need cli mysql help’ is closed to new replies.