PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
The binary log contains information about SQL statements that modify database contents. These events bring databases up to date from the point of the backup. Instead, each reference to a local variable is replaced by this construct for logging ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The following example shows a simple stored procedure that, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
On Windows, InnoDB always stores database and table names internally in lowercase. To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. MySQL Enterprise Backup The ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode.html
Other database systems might use little-endian byte order or a BOM. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode Standard ...
https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html
Unsuccessful connection attempts can occur for the following reasons: A client attempts to access a database but has no privileges for it. If connection problems occur such as communication errors or aborted connections, use these sources of ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Among other instructions discussed there, it is especially important to back up your database before the upgrade. Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
Before downgrading to a previous version, it is recommended that you drop the sys schema: DROP DATABASE sys; If you are downgrading to a release that includes the sys schema, mysql_upgrade recreates the sys schema in a compatible form. The effect ...
https://dev.mysql.com/doc/refman/5.7/en/metadata-locking.html
MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency. Metadata locking is not a replacement for the table definition cache, and its mutexes and locks differ from the LOCK_open mutex. Metadata ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-general-info.html
While many standard MySQL schemas and applications can work using NDB Cluster, it is also true that unmodified applications and database schemas may be slightly incompatible or have suboptimal performance when run using NDB Cluster (see Section ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-binary.html
Since the "world" database takes up # only about 500KB, this should be more than enough for # this example Cluster setup. Instead, you must either escape each backslash character with a second backslash (\\), or replace the backslash with a forward ...You should also have the MySQL client (mysql.exe) on this ...