I recently gave a webinar to the LAOUC and NZOUG user groups on MySQL Idiosyncrasies that BITE.
For the benefit of many viewers that do not use English as a first language my slides include some additional information from my ODTUG Kaleidoscope presentation in June.
Thanks to Francisco Munoz Alvarez for organizing.
MySQL Idiosyncrasies That Bite 2010.07 View more presentations from Ronald Bradford.
MySQL Workbench is a great tool for developers to map out and
visualise databases. What many people know is that it’s also a
great way to make upgrading and writing upgrade scripts for your
components really painless too.
Let’s say you created a small component that became popular over
night. Tens of thousands of downloads from on the Joomla
Extensions Directory. So you get inspired and put some more work
into improving and bugfixing this component even more, and while
doing that you change and add on to the database schema.
Now you need to create and distribute an update script with the next version of your component, and MySQL Workbench makes creating this update script really easy. Here is what you need to do:
Install MySQL Workbench
I’ll not help you with this. Just go to the MySQL Workbench homepage and follow the instructions from there. …
[Read more]If you have not looked at my recent presentation that I presented at ODTUG Kaleidoscope 2010, then feel free to join me on Tuesday, July 27, 2010 6:00 PM – 7:00 PM EDT tomorrow at 5pm EDT when I will giving a webinar on this talk. You can register online at https://www1.gotomeeting.com/register/730452824
The IOUG Online Education Series: Get Real with Upgrades will include next week 3 different MySQL webinars. These are:
Each speaker will be covering different areas and reasons for considering and implementing a successful MySQL Upgrade.
A company blog can be easily configured in under 10 minutes using Wordpress, a popular open source LAMP product that runs a reported 12+ million blogs including those found at CNN, NY Times, Wall Street Journal (WSJ), ZDNet, MTV, People Magazine, Playstation and eBay.
A company blog is a great way for the dissemination of information to your user base as well as enabling a means of user feedback via comments.
The following steps show you how to download, configure and get your Wordpress blog operational.
Software Pre-Requisites
[Read more]If you wonder why there hasn't been an update from me for quite a while — I just returned from two months of paternal leave, in which I actually managed to stay away from the PC most of the time. In the meanwhile, I've officially become an Oracle employee and there is a lot of administrative things to take care of... But it feels good to be back!
During my absence, Giuseppe and Felix kicked off the Call for Papers for this year's European OpenSQL Camp, which will again take place in parallel to FrOSCon in St. Augustin (Germany) on August 21st/22nd. We've received a number of …
[Read more]After successfully Installing MySQL, let us take a look at an operational MySQL instance on your Oracle Enterprise Linux server.
User Management
By default there will be a new mysql user and group created. This user is used to run the mysqld process is generally not used for any other purpose.
$ grep mysql /etc/{passwd,shadow,group}
/etc/passwd:mysql:x:27:27:MySQL Server:/var/lib/mysql:/bin/bash
/etc/shadow:mysql:!!:14796::::::
/etc/group:mysql:x:27:
Binaries
MySQL binaries are found in /usr/bin.
$ ls -l /usr/bin/mysql* -rwxr-xr-x 1 root root 314568 Feb 16 17:45 /usr/bin/mysql -rwxr-xr-x 1 root root 110776 Feb 16 14:39 /usr/bin/mysqlaccess -rwxr-xr-x 1 root root 35144 Feb 16 17:45 /usr/bin/mysqladmin -rwxr-xr-x 1 root root 112944 Feb 16 …[Read more]
Back in 2006 I was a member of the standards and guidelines
workgroup in Joomla, and during my involvement there I produced
the Joomla 1.5 database schema as a DB Designer
EER diagram, so people could view the database in a visual way. I
recently also set up the Joomla 1.6 database schema, this time using
MySQL Workbench which is a better tool for the job, and also GPL
and available on multiple platforms. During my work with setting
up the 1.6 schema, I came across lots of oddities and lacks of
normalization, and a severe lack of naming conventions and
guidelines became obvious.
Improvement suggestions
I have listed a few of these below, and please add comments to this post if you find some of your own or you disagree with me, and …
[Read more]After successfully installing MySQL on Oracle Enterprise Linux installing a LAMP (Linux/Apache/MySQL/PHP) stack can also be performed with a single command:
$ yum install -y httpd php php-mysql # Start the Apache Httpd Process $ /etc/init.d/httpd start
To test and confirm Apache Httpd and PHP, we can use the CLI browser lynx:
$ yum install -y lynx $ echo "<? phpinfo() ?>" > /var/www/html/phpinfo.php $ lynx http://localhost/phpinfo.php
If successful, you will find a web page that contains the following.
phpinfo() (p1 of 31) PHP Logo PHP Version 5.1.6 System Linux localhost.localdomain 2.6.18-164.el5 #1 SMP Thu Sep 3 04:15:13 EDT 2009 x86_64 Build Date Feb 11 2010 19:07:36 Configure …[Read more]
As some might remember I made a visual
representation of the Joomla 1.5 database schema back in 2006. I
have now set up an EER representation of the Joomla 1.6 database
schema too, that you can download for free. This schema was made
after the 1.6 beta 2 release, and it was built using MySQL Workbench, which
is both GPL and available as a free download for multiple
platforms.
First of all: If you find any errors in this schema, make sure
you leave a comment for me at the bottom. Because of the lack of
conventions for naming primary key columns, I am left to do a lot
of guesswork here when drawing up table relations, so there may
be errors. Pretty much the only table …
