PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
(Storing 0 is not a recommended practice, by the way.) For example, if you dump the table with mysqldump and then reload it, MySQL normally generates new sequence numbers when it encounters the 0 values, resulting in a table with contents different ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-usage.html
To generate a dump file, name the sys schema explicitly on the command line using either of these commands: mysqldump --databases --routines sys > sys_dump.sql mysqlpump sys > sys_dump.sql To reinstall the schema from the dump file, use this ...Most ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
That shortcoming can lead to problems backing up a database with mysqldump, which may fail due to insufficient privileges. Dump files created with mysqldump cannot be loaded into servers that enforce the column-length restriction. The maximum ...
https://dev.mysql.com/doc/refman/8.0/en/xml-functions.html
Note It is possible to obtain XML-formatted output from MySQL in the mysql and mysqldump clients by invoking them with the --xml option. See Section 6.5.1, “mysql — The MySQL Command-Line Client”, and Section 6.5.4, “mysqldump — A Database ... Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
Details for mysqldump can be found in Chapter 6, MySQL Programs. It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage engine, which has support for transactions and automatic crash recovery. Assume also that the ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-summary.html
Make periodic full backups, using the mysqldump command shown earlier in Section 9.3.1, “Establishing a Backup Policy”, that makes an online, nonblocking backup. In case of an operating system crash or power failure, InnoDB itself does all the ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
If you cannot produce a test case with only a few rows, or if the test table is too big to be included in the bug report (more than 10 rows), you should dump your tables using mysqldump and create a README file that describes your problem. Before ...
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html
The following programs support the two options: mysql, mysqlsh, mysqladmin, mysqlbinlog, mysqlcheck, mysqldump, mysqlimport, mysqlpump, mysqlshow, mysqlslap, mysqltest, mysql_upgrade. MySQL provides two authentication plugins that implement SHA-256 ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
For object definitions that refer to the utf8mb4 character set, you can dump them with mysqldump prior to downgrading, edit the dump file to change instances of utf8mb4 to utf8, and reload the file in the older server, as long as there are no 4-byte ... This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character ...