Support » Localhost Installs » website not working after computer restart

  • hi!
    after restarting the computer MAMP could not connect to MySQL server.
    i did not make any backup (silly beginner 🙁 ), so checking online for solution i found some things to try:
    i saved the data in db/mysql56/mywebsite and reinstall MAMP. the connection to MySQL server in MAMP is now back and i put back the files correctly.
    nevertheless now i can only see the wordpress install page if i access localhost:8888/mywebsite.

    from some sites around the web i get that i might have a problem with my mysql database.
    i also tried ‘define(‘WP_ALLOW_REPAIR’, true);’ in wp-config.php and i obtain the following message:

    wp_users: Table ‘andreabinda01.wp_users’ doesn’t exist
    wp_usermeta: Table ‘andreabinda01.wp_usermeta’ doesn’t exist
    wp_posts: Table ‘andreabinda01.wp_posts’ doesn’t exist
    wp_comments: Table ‘andreabinda01.wp_comments’ doesn’t exist
    wp_links: Table ‘andreabinda01.wp_links’ doesn’t exist
    wp_options: Table ‘andreabinda01.wp_options’ doesn’t exist
    wp_postmeta: Table ‘andreabinda01.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘andreabinda01.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘andreabinda01.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘andreabinda01.wp_term_relationships’ doesn’t exist
    wp_termmeta: Table ‘andreabinda01.wp_termmeta’ doesn’t exist
    wp_commentmeta: Table ‘andreabinda01.wp_commentmeta’ doesn’t exist

    can you please help me recovering my site?
    thank you!!!

Viewing 5 replies - 1 through 5 (of 5 total)
  • Moderator t-p

    (@t-p)

    Access phpmyadmin from your hosting control panel. Select the tables you note above and then, at the bottom, where it says “with selected” in the dropdown, select “repair”.

    hi t-p thank you for the answer.
    i am on phpmyadmin now and selecting the database i only see the message”No tables found in database.”

    expanding the plus icon on the left i see the list of tables but clicking on them i see a great amount of red messages like:

    Warning in ./templates/table/structure/display_table_stats.phtml#4
    Illegal string offset ‘TABLE_COMMENT’
    Backtrace
    ./libraries/Template.php#152: include(./templates/table/structure/display_table_stats.phtml)
    ./libraries/controllers/table/TableStructureController.php#1379: PMA\libraries\Template->render(array)
    ./libraries/controllers/table/TableStructureController.php#1255: PMA\libraries\controllers\table\TableStructureController->getTableStats()
    ./libraries/controllers/table/TableStructureController.php#355: PMA\libraries\controllers\table\TableStructureController->displayStructure(
    array,
    array,
    array,
    boolean false,
    array,
    array,
    )
    ./tbl_structure.php#47: PMA\libraries\controllers\table\TableStructureController->indexAction()

    Moderator t-p

    (@t-p)

    My suggestion is to get assistance of your hosting provider to repair your database.

    Also, if you haven’t already done, always backup your database before doing any actions, just in case something really goes wrong. You can never have enough backups!

    yeah… i will start backups every alternate day…
    i don’t have a hosting provider because i was waiting for the site to be ready before getting a host…
    thank you for the tips!

    Same Issue, as I am also using localhost for development.

    I am using mac and noticed it after os update, found out that there is some mysql update with that, and it is not using camel case table names.

    I am not that much familiar with sql, but I think if I can rename all table names through a script/query, will be helpful.

    Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.