Pick our brains...

All posts in Databases

Cpanel There Was a Problem Adding the User: (XID hc2f35) Database Error: Can’t Find Any Matching Row in the User Table

Well now here’s an interesting error that mysteriously "just started happening" for no apparent rhyme or reason. We were working on a Cpanel server that we’re very familiar with, and went through the usual process of creating a new mysql database, creating a new mysql user, and then adding that . . . Read more

How to use WP-CLI

I wanted to write some quick notes regarding the feedback that we got from our developers about how to export and import databases using WP-CLI. What a wonderful tool it is! WP-CLI stands for “WordPress Command Line Interface”. There are a bunch of commands you can use to manage WordPress . . . Read more

How to Use Rsync, a Very Beautiful File Transfer & Synchronization Tool

Rsync is an amazing tool for direct server-to-server data transfers.  Very speedy, and very smart! You can use rsync to do synchronizations between source and destination, comparing them, and copying only what’s changed.  What’s especially amazing is that rsync only transfers the “parts” of files that are different.  This works . . . Read more

Mysql Database Backup & Import From the Command Line

Let’s say you’ve got root privileges, and you’re working along, and you want to quickly backup a database for USERNAME on the PM servers… cd /home/USERNAME/_back mysqldump  -uroot  DATABASENAME  >  DATABASENAME_YYYYMMDD_shortDescription.sql (Check the size of the backup file, always a good idea) ls  -lah  DATABASENAME_YYYYMMDD_shortDescription.sql (Change the owner and group . . . Read more

Linux Disk Free / Disk Usage, Per Directory ~ “du”

Disk Free, human readable df -h Disk Usage, summary, human readable (I think this include DOES include hidden files / directories) du -sh Disk Usage, per directory, human readable (does NOT include hidden files / directories) du -sh * Disk Usage, per directory, human readable (INCLUDES hidden files & directories) du -sh . . . Read more

Drush, Drush, what an amazing Rush (Update Drupal from the Command Line)

*Important: When doing drush system-wide updates (ie: “drush pm-update”), drush will OVERWRITE.htaccess, index.php, and robots.txt. *Make sure you have backups of these files*. A good naming convention to use is: .htaccess_YYYYMMDD_shortDescript.bak Or similarly, index_YYYYMMDD_shortDescript.bak *Also Important: When running drush, you should be logged into ssh with the username for the . . . Read more

Migration of WordPress from Pagodabox to a Traditional Hosting Environment

Skip to end of metadata Created by Benjamin Turner, last modified on Dec 04, 2013 Go to start of metadata This guide focuses on getting the data out of Pagodabox. General Step-by-step guide for Pagodabox migration: Download the Site from Pagodabox (covered in this guide) Setup Server that will be the . . . Read more

Create a Blank WordPress Sandbox

Creation of a new, blank Wordpess sandbox is useful for wireframing or trying out new themes and/or plugins. Because we are not migrating any content from an existing site, this process is easy, and can be done with GUI tools. Overview of Steps Create a space on the server where . . . Read more

Mysql Optimizations & Server Database Tuning

A few tasty tidbits, to jog the memory about database & server optimizations… To be expanded.  Share your thoughts and suggestions! Example Server: Memory Available: 1,751,724k total Handy Queries: mysql> SHOW VARIABLES LIKE ‘%cache%’; mysql> SHOW STATUS LIKE ‘Qcache%’; My.cnf Tweaks: ; QUERY CACHE… query_cache_size = 500M query_cache_type = 1 . . . Read more