MySQL

this article starting at Slime Line the world . Description This article is reproduced in part from the Internet.MySQL replication (English for replication) is a multi-MySQL database master from the synchronous scheme, characterized by asynchronous

[ERROR]/usr/sbin/mysqld:the table ' cps_effect_confirm_log_1301 ' isToday to a database recovery data, is a 25G library, in the execution of half is, the occurrence of such an errorOne, view the disk space 'DF-DH see that the MySQL directory (not

The simplest way is to reconfigure the configuration file, and in the step of setting the password, tick allow remote connection . If not, you can try the following methods1, change the table method. It may be that your account is not allowed to log

1. Use the show statement to find out what database currently exists on the server:Mysql> SHOW DATABASES;+----------+| Database |+----------+| MySQL || Test |+----------+3 Rows in Set (0.00 sec)2. Create a database Abccsmysql> CREATE DATABASE

The following files are involved:1, login page login.jsp2, successful jump page success.jsp3, failed jump page fail.jsp4,servlet Processing Class Logintestservlet.java5, config file Web. xml---------------------------------------------look at the

A problem needing attention1. When the database field is a blob type, the setbinarystream (int,inputstream,int) method in PreparedStatement must be used;2. When the database field is longblob type, you must use the setbinarystream

Today suddenly found that we have many tables in the database, suffix named "Copy", is estimated to be a direct copy of the navicat caused, and then to those with the same suffix name of the table to delete, if a choice will be troublesome, the

1. mysql defaults to auto-commit, which is the autocommit mode, meaning that if a transaction is not explicitly opened, then each transaction is treated as a transaction to commit the operation.Show variables like ' autocommit ' to see the current

---restore content starts---error:2014 Commands out of sync; You can ' t run the This command nowI'm really drunk with this error number.Always tangled in why the stored procedure is executed, the commit operation is no longer found in the log of

MySQL forgot root password solution:# vi/etc/mysql/my.cnf (added under [mysqld])Press A or I to enter the compilation modeSkip-grant-tablesPress the ESC key to exit the compilation mode: Wq (Save and exit)# service MySQL Restart# MySQL> show

The way to examine the engine is to use mysqlshow, a tool that displays database information at the command line. Mysqlshow is available in the MySQL client installation package. To use mysqlshow, you need to provide the MySQL server login

[Warning] '--log_slow_queries ' is deprecated and would be removed in a future release. Please use '--slow_query_log '/'--slow_query_log_file ' instead.1. Modify the configuration

If your database file is large, you may need to take up a lot of server resources when backing up, so the webmaster should try to choose the minimum period of time to perform automatic backup commands, such as 4-5 o ' Day in the morning. Also, be

A MySQL backup related command:MYSQLDUMP-H host name-P Port-u user name-p password (–database) database name > file name. sqlCommands to back up the MySQL databaseMysqldump-hhostname-uusername-ppassword databasename > Backupfile.sqlbacking up the

Objective:If your database file is large, you may need to take up a lot of server resources when backing up, so the webmaster should try to choose the minimum period of time to perform automatic backup commands, such as 4-5 o ' Day in the morning.

Installing MySQL on Ubuntu is simple and requires only a few command lines1 Installing the serversudo apt-get install Mysql-server2 Installing the Clientsudo apt-get install mysql-clientLibmysqlclient-devThe installation process needs to set the

CentOS Installation Mysql-proxyCentOS Installation Mysql-proxymysql-proxy的用处就不再说了mysql-proxy依赖libevent,lua,glib2等几个软件So before you install it, firstyum install lua-develyum install glib2-develLibevent I use source code installation,Download

Common statements in MySQL:1: Create a table with self-growing primary keyDROP TABLE IF EXISTS user_login;CREATE TABLE User_login (user_id INT UNSIGNED not nullauto_increment,User_name VARCHAR () DEFAULT NULL,PRIMARY KEY user_id) Engine=myisam

Original: MySQL stored procedures and common functionsA. function1. Mathematical FunctionsCeil () into a roundingSELECT ceil (1.2); 2Floor () Rounding and roundingSELECT floor (1.9); 9MoD take remainder (modulo)SELECT MOD (3,8); 3--3 to 8

Use Java to access images and other types of files in the MySQL database1. Notes 1. When the database field isBlobType, must usePreparedStatementInSetBinaryStream (int, InputStream, int)Method;2. When the database field isLongblobType, must