Data integrity: ------------------- Data integrity refers to
maintaining and assuring the accuracy and consistency of data
over its entire life-cycle. Every organization whether it's small
or large want to make sure their data is consistent and error
free. Data might move to other media/ different storage system
for performance, speed, scalability or any other business
reasons. So we want to make sure data is not corrupt while
migration/movement. Data integrity is a policy which enterprise
can enforce to be confident about their own data.
The overall intent of any data integrity technique is to ensure
data is recorded exactly as intended and upon retrieval
later, ensure data is the same as it was when originally
recorded.
Objective: --------------- User should be able to verify data
integrity of Innodb data files of a taken backup. Because during
backup MEB performs integrity check to ensure consistency of data
which MEB …
Monday 31 March 2014 proved to be a big day for MySQL with 5 announcements of products getting new releases: the next milestone release MySQL Server 5.7.4, MySQL Workbench 6.1 going GA and Connector/J 5.1.30 and MySQL Utilities 1.4.2 RC which include MySQL Fabric. That’s 4, the fifth being Connector/Python.
Connector/Python v1.2.1 has been released as Release Candidate. Check out the …
[Read more]In previous posts we have talked about importing data from MySQL to Excel, exporting data from Excel to a new or to a existing MySQL table (via the Export Data or Append Data operations) which are common tasks to be performed against MySQL tables. In this post we will talk about possibly the coolest feature in MySQL for Excel which is the Edit Data operation which allows the retrieval of a MySQL table's data to an Excel worksheet so the data can be edited, deleted or inserted in new rows and those changes saved back to the MySQL database in a friendly and intuitive way, and more importantly, without the need of writing SQL queries making it accessible to any kind of user.
You will learn in this guide how to do it and all the details about the Edit Data feature in MySQL for Excel.
March 28, 2014 By Severalnines
Percona Live MySQL Conference & Expo - March 31st to April 4th
The Severalnines Team Will Be Onsite at Booth 418 - Come Say Hello!
If you’re still thinking about whether or not you should be attending the Percona Live MySQL Conference & Expo that starts on Monday 31st of March, here are 9 reasons (we are Severalnines after all) on why we’ll be there. May these help you positively in your decision making ;-)
1. The 2014 edition showcases the most promising program yet
Sounds like a cliché-reason to be listed here, but this year’s program is in fact quite diversified in its …
[Read more]The new operation 'Copy-back-and-apply-log' introduced in MySQL Enterprise Backup 3.9.0 helps in faster restoration and helps in reducing the amount of space involved in restoring the backup contained in an image, because of elimination of the intermediate step of extraction of image contents.
The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1.
MySQL for Excel 1.2.1 is a maintenance release for 1.2.x containing a handful of bug fixes and the following minor features:
- When MySQL Workbench is not installed, MySQL connections are now automatically created for discovered MySQL services. If MySQL Workbench is later installed, these connections are not migrated over to MySQL Workbench as MySQL Workbench also creates connections for discovered MySQL services.
You can download MySQL for Excel 1.2.1 from our official Downloads page at http://dev.mysql.com/downloads/windows/excel as a standalone MSI, and it will be available shortly in the MySQL Installer for Windows that can be downloaded from …
[Read more]I will be speaking about MySQL at the Bulgarian Oracle Users Group's Spring Conference.
In furthering my mission to increase the MySQL knowledge among my countrymen I will try to give the grand tour of all the modern MySQL administrative and development tools that the MySQL team provides.
This will be the 3d BGOUG conference I'm speaking to. And I expect no less than the stellar organization and the great audience that I had the privilege to interact with during the previous 2 conferences.
We had a lot of fun too ! Parties from the last 2 conferences are …
[Read more]
Today we're going to talk about one of the main features in MySQL
for Excel. There may be times when you have a MySQL Database
table that you want to add new rows to. In this blog post we're
going to show you how you can do that from within Excel directly
easily using the Append Excel Data to Table feature.
Always remember MySQL for Excel can be downloaded and installed
directly for free, from our MySQL
Installer downloads page.
Your feedback is very important for us, please drop us a message and follow our social networks:
[Read more]Continuent, a leading provider of database clustering and replication software has five (5) new positions open:
Build/Test Engineer Senior Database Availability and Clustering Engineer Senior Database Replication Engineer Data Replication Sales Engineer Clustering and Replication Test Development Engineer
If you want to get in on the ground floor of a growing company in a challenging field
The next MySQL User Group NL meetup is this Tuesday at the Oracle
office in Utrecht.
For more info go to the Event page @ Meetup.com