show tables

b/S architecture is very popular now, because the B/s architecture has many advantages, such as: Users need only have a browser to use, maintenance upgrades are more convenient, cross-platform, and so on. This article will talk about how the Windows+

This article describes the PHP implementation of the MySQL backup recovery method of the volume processing. Share to everyone for your reference. The specific analysis is as follows: Processing is the grasp of the data to be processed into a small

Friends familiar with Oracle know that when the Oracle database does not start properly, you can save data and reduce loss by dul or other tripartite tools that directly read data from data files. If you use the InnoDB engine in MySQL, you can also

In the last two articles (MySQL backup and restore cold standby, MySQL backup and restore real-world use Lengbei), we mentioned the use of cold standby in the Lengbei and real environment. So starting from this article, let's look at the hot standby.

One: Concept The popular copy set is to use multiple machines for the same data asynchronous synchronization, so that multiple machines have multiple copies of the same data, and when the main library when it is off without user intervention,

1.1 Select Advanced Applications 1.1.1 Pre-prep workThis test uses the world database, by MySQL Official offer :Https://dev.mysql.com/doc/index-other.html World file Import method, official

MySQL Advanced 1.mysql configuration fileThe MySQL configuration file is/etc/my.cnfConfiguration file Lookup Order: If there is a setting in multiple profiles, the last found final effect/etc/my.cnf --> /etc/mysql/my.cnf -->

Database managementLog in to MySQL[[email protected] conf]# mysql -u root -pEnter password: Welcome to the MySQL monitor. View database server all databasesmysql> show databases;+--------------------+| Database |+--------------------+|

Yesterday, a friend of the company used a MySQL instance to open Binlog, but in the process of booting failed (he did not mention, why failed), after the boot failed, he deleted the Ibdata1 and Ib_logfile, later, can normally start, but all the

Install MySQLInstalling MySQL on Ubuntu is very simple and requires just a few commands to complete.sudo apt-get install mysql-serversudo apt-get isntall mysql-clientsudo apt-get install libmysqlclient-devDuring installation, you will be prompted to

The importance of database backup Improve the system's high availability and disaster recoverability, when the database system crashes, no data backup can not find data. Restoring a database using a database backup is the best solution

1. Start the MySQL serverIn fact, the previous article has talked about how to start MySQL. Two methods:One is to use Winmysqladmin, if the machine started automatically run, you can go directly to the next step.Second, running in DOS

Connection: Mysql-h host address-u user name-P user Password (note: U and root can be used without spaces, others are the same)Disconnect: Exit (Enter)Create authorization: Grant SELECT on database. * To User name @ login host identified by \

1. DescriptionWhen you install or use MySQL, you will find a INFORMATION_SCHEMA database in addition to the database you have installed. The INFORMATION_SCHEMA database is a MySQL-band that provides a way to access database metadata. Metadata is

Connection: Mysql-h host address-u user name-P user Password (note: U and root can be used without spaces, others are the same)Disconnect: Exit (Enter)Create authorization: Grant SELECT on database. * To User name @ login host identified by \

MySQL full backup and Recovery experiment IntroductionDatabase backups can be divided into physical and logical backups from a physical and logical perspective. From the database backup policy perspective, can be divided into full backup,

Problem-handling for reference to online contentRe-master from, fully synchronizedAfter you create a new table in the main library, you find that the data is not synchronized in the slave segment.MySQL version:5.6.10Os:rhel 5.6The steps to resolve

1. Display all databases of the data servershow databases;2. Create a databaseCreate database if not exits + DB name;3. Deleting a databaseDrop DATABASE + DB name4. Using the default databaseUse + database name;5. Create a data tableCREATE table if

MySQL full backup and restore full backup: Backup of the entire database, database structure and file structure, the database is saved at the time of preparation, is the basis of incremental backup. A backup of the MySQL database can be done in two

Database and SQL ConceptsA database ( Database ) is a warehouse that organizes, stores, and manages data in accordance with its structure, which has been generated more than 60 years ago. With the development of information technology and market,