Pick our brains...

All posts tagged mysql

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

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

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