MySQL

My Computer environment: Mac 10.09First, the Mac computer comes with Apache, it is not happy to reinstall theSimple, three commands for Apache.sudo apachectl start opensudo apachectl restart restartsudo apachectl stop stopTo view the version of

MySQL how to properly change a large table structure (Alter table structure of a single columnHttp://blog.sina.com.cn/s/blog_445e807b0101egpf.htmlFound on the Internet a very helpful three-paragraph script, posted for reference, readers, make a note:

1. Issues needing attention when deleting data "Delete Record Delete" Delete the data itself does not have much to say, or delete the table when there is truncate usage delete from is deleted record by article "Plus no conditions all deleted,

[[email protected] yum.repos.d]# rpm-e--nodeps MySQLError:package MySQL is not installed[[email protected] yum.repos.d]# rpm-qa |grep MySQL[[email protected] yum.repos.d]# yum install MySQL=============================================================

#安装JDK1. Check if the system installs the JDK and uninstallRpm-qa | grep javatzdata-java-2013g-1.el6.noarchjava-1.7.0-openjdk-1.7.0.45-2.4.3.3.el6.x86_ 64java-1.6.0-openjdk-1.6.0.0-1.66.1.13.0.el6.x86_642. Delete PackageRpm-e--nodeps tzdata-java-2013

Original: http://www.drupal001.com/2014/02/percona-xtrabackup-mysql/Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM

Original link: https://mariadb.com/kb/en/mariadb-vs-mysql-features/Xiaomo translation------Support for more storage enginesIn addition to the standard MyISAM, blackhole, CSV, memory, and ARCHIVE, the following storage engines are also included in

1. Backgroundalways wanted to write a web app to play, a few days ago saw a GitHub resume automatically generated by the Web-app, so the hands-on imitation of a csdn CV generator. The structure is simple, the front end is the Html/css file (this is

Original link: http://www.2cto.com/database/201303/195303.html, Mysqlslap introduction Mysqlslap MySQL5.1 is a benchmark benchmark tool, similar to the Apache Bench load generation tool, generates schema, loads data, executes Benckmark and queries

"Development Environment"Physical machine Version: Win 7 Ultimate Edition (64-bit)MySQL version: Version 5.5.40MSI (64-bit)First, the database type:(1) Relational database(2) Object-oriented database(3) XML databaseThe current mainstream is the

with most relationship types database, log files are an important part of the MySQL database. MySQL has several different log files, usually including error log files, binary logs, generic logs, slow query logs, and so on. These logs can help us

One, NDB Cluster (distributed storage engine) storage Engine Brief IntroductionNDB storage Engine is also called NDB Cluster storage engine, mainly used for MySQL Cluster distributed cluster environment,Cluster is a new feature that MySQL has only

functions for date, time \ Timestamp in SQL statements in MySQL databaseOne MySQL gets the current date time function1.1 Get the current date + time (date + times) function: Now ()Mysql> Select Now ();+―――――――+| Now () |+―――――――+| 2008-08-08 22:20:46

Command: Pip Install Mysql-python Error: _MYSQL.C: Fatal error C1083:cannot open include file: ' Config-win.h ': No such file or Directoryerror:command ' c:\\p Rogram Files (x86) \\Common files\\microsoft\\visual C + + for

Purpose: To import a. txt file to the MySQL database, using the load command to implementEnter the following command to error:Modify the command, still error:Possible causes (from MySQL reference manual):If LOAD DATA localis Disabled, either in the

When a new version of MySQL is used, the old version of MySQL is connected, and it is possible to report:ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication Protocol refUsed (client option ' Secure_auth ' enabled) this error.The

1. Overview of Xtrabackup: Percona Xtrabackup is an open-source and free mysql Database Hot Backup Software. It can back up InnoDB and XtraDB storage engine databases in a non-blocking manner (Table locks are also required for MyISAM backup ).

How to Use Percona Toolkit to solve the problem of Mysql master non-synchronization (1) For various reasons, data inconsistency often occurs in the mysql Master/Slave architecture, which is roughly attributed to the following categories: 1:

Small Drupal database backup, MySQL backup policy sharing for large sites, and drupal Database Backup Simple backup policy for small and medium sites For small and medium-sized websites based on drupal, we can use the backup_migrate module, which

MySql backup and recovery, MySql backup and recovery 1. mysql backup: Query the database to be backed up: 1: mysql -u root -psywu 2: 3: mysql> show databases; 4: +--------------------+ 5: | Database | 6: +--------------------+ 7: