Articles in MySQL
Below is the SQL script that will attempt to identify and remove duplicate posts in your WordPress database. This script can be useful for autoblogging. If you use plugins like WP-o-Matic to pull full-text RSS …
Whenever you upgrade your WordPress installation or do development work, it is always a good idea to be working on a copy of your main site and not on the real thing. Copying WordPress installation …
Heavy traffic, hungry SQL queries, leaky applications will eventually leave your server low on memory. Apache will go on a hunt for swap space and MySQL will start freezing in thoughtful contemplation. Your hard drives …
A day will eventually come when your need to find and replace a string of text in your database. You don’t know which row, or which column, or which table. Heck, you may not even …
Running MySQL commands from a shell script is a relatively simple task that has a lot of people baffled. Some say its too complicated and suggest using PHP or Perl, others claim doing so is …
CSV is a field-separated format that can be easily imported into a spreadsheet application. Usually the separator field is a comma. However, sometimes it is easier to select a more unusual character (like “@” for …
Query cache can significantly speed up database operations for identical search queries. This is particularly useful for Web server applications, where multiple requests for the same data are a regular occurrence.
To enable query caching on …
Using LOAD DATA LOCAL INFILE is a much faster way to insert lots of data into a table than using INSERT. The only preliminary step is to format the input file with unique field separators.
In …
Creating an index for specific columns in a database table can greatly speed up search operations. This is important for any database query that use WHERE in the SQL string. Below is a practical example …
It is surprising how many people run into problems trying to use the GRANT command: everything from not being able to access a database table to losing admin access to MySQL altogether. There’s a bunch …
Remember all the MP3s you ripped or downloaded sitting in that big directory somewhere on your hard drive? Getting those files organized by genre, performer, or album can be daunting task if the MP3s …
It is sometimes necessary to use complex select and insert queries with dozens of variables. Writing such queries by hand is a tedious process and the chance of making a mistake is high. A few …
A simple one-line command to perform find and replace operations in MySQL:
update TABLE set COLUMN = replace(COLUMN, ‘OLD_VALUE’, ‘NEW_VALUE’);
Bookmark on Delicious Digg this post Recommend on Facebook share via Reddit Share with Stumblers Tweet …
The following is a process for migrating spreadsheet data to MySQL database using a Shell script in a Unix environment. To follow this tutorial you must already know how to create MySQL schemas and tables. …
FROM: http://www.sunhelpdesk.com/articles/Mysql_Apache2_PHP_Solaris_9.htm?file=Mysql_Apache2_PHP_Solaris_9.htm
Note:
I would consider using BlastWave to install your precompiled binaries if your system is connected to the Internet. This documentation will use some of the binaries they provide to make the installation a bit …
FROM: http://ampubsvc.com/~meljr/a2m4p5s8.html
BY: Mel Lester Jr.
This page briefly documents the installation of Apache 2.0.xx, MySQL 4.0.xx and PHP 5.0.x on Sparc Solaris 8.
Disclaimer
Rapid revision is the nature of Open Source products and the versions I refer …
The following Korn shell function will read the a directory containing CSV data files named server_sysstat.20051119.csv with format:
server_2,7,1461,2,2195979,90,00:00:17,42
server_2,6,1467,2,2200018,85,00:02:18,42
server_2,6,1462,2,2198306,89,00:04:20,42
The function will read each file line by line and do either an insert to or an update …
