WordPress is Gone after MAMP crash (My SQL server)

  • m00mascarpone

    (@m00mascarpone)


    8 years ago

    Hi all,

    My MAMP crashed, after that it wouldn’t connect to My SQL server. I tried a lot of different tips, but the only one that worked was this one:

    “-go in the folder MAMP/db/mysql/ – delete all files that IS NOT A FOLDER (files like ‘mysql-bin.XXXXXX’ / ‘mysql-bin.index’/ ‘ibdata1’ / ‘ib_logfileX’

    don’t worry, this doesn’t erase any of your database, but make sure you don’t delete the folders. That’s where the data of your databases are stored.” from this helpdesk

    It worked, but when I tried to visit My Site, it brought me to an WordPress Installation screen. But I already installed WordPress with a Theme and had been working on the site for quite a while.

    I panicked and then put the files from mamp/db/mysql/ back from the trash, overwriting the new files (that were suddenly in the folder again).

    This didn’t do anything, so I tried to go through the installation process again, hoping my website would be waiting for me on the other side, but now it says this:

    WordPress database error: [Table ‘********.wp_users’ doesn’t exist]
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(255) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar(100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(255) NOT NULL default ”, user_status int(11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename), KEY user_email (user_email) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

    WordPress database error: [Table ‘*******.wp_usermeta’ doesn’t exist]
    CREATE TABLE wp_usermeta ( umeta_id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) unsigned NOT NULL default ‘0’, meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key(191)) ) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci

    I don’t have any experience coding or making a website, I’m surprised I made it this far but I can’t really bluf my way out of this. I’m freaking out properly, hope anyone can help me.

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

    (@esmi)

    It looks like some of your WP site’s database has been lost. Do you have a recent database backup you could use?

    Thread Starter m00mascarpone

    (@m00mascarpone)

    I’m afraid not. Where would I normally extract/save the backup?

    You would have to create a backup it does not do it by itself.

    Why bother with MAMP? OSX comes with Apache web server built in. With a few tweaks you can run WordPress sites directly from your sites folder:
    https://mallinson.ca/osx-web-development/

    Similar problem… I upgraded to the new version of MAMP and could not log in to my server. I DO have a backup from last week, so renamed my new MAMP and copied over my entire MAMP folder from my backup – could not connect to MySQL so I used the tip above and I can now connect, but I get the same problem when I try to connect to my localhost site – it wants me to reinstall WordPress. Where do I go from here?

    Your website and database are in the MAMP folder. If you upgrade or replace the folder, everything is GONE!

    I have everything backed up – I have multiple copies of my MAMP folder in different places (external drive, USB flash drive, etc) and MAMP actually does it’s own backup of the previous folder when it upgrades, so everything is still there. I just cannot get connected to mySQL database now. And if I use the tip above it wants me to reinstall WordPress. Does anyone have any tips?

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress is Gone after MAMP crash (My SQL server)’ is closed to new replies.

Tags