Re-opening an existing database
-
I’ve recently started work on a new site a few days ago – I went through the right procedure via MAMP, set up a new database and logged in. Today my computer closed down unexpectedly and when I’ve tried re-opening the site I’m getting the following error chain –
WordPress database error: [Table ‘wp_mw.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_ciWordPress database error: [Table ‘wp_mw.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_ciThis is an abridged version, basically all the files in the db are the same status. I’ve logged on to phpmyadmin and the datatbase I set up is there but when I try to log on I get this every time.
This is my first site I’ve built in wordpress – my background is RoR / front-end – not sure if this is something simple I’m missing or if I need to re-install? Any assistance appreciated.
- The topic ‘Re-opening an existing database’ is closed to new replies.