Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): Access denied for user 'root'@'localhost' (using password: NO) in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786

Warning: mysql_real_escape_string(): A link to the server could not be established in /home/wisnaeme/98JDQRKF/htdocs/pixscotland/blog/wp-content/plugins/statpress-reloaded/statpress.php on line 1786
Updating WordPress and MySQL4 to MySQL5. | PIXscotland

Updating WordPress and MySQL4 to MySQL5.

The new version of WordPress recently came out and it required MySQL5 to be in use however I had MySQL4 installed. Upgrading should be easy, but this proved not to be the case.

After much research I found this solution online. The source of my happiness is here.

I have copied the critical contents here for purposes of archival should the original be removed. This solution worked and took around 15 minutes to complete.

  1. Backup your database Wp-db-backup plugin
  2. Run the backup once it is installed. Check all the boxes to get all the data.
  3. extract the .gz file I use 7-zip open source for this
  4. create a new database on your host 5.0
  5. log into the new database
  6. import function
  7. browse and select uncompressed file
  8. Select the ascii option for character set usually utf8 will be selected
  9. click go
  10. change the wp-config.php file to point to the new 5.0 database
  11. upload the config file to your blog
  12. download and install the search and replace plugin
  13. activate the plugin You will find it under the “Manage” Tab
  14. search for ?? replace with “space character”

NOW PLEASE PAY ATTENTION!
The “Search and Replace” plugin MUST be updated. Seriously. Check and Check again.
After checking, CHECK it is active. Yes, Seriously, this drove me slightly mad.

I chose to Search and Replace only in Blog Posts. I don’t know if this is correct or not, but since you’re here I guess it worked. This replace is required as the Posts have “??” symbols throughout them after import.

(1044)

Be Sociable, Share!

    2 Comments

    1. Thanks for the post 🙂

    2. Thanks for the insight. It brings light into the dark!

    Leave a Reply to Edwin Player Cancel reply

    Your email address will not be published.

    *

    *
    = 3 times 8

    © 2018 PIXscotland

    Theme by Anders NorenUp ↑