Updating wordpress database
If your blogging platform is Word Press and your webpage is redirecting to a page where you are getting a message as “Database upgrade required” even if your wordpress and database is up to date then read the instruction provided below to resolve the issue.Problem Scenario: Webpage URL redirected to a Word Press page where the instruction appears as “Database upgrade required” or Installation Window for Word Press appears even the wordpress is already installed and up to date.
His site is still up, but when I try to get into the back end using /wp-admin I'm hit with a message that states: When I click on the button that says "Update Word Press Database" it does nothing.
Use the code as below and swap in your old and new URLs, no trailing slashes.
Also if necessary change the table prefix values where applicable (ie wp_ ) UPDATE wp_options SET option_value = replace(option_value, ' ' WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, ' UPDATE wp_posts SET post_content = replace(post_content, ' ' UPDATE wp_postmeta SET meta_value = replace(meta_value,' protected][~/Desktop]: mysql -u root -p databasename Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the My SQL monitor. Your My SQL connection id is 892 Server version: 5.5.13 My SQL Community Server (GPL) Copyright (c) 2000, 2010, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. mysql UPDATE wp_options SET option_value = replace(option_value, ' ' WHERE option_name = 'home' OR option_name = 'siteurl'; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysqldefine('DB_NAME', 'databasename'); /** My SQL database username */ define('DB_USER', 'username'); /** My SQL database password */ define('DB_PASSWORD', 'password'); /** My SQL hostname */ define('DB_HOST', 'localhost'); Now everything should link up perfectly.
This step varies greatly and is entirely dependent on what hosting provider you are using.
Usually you go to the My SQL admin area and click “Create new database” or something along those lines.