i cant repair my database..

  • Stefano

    (@madking-web-design)


    9 years, 8 months ago

    hi some minutes ago i tryed to do some optimizations to my personal test website that i use for speed optimizationand for my personal purposes.I tryed some changes through a database plugin called “wp database optimizer“.

    The problem is that i erased (drop)somethink that i shouldn’t…
    So..i get the followings errors.

    One or more database tables are unavailable. To allow WordPress to attempt to repair these tables, press the “Repair Database” button. Repairing can take a while, so please be patient.

    I pressed repair and i took the following errors:

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

    The wp_posts table is fine.

    The wp_comments table is fine.

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

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

    The wp_postmeta table is fine.

    and the errors still go on.
    So..i tryed repair through phpMyadmin doing the repairs but i cant reverse it..

    any idea somethink i do wrong????? i really need that site back

    ** I have some Gzipinstall htaccess backups…
    Anyone that can help to give access to my admins plz?

Viewing 4 replies - 1 through 4 (of 4 total)
  • J M

    (@hiphopinenglish)

    9 years, 8 months ago

    If this happened to me, I would restore the most recent DB backup I had.

    Thread Starter Stefano

    (@madking-web-design)

    9 years, 8 months ago

    im trying to do that through phpMyadmin, i restore there some files as i descibed before but nothing happenes…i dont see somethink
    when i hit my site madkingwebdesign.com i get the error establishing connection and when i try to login to wp-admin i get

    One or more database tables are unavailable. The database may need to be repaired.

    i push the repair button and get again what i wrote before…..see here

    Senff – a11n

    (@senff)

    9 years, 8 months ago

    Note that “repair” does not equal “restore”.

    I think the database is damaged beyond repair, and I’m afraid the only option you really have is to restore from a backup file, if you have one.

    Not sure what the Gzipinstall htaccess backups are you mention — does that contain a backup of your entire site? Files and database?

    Thread Starter Stefano

    (@madking-web-design)

    9 years, 8 months ago

    No..i don’t have any back up the wen site is new enough so i made some tests..it was stupid if me that i didn’t have any back up…i have the files on ftp account but i guess can’t restore anything from there because it was some critical element that erased and probably erased from the ftp files too…i ve just asked my hosting provider for any database back ups but this site is in a free web hosting and im not sure if there is any …so i ll wait a little bit if i find another way ..or i m gonna fix it from scratch again…the Gzipinstall make only ht-access back ups ..

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘i cant repair my database..’ is closed to new replies.