Blog

All Posts filed under MySQL

---

Moved a WordPress website database or any website using MySQL from one server to another and getting funky/weird characters? The Character set setting is probably to Blame

Posted on May 16, 2013 | Filed in Featured, MySQL, Wordpress

When moving a WordPress website or just about any website that uses MySQL as its database, you need to pay attention to the character set used for Collation in the…

Read More

---

How to Find and Replace Text in a MySQL Database using SQL

Posted on September 15, 2012 | Filed in MySQL

update TABLE_NAME set COLUMN_NAME = replace(COLUMN_NAME, ‘String to be Matched’, ‘New String’); Example: update My_Clients set Company_Name = replace(Company_Name, ‘Apple’, ‘Google’);

---

WordPress Pages and Posts content missing or pages blank? Use PHPMyAdmin to fix WordPress tables

Posted on August 03, 2012 | Filed in Featured, MySQL, Wordpress

If (suddenly) your WordPress site is missing content, chances are that one or more tables have crashed. Using PHPMyAdmin connect to the WordPress database. The database info can be found…

Read More

---

Syntax for connecting to MySQL via the command line

Posted on May 12, 2012 | Filed in Featured, MySQL

Once you make the connection specified below, you can then issue whatever MySQL command you like. Syntax: mysql -u YOUR-USER-NAME -h YOUR-SERVER-NAME -p DATABASE-NAME Example: mysql -u yourname -h mydatabase.com…

Read More

---