Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 219 Next 30 Older Entries

Displaying posts with tag: Windows (reset)

MyQuery 3.5.0 available
+2 Vote Up -1Vote Down
I just made MyQuery 3.5.0 available for download from sourceforge. If you do not know about this program, this is my Windows based MySQL Query editor and database monitor program. And yes, it is Windows only.

It was a long time since I updated MyQuery, but I have been been at it for a long time, but slowly as I haven't had the bandwidth, and I have collected a few things I wanted in this release, but of all those things, many has to wait for now, as decided to add a major feature which did require a fair bit of coding and testing: autocomplete. When editing SQL statements, autocomplete for names of tables, columns etc is really useful, but it is not as easy as it sounds. What makes this a bit complicated are things like the default database (which I need to figure out for

  [Read more...]
MySQL Connector/Net 6.6.4 RC1 has been released
Employee +0 Vote Up -0Vote Down

MySQL Connector/Net 6.6.4, a new version of the all-managed .NET driver for MySQL has been released.  This is the Release Candidate intended to introduce users to the new features in the release.
MySQL Connector/Net 6.6.3 Beta 2 has been released
Employee +1 Vote Up -0Vote Down

MySQL Connector/Net 6.6.3, a new version of the all-managed .NET driver for MySQL has been released.  This is the second of two beta releases intended to introduce users to the new features in the release.

MySQL Connector/Net 6.6.2 has been released
Employee +2 Vote Up -0Vote Down
The 6.6 has reached Beta level major features are Stored routine debugger, Entity Framework 4.3 Migrations support, Authentication Plugin & Visual Studio 2012 support.
Meet The MySQL Experts Podcast: SQL Server Migration Tool
Employee_Team +3 Vote Up -0Vote Down

We recently released a new migration tool for Microsoft SQL Server to MySQL, along with additional tools and features improving the MySQL user experience on Windows (http://www.mysql.com/why-mysql/windows/).

In the latest episode of our "Meet The MySQL Experts" podcast, Alfredo Kojima, Senior Software Development Manager, talks to us about the new migration tool.

Enjoy the podcast!

To learn more about SQL Server to MySQL migrations, MySQL on Windows and numerous other MySQL topics, register for

  [Read more...]
MySQL Connector/Net 6.6.1 Alpha 2 has been released
Employee +2 Vote Up -0Vote Down
 MySQL Connector/Net 6.6.1, a new version of the all-managed .NET driver for MySQL has been released.  This is the second of two alpha releases intended to introduce users to the new features in the release.  This release is not feature complete and there are limitations but it should be stable enough for users to understand the new features and how we expect them to work.  As is the case with all non-GA releases, it should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at

  [Read more...]
How-To: Guide to Database Migration from Microsoft SQL Server using MySQL Workbench
Employee_Team +3 Vote Up -0Vote Down

MySQL Workbench 5.2.41 introduces a new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. In this initial version, migrations from Microsoft SQL Server are supported, but it should also be possible to migrate from most ODBC capable RDBMS as well, using its generic RDBMS support. Additionally, you can use it to perform MySQL to MySQL database copies, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL.

So let’s get our hands dirty and run through the Migration Wizard in order to migrate a Microsoft SQL Server database to MySQL. In the rest of this post I assume that you have:

  • A running SQL Server instance in which you have proper access to the database you want to migrate.
  [Read more...]
MySQL Connector/Net 6.6.0 Alpha has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.6.0, a new version of the all-managed .NET driver for MySQL has been released.  This is the first of two alpha releases intended to introduce users to the new features in the release.  This release is not feature complete and there are significant limitations but it should be stable enough for users to understand the new features and how we expect them to work.  As is the case with all non-GA releases, it should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this

  [Read more...]
Living With Linux
+0 Vote Up -0Vote Down

I learned how to use a computer on DOS and Windows. My first programming projects were written in QBASIC and my first Web applications were written in VB using ASP on Windows 2000. The first job where I made decent money was developing a SQL Server-based application. I bought my first car, an engagement ring, and a honeymoon with money from making software on Windows. Needless to say, I found a lot of intellectual and financial fulfillment from Windows over the years.

That first real job also allowed me flexibility in what technology I could employ, and I helped implement a features using Redis on top of Ubuntu. This was a fun time, because my company basically paid me to study a new technology and to gain experience using it. On my own, I began to use Linux and to embrace open-source ideas, one of which is that the consumer

  [Read more...]
Using Windows profiler with mysqld
+0 Vote Up -0Vote Down

My colleague who is a Windows guru taught me how to do very basic things with the Windows profiler. While this stuff is primitive, the sad truth is that many people don’t know even this little about Windows, me including. I’ll keep the hints here, and hopefully will learn more with time.

  • Use RelWithDebInfo builds, Debug build will screw the picture, it will tell you _db_enter is the most expensive function;
  • Start mysqld;
  • Use x64 VS command prompt:

Start => All Programs => MS Visual Studio 2010 => Visual Studio Tools => Visual Studio x64 Win64 command prompt

  • Set _NT_SYMBOL_PATH to the package bin directory, so mysqld.pdb can be found, and start the IDE:

set _NT_SYMBOL_PATH=... && devenv.exe

  • In the VS command prompt, run
  [Read more...]
ZFS: could have been the future of UNIX Filesystems
+5 Vote Up -0Vote Down

There was a point a few years ago where Sun could have had the next generation UNIX filesystem. It was in Solaris (and people were excited), there was a port to MacOS X (that was quite exciting for people) and there was a couple of ways to run it on linux (and people were excited). So… instead of the fractured landscape of ext3, HFS+ and (the various variations of) UFS we could have had one file system that was common between all of the commonly used UNIX-like variants. Think of being able to use a file system on a removable drive that isn’t FAT and being able to take it from machine to machine (well… Windows would be a problem, but it always is).

There was some really great work done in OpenSolaris with integration between the

  [Read more...]
MySQL Connector/Net 6.4.5 has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.4.5 has been released!  This is an update to our 6.4 driver and brings several bug fixes.  It is appropriate for production use with MySQL server versions 5.0-5.5

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

You can read about the changes in this version at http://dev.mysql.com/doc/refman/5.5/en/connector-net-news-6-4-5.html

You can find our team blog at





  [Read more...]
Mixed signals in IT’s great war over IP
+0 Vote Up -1Vote Down

Recent news that Microsoft and Barnes & Noble agreed to partner on the Nook e-reader line rather than keep fighting over intellectual property suggests the prospect of more settlement and fewer IP suits in the industry. However, the deal further obscures the blurry IP and patent landscape currently impacting both enterprise IT and consumer technology.

It is good to see settlement — something I’ve been calling for, while also warning against patent and IP aggression. However, this settlment comes from the one conflict in this ongoing war that was actually shedding some light on the matter, rather than further complicating it.

See the full article at TechNewsWorld.

MySQL Connector/Net 6.3.9 has been released
Employee +1 Vote Up -0Vote Down
MySQL Connector/Net 6.3.9, the latest maintenance release of our 6.3 version series, has been released.  Connector/Net is our all-managed .NET driver for MySQL.  This release will be the last release of our 6.3.x series and contains more than 25 fixes from the 6.3.8 base.  Users looking for additional fixes or features should upgrade to our most recent version.  You can see the list of changes and read more about the connector at http://dev.mysql.com/doc/refman/5.5/en/connector-net.html

Version 6.3.9 is appropriate for use with versions of MySQL 5.0-5.5.

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/6.3.html#downloads and



  [Read more...]
Tell us what you want in 6.6
Employee +0 Vote Up -0Vote Down

Now that we have finished 6.5 it's time to really start gearing up for 6.6.  We have  many great feature ideas but we want to hear from you.  To help with that, we're running a poll on the website where you can vote on the features you would like to see in the next version of the best MySQL ADO.Net Connector on the planet.  You can find the poll at http://dev.mysql.com and scrolling near the bottom of the page.  

Thanks for your time and please go vote.  

Connector/Net 6.3 Support has ended
Employee +0 Vote Up -0Vote Down

We recently released Connector/Net 6.5 as GA.  Our policy is that we actively support the last 2 GA versions of the Connector so we are dropping support for Connector/Net 6.3.  Any users who are actively using 6.3 are encouraged to upgrade to the latest version.  You can find the formal announcement at http://mysql.com/support/eol-notice.html

Screencast: Installing MariaDB on Windows
+3 Vote Up -0Vote Down

A screencast demonstrating the MariaDB Windows installer.

(I recommend watching it in full screen 720p, so you can see the details.)

Some links:

Acknowledgments:

A big thanks to Vladislav Vaintroub, MariaDB’s Windows guru, and to Rasmus Johansson for help with the screencast.

Lower Your Database TCO on Windows by up to 96%
Employee_Team +0 Vote Up -0Vote Down

If you are a Windows user concerned about the new licensing and pricing of SQL Server 2012, we encourage you to try the MySQL TCO Calculator! (http://www.mysql.com/tcosavings/)

You’ll discover how you can reduce your database TCO by up to 96% with MySQL Enterprise Edition vs SQL Server 2012 Enterprise Edition*.

While MySQL is famously known as the "M" of the popular LAMP stack, Microsoft Windows consistently ranks as the #1 development platform for MySQL users in our surveys. Indeed, MySQL on Windows enables you to:

  • Achieve Huge Database TCO Savings, while relying on World-Class 24/7 technical support from Oracle.
  • Quickly
  [Read more...]
MySQL Connector/Net 6.5.4 GA has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.5.4 has gone GA!  This is the first production-ready version of our new 6.5 connector and we are very excited about it.  Connector/Net is an all-managed .NET driver for MySQL and is the best solution for your MySQL and .NET data access needs. 

Version 6.5.4 includes full support for MySQL server versions 5.0-5.6 and includes some exciting new features such as:
  • Much improved partial trust support.  Hosting providers can now configure their trust policies exactly the way they are configured for SQL Server and your application can run without trouble in partial/medium trust.
  • Auto-completion support in the Visual Studio editor.  We have integrated a brand new parser into our Visual Studio work and we are jut getting started showing it's benefits. Open up a VS editor start typing



  [Read more...]
MySQL Connector/Net 6.5.3 RC has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.5.3, a new version of the all-managed .NET driver for MySQL has been released.  This is the second of our two Release Candidate (RC) releases.  As is the case with all non-GA releases, it should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The 6.5 release of MySQL Connector/Net brings new features such as
  • Exception and command injector





  [Read more...]
Introducing the rest of the team!
Employee +0 Vote Up -0Vote Down

Some time ago I wrote a post introducing two members of my team, Fernando and Gabriella.  I was focused at the time on introducing relatively new members to the team and, in my error, I failed to introduce one member who has been with me for quite some time.  We have also since added 3 more individuals to our growing team.  This team is called the Windows Experience Group and we are doing some really exciting work.  You've already met Fernando and Gabriella. Here is the rest of the team.

">

Iggy Galarza leads our MySQL Installer team.

Iggy has been with MySQL since 2006 and has been an integral part in many initiatives ranging from the MySQL installer to solving server

  [Read more...]
Recommendation: Vagrant and Veewee
+0 Vote Up -0Vote Down

Note: I’ve decided not to use Veewee due to silly compatibility issues for now.

Quoting from Vagrant’s web site:

Vagrant is a tool for building and distributing virtualized development environments. By providing automated creation and provisioning of virtual machines using Oracle’s VirtualBox, Vagrant provides the tools to create and configure lightweight, reproducible, and portable virtual environments.

A complementary technology called Veewee makes building VirtualBox VMs easier by automating away a lot of manual steps. Marius Ducea has a great blog post on how to use it.

My observations:
1. According to

  [Read more...]
MySQL Connector/Net 6.5.2 RC has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.5.2, a new version of the all-managed .NET driver for MySQL has been released.  This is the first of our two Release Candidate (RC) releases.  As is the case with all non-GA releases, it should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The 6.5 release of MySQL Connector/Net brings new features such as
  • Exception and command injector support





  [Read more...]
MySQL Connector/Net 6.5.1 beta has been released
Employee +1 Vote Up -0Vote Down
MySQL Connector/Net 6.5.1, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

This new versions brings new features such as
  • Exception and command injector support





  [Read more...]
MySQL Connector/Net 6.5.1 beta has been released
Employee +0 Vote Up -0Vote Down
MySQL Connector/Net 6.5.1, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

This new versions brings new features such as
  • Exception and command injector support





  [Read more...]
Query-Digest on Windows
+0 Vote Up -0Vote Down
The best way to run pt-query-digest is by making absolutely sure it is not running on any server that is even slightly important to production.

I recently had a case where pt-query-digest took up all the memory and swap on a (linux) development server. I think the reason was that the slow log had blob data in it.
Even though it wasn't a production server, it managed to upset some people.


So I:
  • Installed strawberry perl on my windows computer
  • Downloaded the gzip'd slow log file (using WinSCP)
  • Unzip'd it
  • Saved percon.com/get/pt-query-digest to a .pl







  •   [Read more...]
    2012 to be year of Linux domination
    +0 Vote Up -1Vote Down

    Previously, I’ve called out years for non-desktop Linux in 2008, Linux in both the low and high-ends of the market in 2009, ‘hidden’ Linux in 2010 and last year, cloud computing in 2011. For 2012, I see continued growth, prevalence, innovation and impact from Linux, thus leading to a 2012 that is dominated by Linux.

    I expect to see nothing but continued strength for Linux and

      [Read more...]
    Running Connector/Net 6.5 inside Medium-Trust Level
    Employee +1 Vote Up -1Vote Down

    As you probably know, there were some problems using our connector in medium-trust level scenarios. Most hosting services provide MySQL access.  Most of these hosting providers run their .NET web apps using medium trust.  Prior to 6.5, our connector required the hosting provider to either run the application in full trust or to enable broad privileges like SocketPermission globally.  Many hosting providers are unwilling to do that.  So fully enabling our provider to run in a partial trust scenario was a strongly requested feature. The request was a very simple task: enable Connector/Net to work correctly in a medium-trust level environment when the library is installed in the GAC.

    The implementation consisted of including the necessary security imperative asserts so the CLR allows our code to perform the operations where it needs

      [Read more...]
    Running Connector/Net 6.5 inside Medium-Trust Level
    Employee +0 Vote Up -0Vote Down
    Connector/Net is now enabled to work inside a Medium/Partial Trust security level. Just download the new 6.5 version to use with your .Net application and you should be able to see it working just fine.
    Using MySqlClientPermission Class on Connector/Net 6.5 to restrict data access
    Employee +1 Vote Up -0Vote Down

    We have a new feature as part of the 6.5 release. There is a new class that you can use to restrict access to specific connection strings that you want to use in all the connections in applications that use MySQL databases.

    The following example shows how you can use the MySQLClientPermission class to restrict access to a specific server name and a database, while allowing any value for the User Id and Password within the connection string:

    MySqlClientPermission permission = new MySqlClientPermission(PermissionState.None);

    permission.Add("server=localhost;database=test;", " user id=; password=;",

    KeyRestrictionBehavior.AllowOnly);

    permission.PermitOnly();

    MySqlConnection myconn = new MySqlConnection();

    myconn.ConnectionString =

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 219 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.