Find and Replace Text in MySQL

A simple one-liner for replacing all occurrences of a search string with a replacement string.

UPDATE table SET fieldName = REPLACE(fieldName, 'find', 'replace');

Dell System Recovery Steps

Steps to perform a system recovery on a Dell system:

1. Reboot, and press Ctrl + F11 at the Dell logo.
2. The Dell PC Restore by Symantec screen will come up.
3. Select “Restore” or use the Tab key to highlight it and press Enter.
4. if you wish to continue, click “Confirm”, or use the Tab key to highlight it and press Enter.
5. When the utility is finished, click “Finish”, or use the Tab key to highlight it and press Enter.

Acer PC System Recovery

1. Power on the machine
2. At the white ACER BIOS screen, hold the “Alt” key and press the “F10” key simultaneously to start Acer eRecovery
3. Once eRecovery has loaded, click “Restore to Factory Default Settings”
4. Click “OK” to continue
5. From here, the eRecovery process will update all the data on the C: drive and restore a fully functional factory image (approximately 10 minutes).
6. Once eRecovery has run, press “OK” to reboot unit

Barack Obama Wins!

Barrack Obama has made American History. Not only is he the 44th President of the United States, he is the first black President for the United States.

MySQL Error 1148 Fix

Not sure if you’ve seen this error before….

ERROR 1148: The used command is not allowed with this MySQL version

Don’t get discouraged by this error if you’re running a fairly recent version of MySQL. According to MySQL, the error means that the loading of local files is disabled in MySQL configuration. All you need to do is enable loading of local files in the MySQL configuration. There are two ways to go about enabling the loading of local files depending on the type of environment MySQL is setup on.
Read more »

Windows XP Registry Backup and Restore

The Windows Registry is the central storage for all computer configuration data. Backing it up is quite simple and can really save you when you need that backup.

Backup

1. Click Start, click Run, type %SystemRoot%\system32\restore\rstrui.exe, and then click OK.
2. On the Welcome to System Restore page, click Create a restore point, and then click Next .
3. On the Create a Restore Point page, type a name for the restore point and then click Create
4. After the restore point has been created, click Close.

Restore

1. Click Start, click Run, type %SystemRoot%\System32\Restore\Rstrui.exe, and then click OK.
2. On the Welcome to System Restore page, click Restore my computer to an earlier time (if it is not already selected), and then click Next .
3. On the Select a Restore Point page, click the system checkpoint. In the On this list select the restore point area, click an entry that is named “Guided Help (Registry Backup),” and then click Next. If a System Restore message appears that lists configuration changes that System Restore will make, click OK.
4. On the Confirm Restore Point Selection page, click Next. System Restore restores the previous Windows XP configuration and then restarts the computer.
5. Log on to the computer. When the System Restore confirmation page appears, click OK.

Read more »

Media Temple Tips

Here are a few Media Temple (mt) tips that I’ve collected over the years.

1. Quick Access to phpMyAdmin

Use this URL to directly access phpMyAdmin without logging in through Media Temple’s AccountCenter. Be sure to replace ##### with your site number.

https://s#####.gridserver.com/.tools/phpMyAdmin/index.php

2. Backing Up MySQL Databases

This method works regardless of the size of your database. You must have SSH enabled for the serveradmin user.

1. Log into your server via SSH and cd into a directory where you have write access such as:

cd /home/s#####/domains/mt-example.com/html/

2. Enter the following command:

mysqldump --add-drop-table -h internal-db.s#####.gridserver.com -u username -p dbname > dbname.sql

* Replace ‘username’ with your MySQL username.
* Replace ‘db#####’ with the name of the database to be backed up.
* Replace dbname.sql with what you’d like to name the backup file.

3. Enter your MySQL password at the prompt. If you do not know your password you can reset it in your AccountCenter.

3. Find out your Cluster and Storage Segment

Each (gs) grid-service resides on one of Media Temple’s clusters and each cluster is divided into individual storage segments. Although the cluster is the permanent home for your (gs) grid-service, while the storage segment is subject to change. Due to grid server system maintenance, it’s important to know which cluster and storage cluster your (gs) grid-service is using so you’ll know whether your grid-service will be affected.

System status: http://status.mediatemple.net

To find your grid-service’s grid cluster and storage segment, you can use either of the following URLs to find this information as well.

http://s#####.gridserver.com/gs-bin/gridinfo

http://yourdomain.com/gs-bin/gridinfo

Be sure to replace ##### with your site number, or replace yourdomain.com with your domain.

Russell Peters’ Funniest Jokes

Here’s some of Russell Peters‘ funniest jokes. Enjoy!

1. Chinese & Indian People Doing Business

Read more »

Death by Tray

This lego animation of comedian Eddie Izzard’s idea of the Death Star Canteen is almost a year old… this was my first time seeing it.