Running Multiple MySQL Instances on One Machine In some cases, you might want to run multiple instances of MySQL on a single machine. You might want to test a new MySQL release while leaving an existing production setup undisturbed….
Backup and Recovery It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data…
10.1 The Error Log The error log contains information indicating when mysqld was started and stopped and also any critical errors that occur while the server is running. If mysqld notices a table that needs to be automatically checked or…
9.1 Server System Variables [client] [mysqld] [mysqldump] [myisamchk] [mysqlhotcopy] auto_increment_increment Controls the interval between successive column values. auto_increment_offset determines the starting point for the AUTO_INCREMENT column value. Autocommit log-error skip-networking init_connect A string to be executed by…
8.1 myisamchk ― MyISAM Table-Maintenance Utility The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables. You can also use the CHECK TABLE and REPAIR TABLE statements to check…
7.1 mysql ― The MySQL Command-Line Tool mysql is a simple SQL shell (with GNU readline capabilities). It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as…
6.1 Comparing Transaction and Nontransaction Engines Transaction-safe tables (TSTs) have several advantages over nontransaction-safe tables (NTSTs): They are safer. Even if MySQL crashes or you get hardware problems, the database will be in a consistency form. You can combine many…
We can create User Accounts in two ways. By using CREATE USER or GRANT statements. (Recommended Method) By manipulating the mysql grant tables with statements like INSERT and DELETE. Using CREATE USER and GRANT statements: Creating a User: By…
Installing MySQL from RPM Packages on Linux For non-RPM Linux distributions, you can install MySQL using a .tar.gz package. MySQL-server-VERSION.glibc23.i386.rpm The MySQL server. You need this unless you only want to connect to a MySQL server running on another…
MySQL is a database management system A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add,…