Can't fix 'Error establishing a database connection'

  • Resolved WolfDrake

    (@wolfdrake)


    10 years, 8 months ago

    Hello,

    I have been having issues with my website for almost a week now. The issues started when, for some reason, my theme updated automatically (which I didn’t want it to do because I have an edited version). I attempted to load a saved backup from the dashboard, but the plugin seemed to crash and I received “Error establishing a database connection” on both the site and when attempting to log on /wp-admin.

    What I have tried so far:
    – Repairing and optimizing the database
    – Clearing cache.
    – Making a new database user with all privileges and updating wp-config.
    – Deleting plugins.
    – Deleting the theme.
    – Manually re-uploading the backed up version through Filezilla.

    This is the error that appeared in the log when I originally tried going back to a backup through the plugin, as well as the errors that appeared later when I tried to troubleshoot the issue:

    /home2/wolfdrak/public_html/wp-admin/error_log: [13-Oct-2015 07:45:32] WordPress database error Table ‘./wolfdrak_wordpress/wp_options’ is marked as crashed and should be repaired for query SHOW FULL COLUMNS FROM wp_options made by do_action(‘load-toplevel_page_backup-with-restore’), call_user_func_array, hmbkp_request_restore_backup, Wpbp_Restore->start, Wpbp_Restore->restore, Wpbp_Restore->restore_complete, Wpbp_Restore->restore_database [15-Oct-2015 10:56:35] PHP Parse error: syntax error, unexpected T_STRING in /home2/wolfdrak/public_html/wp-config.php on line 47 [15-Oct-2015 10:56:37] PHP Parse error: syntax error, unexpected T_STRING in /home2/wolfdrak/public_html/wp-config.php on line 47

    Does anyone have any suggestions or solutions to my issue?
    Thanks in advance!

Viewing 9 replies - 1 through 9 (of 9 total)
  • juggledad

    (@juggledad)

    10 years, 8 months ago

    I attempted to load a saved backup from the dashboard, but the plugin seemed to crash

    1) what plugin are you talking about?
    2) how -exactly – did you reload the database after you made a new database?

    (don’t be offended if you know this) – a wordpress site comprises of two parts (1) the database and (2) the code.
    The database should be backed up using a plugin (or phpMyAdmin) that will give you an export. The code should be backed up as you backup any file (you really only need to backup the wp-content folder and the wp-config.php file since you can download another copy of wordpress at any time)

    Thread Starter WolfDrake

    (@wolfdrake)

    10 years, 8 months ago

    1) what plugin are you talking about?
    2) how -exactly – did you reload the database after you made a new database?

    The plugin’s name is ‘Backup with Restore’. It backs up the files (theme, uploads, plugins, etc) on the server on timed intervals. That’s what I meant by loading from backup too.
    I’m sorry if I didn’t make it clear which part I tried reloading.

    juggledad

    (@juggledad)

    10 years, 8 months ago

    Try an older copy of your backuped files to restore. (you do have several backup versions…right?)

    Thread Starter WolfDrake

    (@wolfdrake)

    10 years, 8 months ago

    Yes, I have ~10 weeks worth of backups. Just simply overwrite through FileZilla then?

    juggledad

    (@juggledad)

    10 years, 8 months ago

    you can ovewright th files but you need to import the sql back into the database.

    Thread Starter WolfDrake

    (@wolfdrake)

    10 years, 8 months ago

    Ah, I see. That might be what actually prevented it from working the first time. Would you mind telling me how do I go about doing that correctly?

    juggledad

    (@juggledad)

    10 years, 8 months ago

    use phpMyAdmin – select the DB and then use the IMPORT tab, select your sql file and let it rip.

    Note: I have to leave now for a coule hours – I’ll check back later (and maybe on my mobile if I can)

    Thread Starter WolfDrake

    (@wolfdrake)

    10 years, 8 months ago

    Thanks a lot, I’ll try that method and get back with the result.
    It will take everything to overwrite a couple of hours anyway. And the help is greatly appreciated!

    Thread Starter WolfDrake

    (@wolfdrake)

    10 years, 8 months ago

    Glad to report a success! All I had to do was import the backed up SQL file and that solved the issue. Didn’t even have to overwrite the files, so saved some time on that too.

    Thanks a lot for your help Juggledad! I really appreciate it!

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

The topic ‘Can't fix 'Error establishing a database connection'’ is closed to new replies.