Category Archives: MySQL

Incremental Backup in MySQL

To get a consistent backup, do a LOCK TABLES on the relevant tables, followed by FLUSH TABLES for the tables. You need only a read lock; this allows other clients to continue to query the tables while you are making … Continue reading

Posted in MySQL | Tagged , , , , , , , , , , | Leave a comment

Open Source ILS: Installation Guide for Koha on Ubuntu 11.10 or Ubuntu 11.04 or Ubuntu 10.10 or Ubuntu 10.04 LTS with MySQL 5

According to Wikipedia.com, An integrated library system (ILS), also known as a library management system (LMS), is an enterprise resource planning system for a library, used to track items owned, orders made, bills paid, and patrons who have borrowed. An … Continue reading

Posted in How To..., MySQL, Ubuntu, What is? | Tagged , , , , , , , , , , , , | 17 Comments

MySQL-Executing SQL Statements from a .sql File

However, it is also possible to put your SQL statements in a file and then tell mysql to read its input from that file. If you are already running mysql, you can execute an SQL script file using the source … Continue reading

Posted in How To..., MySQL | Tagged , , , , , , , , , | Leave a comment