The latest MySQL Community Edition release, 5.0.67 will not be included in Debian Lenny as the distribution is frozen meaning no upstream new releases are going to be included into testing before lenny is released. Lenny will ship with MySQL 5.0.51a, while 5.0.67 (or a newer version if that will be the case) will be […]
Category Archives: Mysql
Code Colorizing MySQL
An example of code colorizing MySQL table creation.
This example shows creation of a simple contact list, or client list.
1
2
3
4
5
6
7
8
9
CREATE TABLE IF NOT EXISTS `clients` (
`id` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
`email_address` VARCHAR(72) character SET ASCII NOT NULL,
`firstname` VARCHAR(16) character SET utf8 NOT NULL,
`lastname` VARCHAR(20) character SET utf8 NOT NULL,
`date_added` DATETIME NOT […]
A PHP script for testing a MySQL database connection
A simple page for testing the connection to a MySQL database. The PHP script will test the server address, username and password. If the database field is left empty, it will return a list of available databases. Testing a specific database is optional, but if a database name is supplied, it will […]
Importing from Huge CSV Files to MySQL Database and more…
The scenario: I am given a huge CSV File dumped thru FTP from some big JDE-ish system everyday. The CSV File is about 15MB or so. The file has around 60,000 lines in it.
What I needed to do is to update a “main” transaction table. Which means I have to lookup each line […]
Development Web Servers: Moving From VertrigoServ To WampServer
I’ve waited far too long for VertrigoServ developers to come up with a stable Windows Vista version of their popular web server software. It is because their current version as of this writing (version 2.21) causes random blue screen of the death on my Windows Vista system, and after doing some search online, this […]
10 important MySQL variables that you should keep an eye on
A few months ago, I would have never read these kinds of posts. But after doing a project that had a huge MySQL database, I am glad that I have found this post.
Regardless of whether you’re running a single MySQL server or a cluster of multiple servers, one thing you are always interested in is […]
Calling all creative types: I need a slogan
As some of you may know, MySQLTuner is one of my favorite projects. It’s approaching the 1.0 release and I feel like celebrating. I thought about putting together some T-shirts (because as a nerd, I enjoy the occasional techy T-shirt), but I can’t come up with a good slogan.
I’ve heard of some pretty […]
Change password using phpMyAdmin
How to change password using phpMyAdmin.
If you can’t access your WordPress administration panel or having password problem, try change your password using phpMyAdmin.
1. Login to your web hosting administration control panel.
2. Click on MySQL administration.
3. Click on phpMyAdmin
4. Click on the wp_user on your database
5. Click on the Pen icon or edit button. […]
Generating Random Sample Data
I found a very useful tool today - the Data Generator. It generates large volumes of random, custom data for use in testing software. The tool is a free download, and can generate data in the following formats:
HTML
Excel
XML
CSV
SQL
There is an online demo available that is limited to 200 results. Click here to find out more…
Delete comments using phpMyAdmin
How to delete comments using phpMyAdmin.
1. Login to your web hosting administration control panel.
2. Click on MySQL administration.
3. Click on phpMyAdmin.
4. Click on the wp_comments on your database
5. Delete the comment. Or you can Edit the comment from phpMyAdmin.
NOTICE: Administration panel design may look different from your hosting company web site. But […]