Want a list of MySQL databases? In this quick guide, I demonstrate how to show a list of databases in MySQL using SHOW DATABASES. First, login as user root to your MySQL instance. mysql -uroot -pYourPassword Now that you are logged in, you simply need to run the SHOW DATABASES command. SHOW DATABASES; Produces the following list. +--------------------+ | Database … [Read more...] about How to List MySQL Databases Using SHOW DATABASES
Using SELECT TOP WITH TIES in SQL Server
I've used SELECT TOP (x) many, many times. After learning how to use SELECT, it's something I quickly learned to use and remains something which I continue to use often. I've also used TOP (x) with UPDATE and DELETE statements to limit the number of rows updated or deleted in a statement. I've never had to use SELECT TOP WITH TIES though. I've glanced through the … [Read more...] about Using SELECT TOP WITH TIES in SQL Server
How to Resize MySQL Innodb Log Files Without Errors
Upon installing MySQL, the default innodb log file size is 5MB. This might be fine for a lot of servers but should you want to resize it, it is not simply a case of changing innodb_log_file_size to the new size and restarting MySQL. MySQL will not start and produce error log output similar to the following: 140610 20:09:14 InnoDB: The InnoDB memory heap is disabled 140610 2 … [Read more...] about How to Resize MySQL Innodb Log Files Without Errors
Comparing Ways to Get Table Row Counts in MySQL and SQL Server
I work in a mixed database server environment where applications are either powered by SQL Server, MySQL and more recently MongoDB. I started my career as a DBA working with SQL Server back in around 2003. In the last 5-6 years I have also been working with MySQL and more recently MongoDB which came into our organization last year. In my time working with SQL Server it has … [Read more...] about Comparing Ways to Get Table Row Counts in MySQL and SQL Server
How to Install MySQL 5.5 on Ubuntu Server 12.04 LTS
For this how to, I am going to document how to install MySQL on an installation of Ubuntu 12.04 LTS Installing it is a very straight forward and quick process and I prefer to use the terminal. If you are running a GUI, you can also install it through the Ubuntu sofware centre. Typically available with the Ubuntu desktop version. If you are running the desktop version of … [Read more...] about How to Install MySQL 5.5 on Ubuntu Server 12.04 LTS