Error establishing a database connection

  • Resolved UgoDimma

    (@lovecoinz)


    11 years, 11 months ago

    Hey guys,
    after transfering my site from local server(xampp) to live server, i received this error message, “Error establishing a database connection”
    I then apply the method i saw on web using

    define(‘WP_ALLOW_REPAIR’, true);

    but it returns this error report,

    The lc_commentmeta table is not okay. It is reporting the following error: Table ‘u647526685_wulul.lc_commentmeta’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the lc_commentmeta table. Error: Table ‘u647526685_wulul.lc_commentmeta’ doesn’t exist

    please guy, what should I do about it?

Viewing 6 replies - 1 through 6 (of 6 total)
  • esmi

    (@esmi)

    11 years, 11 months ago

    Looks like you did not import the database correctly. Try reviewing Moving_WordPress and carrying out the site move again.

    Thread Starter UgoDimma

    (@lovecoinz)

    11 years, 11 months ago

    Thanks fro the quick response.
    I does everything to my ability to keep thins work as expected. this is the procedure i took;

    1 I made use of search and replace to change my urls on the local server,
    2 export my database from local server
    3 upload it to my live server database
    4 uploaded my wordpress install to my new host, using ftp client
    5 edit my wp-conf.php file, and update the user details to match the new database info.

    now i checked my site, it appears that everything is ok, but when i tried to access other pages and post, it returns the error. please, does my method goes contrary?
    can i export and import that only data “commentmeta table”?

    esmi

    (@esmi)

    11 years, 11 months ago

    I made use of search and replace

    which search & replace tool did you use?

    Thread Starter UgoDimma

    (@lovecoinz)

    11 years, 11 months ago

    I used the one i downloaded from https://interconnectit.com/products/search-and-replace-for-wordpress-databases/

    esmi

    (@esmi)

    11 years, 11 months ago

    Try re-importing the database backup file. You’re missing a table.

    Thread Starter UgoDimma

    (@lovecoinz)

    11 years, 11 months ago

    Ok, will try it later, but will not fail to report back with the outcome.
    ones again, Thank you for your immense reply and support.

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

The topic ‘Error establishing a database connection’ is closed to new replies.