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/mysqldump-sql-format.html
Without this option, mysqldump treats the first name as a database name and those following as table names. To dump only specific tables from a database, name them on the command line following the database name: $> mysqldump test t1 t3 t7 > ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-stored-programs.html
The other options are disabled by default and must be specified explicitly to dump the corresponding objects. To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-upgrade-testing.html
(This is also useful for testing downgrades.) On the production server: $> mysqldump --all-databases --no-data --routines --events > dump-defs.sql On the upgraded server: $> mysql < dump-defs.sql Because the dump file does not contain table data, it ... When contemplating a MySQL upgrade, it is prudent to install the newer version separately from your current production ...
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
The current set of valid short phrases for use with commands is shown in the following table. MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL Installer. This reference includes: MySQL Product Names Command ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may experience problems when MySQL generates temporary tables for some complicated joins. Typically this is value+1, where value is the ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: name The function name as referred to in SQL statements. dl The name of the function ...Permitted values are 0 (STRING), 1 (REAL), 2 (INTEGER), 3 (ROW), or 4 ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-benchmarking.html
With simple tests, you usually test how changing one aspect (a configuration setting, the set of indexes on a table, the SQL clauses in a query) affects performance. The two most important features to try with each workload are the MySQL query ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
See also Section 8.2.2, “Optimizing Subqueries, Derived Tables, and View References”. Use x = ANY (table containing (1,2)) rather than x=1 OR x=2. Development is ongoing, so no optimization tip is reliable for the long term. The following list ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Access to this table should never be granted to any nonadministrative accounts. The validate_password plugin can be used to enforce a policy on acceptable password. Database ...