Main Topics

  • Checking WordPress Database Sizes with WP-CLI

    By using a simple WP-CLI command, you can easily find the size of your WordPress database, as well as the sizes of the individual tables inside it. In this article, we'll show you how to check your database and table sizes with WP-CLI. Getting the Total Database Size To get your total database si...

  • Searching Your WordPress Database with WP-CLI

    Searching through entire databases can be a hassle, but WP-CLI makes it easy. Here's how to search your WordPress site's database for the information you need. Searching All Database Tables Standard Behavior: Search All Registered Tables By default, the standard database search command will only ...

  • Importing Databases Using PHPMyAdmin

    Although importing databases is usually best done through a command line interface such as WP-CLI, databases can also be imported using PHPMyAdmin if you need to. In this article, we'll show you how to import a SQL file into a database by using PHPMyAdmin. Begin by logging into PHPMyAdmin. Next,...

  • Exporting Databases Using PHPMyAdmin

    If you're trying to migrate your site to Pagely but your former host doesn't offer SSH or access to export your database, PHPMyAdmin is usually your next best option. In this article, we'll show you how to export your database within PHPMyAdmin. Begin by logging into PHPMyAdmin. Next, use the le...

  • Importing Databases Using WP-CLI

    WP-CLI is a great tool for simplifying various actions on your WordPress site. One of the great features of WP-CLI is the ability of import databases. In this article, we'll show you how to import a database using WP-CLI. These actions can be performed easily in any environment provides WP-CLI su...

  • Exporting Databases with WP-CLI

    If you have SSH access, WP-CLI is usually the fastest way to export a copy of your database. In case you're not already familiar with WP-CLI, it's a command line tool for managing WordPress and does a great job at simplifying many common tasks. Since WP-CLI is an open source tool that's used on m...

  • phpMyAdmin Database Management

    phpMyAdmin is available for all accounts. Depending on your account type, you may need to request it via a support ticket. While phpMyAdmin can be a useful tool for managing databases from within a browser, it is recommended that you use a dedicated database client such as Sequel Pro or DBeaver....

  • Manually Updating Your WooCommerce Database via Command Line

    In certain cases, the WooCommerce plugin will update, but the WooCommerce database update will fail. The failure of updating the database is usually caused by PHP timing out, especially on the shared hosting environment, since PHP only has 60 seconds to execute via a web request. This version mis...

  • MySQL Command Line Client

    Need to initiate a command line MySQL connection? We've got your covered! In this article, we'll show you how to do it either by using WP-CLI or directly using the mysql command. Using WP-CLI WP-CLI is installed on all VPS/Enterprise hosting accounts and is a great tool to simplify WordPress-rela...

  • Connecting to your Database with WP-CLI

    Using WP-CLI to connect to your database is a great shortcut to otherwise long connection commands. If you need to pass manual database commands to your WordPress database, WP-CLI is a great way to get there. Here's how to do it: Begin by connecting to your VPS over SSH. Next, you'll want to acc...

  • Connecting to Your Database with a Remote MySQL Client

    If you need a GUI interface for database management, you can use SSH tunneling to connect to the database. Note: To use an SSH tunnel, you'll first need to have SSH access. Before continuing, be sure that you have already configured SSH access. If not, take a look at one of the following articles...