If you’ve decided to use MySQL database for your enterprise application, you should wisely choose the MySQL storage engine type that will be appropriate for your situation. Depending on the situation, a particular storage engine can be a best fit or worst fit. Once you understand the differences between all MySQL storage engines, it will [...]
MySQL
In certain situations it’s a good option to use Nodejs with MySQL instead of PHP or any other server-side language. By using Nodejs you can get the advantage of its asynchronous behaviour, which in certain case may increase the performance, and you may not need to migrate an existing MySQL database to some other NoSQL [...]
Most of you are already familiar with SQL database, and have a good knowledge on either MySQL, Oracle, or other SQL databases. In the last several years, NoSQL database is getting widely adopted to solve various business problems. It is helpful to understand the difference between SQL and NoSQL database, and some of available NoSQL [...]
Q: How do I connect to a MySQL database from a perl program? I like to connect to an existing mysql database and select records from a particular table. Can you explain with a simple working example? A: You should use perl DBI module to connect to a MySQL database as explained below. If you [...]
If you are using MySQL database, it is essential that you become comfortable with mysql command line. In this tutorial we’ll explain how to use the MySQL select command with several practical examples. 1. Basic Select command Example First, to connect to MySQL command line, do the following from your operating system prompt. # mysql [...]
When your mysql table gets corrupted, use mysqlcheck command to repair it. Mysqlcheck command checks, repairs, optimizes and analyzes the tables. 1. Check a Specific Table in a Database If your application gives an error message saying that a specific table is corrupted, execute the mysqlcheck command to check that one table. The following example [...]
This MySQL jumpstart guide will get you running quickly on the basics. This explains how to install MySQL, create a sample database, create a table, insert records into the table, and select records from the table. 1. Install and Configure MySQL Go to the MySQL download page, and select your appropriate platform to download the [...]
To run various open source applications you might have to install Apache, MySQL, PHP, and Perl (or some combination of these). For those who have difficulties installing and configuring these separately, XAMPP might be helpful. XAMPP is Apache distribution that contains MySQL, PHP and Perl. You really don’t need to worry about configuring MySQL, PHP, [...]
My name is Ramesh Natarajan. I will be posting instruction guides, how-to, troubleshooting tips and tricks on Linux, database, hardware, security and web. My focus is to write articles that will either teach you or help you resolve a problem. Read more about