Should you migrate from MyISAM to Innodb?

Most frequent question asked by MyISAM users is, should they switch to innodb storage engine or continue working with MyISAM storage engine. Although both engines have their own pros and cons but Innodb is the best choice you can make for your database. Let's discuss why.

Commands to Analyze, Check, Optimize and Repair MySQL tables

There are some useful table maintenance commands that every MySQL user should aware about. These are the most basic and effective commands. You can use these commands to check the consistency of all the tables. If your table becomes corrupt then these commands are helpful in recovery of corrupt table. So let's discuss each command one by one.

MySQL back to basics: Commands for newbie users

Here is the list of most basic and useful commands for MySQL newbie user. These commands are used time and again.

Tips on securing MySQL database

Security of any database is very important and MySQL is no different. Here I am describing some basic security tips that every DBA should follow to protect MySQL database.

How to repair damaged MySQL database when everything else fails

Have your MySQL database got corrupted? Are you tired of trying every possible solution and nothing works or worse and you don’t have even updated backup of your database. Don’t stress! Your data is safe. You can try an amazing third party tool named Stellar Phoenix database repair for MySQL. It repairs damaged innodb and myisam tables in all possible cases of corruption. Using this tool you can repair damaged database created on both Windows and Linux OS.

MySQL keeps crashing!! What to do?

MySQL crashes due to various reasons like hardware problem, unexpected system shutdown, power failure and many more. Before things get out from the hand, you should try to find out the reason of MySQL crash and fix it on time. You can try below steps when MySQL crashes.

Tips to optimize MySQL query performance

The most common issue that bothers MySQL users is slow performance of database. There is nothing worst than having a slow database that takes forever to open. To optimize the overall performance of your database, you first need to optimize the queries. Because badly design queries not only degrade the performance of database but also consume more resources. So first try to find out the bad queries that can impact your database and then optimize them.

Fixing MySQL Database corruption

If you ask a DBA about his worst nightmare then most probably his answer would be “Database Corruption”. There is nothing worst than losing your years of hard earned data. In MySQL you still have the chances of getting your data back using its inbuilt utilities. This article can help you surely in recovery of your corrupt database.

Quick Tips on InnoDB Performance Tuning

Tuning of any database is required in order to optimize its performance. A well-tuned database performs faster and maximizes the use of system resources. If your database is not optimized, it will response poorly and eventually effect your business. Similarly if you are using MySQL for storing  your data then don't forget to optimize it. MySQL provides different storage engines and each storage engine has unique design and properties. So it is important to optimize each storage engine according to its design. I will discuss performance tuning tips for InnoDB.

Recover Data Even After Encountering Error Code 1030 in MySQL Database

InnoDB and MyISAM both are default storage engines of MySQL database management system. However, database administrators prefer InnoDB over MyISAM as InnoDB provides ACID compatible transaction environment, and facilitates features like crash recovery, rollback, and commit. In order to manage valuable data on database, InnoDB uses various libraries. Despite these useful features of InnoDB, there occur situations when this storage engine gets corrupt and causes inaccessibility of your stored data. You are required to opt for efficient measures to repair MySQL database and overcome such unexpected situations of data loss. As a real life example, you may encounter the below mentioned error message, when InnoDB gets corrupt:

“Uncategorized SQLException for SQL []; SQL state [HY000]; error code [1030]; Got error 134 from storage engine; nested exception is java.sql.SQLException: Got error 134 from storage engine”

How to Ward off Table Corruption Problems in MySQL

Database corruption is a problem that may be lurking around the corner and will only come to your notice once you hit the corrupt block. As any other database, corruption may hit your MySQL databases making millions of corporate data records inaccessible. Finding corruption in MySQL tables is painstaking. You may expect queries to stop working or showing inconsistent outcome. When you start experiencing such issues, you need to check your tables for consistency. In the event of MySQL database corruption, the below given errors may show up intermittently on your screen:

Migration Tool: A source RDBMS to MySQL

What is MySQL workbench migration tool?
As name suggest, it is a migration tool that converts a relational database to another relation database. For example you can easily migrate from Microsoft SQL server to MySQL with the help of this tool. It will automatically convert as much data as it can but sometimes you may require editing to automatically migrated data for complex cases. As per MySQL developer, this migration tool automatically migrates tables & its data only, for code objects such as stored procedures, triggers & views are not. It is successfully tested for SQL server 2000, 2005, 2008, and 2012.

Performing Crash Recovery and Media Recovery after Facing Corruption in InnoDB tables of MySQL Database

MySQL is known for its ease-of-use, performance, and scalability. The versions prior to MySQL 5.5 have MyISAM as their default database storage engine. In MySQL 5.5, the default settings have been changed as InnoDB becomes the default database storage engine. This change has brought a handful of significant improvements in the lives of database users and administrators. Some of the major benefits of using InnoDB tables include ACID transactions, Referential integrity, and Crash recovery.

A Simple Approach to MySQL Database Recovery Using Binary Backups

The InnoDB storage engine of MySQL has the capability to provide a transaction safe database. However, due to some unexpected power failures and internal system malfunctions, the risks of database crash or corruption increase. You may get the following error on your screen while accessing some of the pages of your website:

Reliable Utility to Resolve MySQL Error Code 144 and Recover Precious Data Back

The applications that are involved in on-line transactions or are accessed by huge number of users on a daily basis require databases at the back-end to store important data. The database linked at the back-end of an on-line application either works as a base storage of the data related to the transactions or stores the authorization, authentication, and accountability information of accounts for proxy server verification. For its good internal structure and fast counter response, MySQL is widely used in various on-line applications. At times MySQL database gets corrupt and all the data in it becomes completely inaccessible. For such situations, Stellar Data Recovery has developed an advanced MySQL repair utility, which is powerful enough to repair the corrupt database and recover your data back.

How to Check, analyze & repair MySQL database corruption by mysqlcheck

MySQL database corruption normally occurs due to hardware failure, out of space problem, login failure, power failure, and many more. A database administrator can check the level of corruption by mysqlcheck program. MySQLcheck is a table maintenance program offered by MySQL to check and repair MySQL table corruption. It performs several other operations apart from check & repair like; to analyze and optimize table. Table maintenance program (mysqlcheck) can be time consuming; especially for the large table because when you run this program on the database then it thoroughly check and analyze all the tables in the database and tries to repair all errors.

MySQL server (mysqld) Fails, How to fix it?

MySQL server is the main program that performs most of the activity in MySQL database installation, also known as mysqld. It has a set of system & status variables and also manages access control for data directory that contains data & tables. MySQL data directory has many other options, you can check all the available options in data directory by running below command.

Check & Repair Corrupt MySQL Database using myisamchk

MYISAMCHK is a table maintenance utility developed by MySQL. This utility works with MyISAM table that uses .MDI for index and .MYD for data. Database administrator can also use REPAIR Table & CHECK Table statements to repair and check corrupt MySQL database. It offers several options to check, repair and optimize corrupt MySQL database. The options are given below: 

What are the Importance & Use of MySQL database Backup?

Performing backup of MySQL database is the most important activity of any database administrator but most of database administrators just neglect this activity. It is like a nightmare situation for the administrators, if database gets corrupt and there is no any backup available to recover MySQL database. At this scenario, they will realize that they have done a blunder mistake. Backup helps to handle any type of corruption strike by virus, hardware failure and other. 

How to Restore MySQL database from Program files?

In this article, we will discuss about a scenario wherein a database administrator has tape backup of C drive only and production server had compromised by virus attack which was hosted in a third party hosting company. It is very frustrating for every database administrator if they have not schedule MySQL database export to a SQL backup file.