How do I access my Staging Databases?
First navigate to the staging page inside your vCanopy account. Unless you’ve gone through this process before, all of the database icons will be displayed in orange instead of green like below. Click on the orange database icon of the staging website you wish to access. This will open up a modal as shown below. […]
Diagnosing and Fixing: Error Establishing a Database Connection
This is one of the more common, and more scary WordPress errors, but it can usually be solved pretty quickly. Below is our guide to diagnosing and fixing the database connection errors on your WordPress sites. For those very rare cases where it can’t be solved, such as Malware/hacks that can’t be undone, you’ll need […]
How to backup / export / import a WordPress database
Introduction There are multiple, quick and easy ways to backup your websites database. In this article, we’ll look at 2 different options: phpMyAdmin and WP-CLI TABLE OF CONTENTS Exporting via phpMyAdmin Importing via phpMyAdmin Exporting via WP-CLI Importing via WP-CLI There are also popular plugins you could use such as All in One WP Migration, UpdraftPlus, WP Database […]
Converting MyISAM to InnoDB
A lot of the times when we see a performance related issue on a website it’s related to the database not being optimized. MyISAM is often a primary culprit and is an older, less efficient, and less reliable database storage engine than the more modern InnoDB. Part of the reason for this is that MyISAM […]
vCanopy Database Rewrites and Workflow
Introduction In this article we’ll take a look at how and when vCanopy will run database rewrites on your servers, as well as how to run these operations in the most efficient way possible to improve your workflow and reduce the time it takes to run these search and replaces. TABLE OF CONTENTS vCanopy Search […]
How to Fix the PHPMyAdmin “Bad Userdata” Error
Opening PHPMyAdmin (PHPMA) for both your live websites and staging sites is usually very quick and easy – you simply click on the little database icon next to your site, and PHPMA will open up in a new window and instantly log you in. If you’re experiencing a “Bad Userdata” error when you open up […]