• Skip to main content
  • Skip to primary sidebar

DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

How to List MySQL Databases Using SHOW DATABASES

June 14, 2014 by Andy Hayes Leave a Comment

mysql show databases

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

June 11, 2014 by Andy Hayes 3 Comments

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

June 10, 2014 by Andy Hayes 2 Comments

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

January 27, 2014 by Andy Hayes Leave a Comment

Get Row Counts MySQL 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

January 26, 2014 by Andy Hayes 4 Comments

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

« Previous Page
Next Page »

Primary Sidebar

Categories

  • All Articles (84)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (21)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to shrink tempdb
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to fix “conversion failed when converting date and/or time from character string”

Recent Posts

  • How to fix “conversion failed when converting date and/or time from character string”
  • Using SQL GROUPING SETS for Multiple GROUP BY Queries in a Single Query
  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial

Search

Connect

  • Twitter
  • Facebook
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright ©