My SQL Server
MySQL Server.
Linux - MySQL Server Downloads.
http://mysql.mirrors.hoobly.com/Downloads/
The complete installation of mysql on a linux server requires the following packages.
MySQL-server -- the actual mysql database engine MySQL-client -- the interactive character based mysql client MySQL-shared -- the shared library that mysql needs MySQL-shared-compact -- for backward compatibility MySQL-embedded -- the embedded mysql library MySQL-devel -- MySQL-bench -- requires perl and DBD::mysql module MySQL-Max -- includes Innodb tables
The Max package is required if InnoDB or BDB table data file types are to be used in addition to the standard MyISAM table data file type
Please remember to set a password for the MYSQL root USER!
/usr/bin/mysqladmin -u root password 'new password' /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new password'
mysql_install_db
On Linux, the grant tables are set up by the mysql_install_db program. Typically, mysql_install_db needs to be run only the first time
[root@hcl html]# which mysql
/usr/bin/mysql
[root@hcl html]# which mysql_install_db
/usr/bin/mysql_install_db
Start the MySQL server:
mysqld_safe --user=mysql &
Use mysqladmin to verify that the server is running.
mysqladmin version
mysqladmin variables
Shut down the server:
mysqladmin -u root shutdown
Shut down the server:
mysqld_safe --user=mysql --log &
[root@hcl ~]# mysqlshow
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+
Retrieve information from the server.
[root@hcl ~]# mysqlshow mysql
Database: mysql
+---------------------------+
| Tables |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
Securing the MySQL
To use SET PASSWORD on Unix, do this:
# mysql -u root
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR ''@'host_name' = PASSWORD('newpwd');
mysql> use mysql;
mysql> SELECT Host, User FROM mysql.user;
+---------------+------+
| Host | User |
+---------------+------+
| hcl.armia.com | |
| hcl.armia.com | root |
| localhost | |
| localhost | root |
+---------------+------+
4 rows in set (0.05 sec)
OR
mysql> describe user;
mysql> select host,User from user;
+---------------+------+
| host | User |
+---------------+------+
| hcl.armia.com | |
| hcl.armia.com | root |
| localhost | |
| localhost | root |
+---------------+------+
4 rows in set (0.00 sec)
MySQL Server has built-in support for SQL statements to check, optimize, and repair tables. These statements are available from the command line through the mysqlcheck client. MySQL also includes myisamchk, a very fast command-line utility for performing these operations on MyISAM tables.
Commands
mysql mysqladmin mysqlcheck mysqldump mysql_find_rows mysqlshow
mysql_waitpid mysqlaccess mysqlbinlog mysql_config
mysqlimport mysql_tableinfo mysqldumpslow
myisamchk --help
Description, check and repair of MyISAM tables.
-r, --recover Can fix almost anything except unique keys that aren't unique. Used without options all tables on the command will be checked for errors
Usage: myisamchk [OPTIONS] tables[.MYI]
mysqlcheck --help
This program can be used to CHECK (-c,-m,-C), REPAIR (-r), ANALYZE (-a) or OPTIMIZE (-o) tables. Some of the options (like -e or -q) can be used at the same time.
The option -c will be used by default, if none was specified. You can change the default behavior by making a symbolic link, or copying this file somewhere with another name, the alternatives are:
mysqlrepair: The default option will be -r mysqlanalyze: The default option will be -a mysqloptimize: The default option will be -o
Usage: mysqlcheck [OPTIONS] database [tables]
OR mysqlcheck [OPTIONS] --databases DB1 [DB2 DB3...] OR mysqlcheck [OPTIONS] --all-databases
By default, MySQL creates MyISAM tables with an internal structure that allows a maximum size of about 4GB. You can check the maximum table size for a MyISAM table with the SHOW TABLE STATUS
MaxDB
MaxDB is a heavy-duty enterprise database. MaxDB is the new name of a database management system formerly called SAP DB. MaxDB runs as a client/server system. MySQL can run as a client/server system or as an embedded system.
MaxDB and MySQL are independent database management servers.
How can I backup a MySQL database?
mysqldump -u $mysqlusername -p$mysqlpassword $mysqldatabasename > backupdb.sql
Not that there is no space after the -p
mysqldump -u user -p --opt database > backup_dbfilename
EXAMPLES
The most normal use of mysqldump is probably for making a backup
of whole databases. See Mysql Manual section 21.2 Database Back-
ups.
mysqldump --opt database > backup-file.sql
You can read this back into MySQL with:
mysql database < backup-file.sql
or
mysql -e ’source /patch-to-backup/backup-file.sql’ database
However, it’s also very useful to populate another MySQL server
with information from a database:
mysqldump --opt database | mysql --host=remote-host -C database
It is possible to dump several databases with one command:
mysqldump --databases database1 [ database2 database3... ] >
my_databases.sql
If all the databases are wanted, one can use:
mysqldump --all-databases > all_databases.sql