SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The World of MySQL

I had two different people ping me on the same day with MySQL questions. One was a former co-worker, asking for some query help, and one was from the Boy Scouts of America, also asking for some query help for a few reports. Strange that both requests came on the same day.

I didn’t have a MySQL install on the latest incarnation of my desktop or laptop. I did pop MySQL Workbench on a laptop last year, playing with Azure deployments, but no server. I deployed a MySQL instance on an Azure VM, but I had trouble connecting. Either the Ubuntu instance didn’t have the MySQL ports open (should have in the template), or I typed the password wrong. Either way, I just decided to delete that resource group (I love resource groups) and download the MariaDB server.

It’s a standard download from Mariadb.org and it’s not too large. In fact, it took longer to download than install.  The install was a standard msi installer, and ran in a minute or two.

2017-07-26 19_56_54-MariaDB 10.2 (x64) Setup

From there, I started up MySQL Workbench, which I’d downloaded and installed. I entered my user and password, using the default ports for the server.

2017-07-26 19_57_13-Setup New Connection

And things worked, as they should in 2017.

2017-07-26 19_57_29-MySQL Workbench

From there, I selected the data import and chose the file I’d been sent. It was (supposedly) a MariaDB dump, but listed as a .sql file. Looking through it, it has SQL and data inserts, so I ran it with the Data Import.

2017-07-26 19_59_06-MySQL Workbench

This ran for less than a minute and things were complete.

2017-07-26 20_03_19-MySQL Workbench

And sure enough, some MySQL syntax (googled to remember) works.

2017-07-26 20_04_53-MySQL Workbench

Now to debug some queries for a friend.


Filed under: Blog Tagged: mysql, syndicated

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Comments

Leave a comment on the original post [voiceofthedba.com, opens in a new window]

Loading comments...