Description of core php.ini directives. This list includes the core php.ini directives you can set to configure your PHP setup. Directives handled by extensions are listed and detailed at the extension documentation pages. Sitemaps XML format Jump to: XML tag definitions Entity escaping Using Sitemap index files Other Sitemap formats Sitemap file location Validating your Sitemap Extending the Sitemaps protocol Informing search engine crawlers. Sass is an extension of CSS that adds power and elegance to the basic language. It allows you to use variables, nested rules, mixins, inline imports, and more, all with a fully CSS-compatible syntax. Sass helps keep large. Abstract. This specification provides an API for representing file objects in web applications, as well as programmatically selecting them and accessing their data. This includes: A FileList interface, which represents an. Performance and Scalability Considerations. mysqldump advantages include the convenience and flexibility of viewing or even editing the output before restoring. You can clone databases for development and DBA work. Chapter 2. The Filesystem. This standard assumes that the operating system underlying an FHS-compliant file system supports the same basic security features found in most UNIX filesystems. It is possible to define two. A Database Backup Program. A Database Backup Program. The mysqldump client utility performs. SQL statements that can be executed to. It dumps one or more My. SQL databases for backup or. SQL server. The mysqldump. CSV, other delimited text. XML format. mysqldump requires at least the. SELECT privilege for dumped. SHOW VIEW for dumped. TRIGGER for dumped. LOCK TABLES if the. Certain options might require other privileges as. To reload a dump file, you must have the privileges required to. CREATE privileges for objects created by. ALTER DATABASE statements that. These may be used when dumping. To reload. a dump file containing such statements, the. ALTER privilege for the affected database is. A dump made using Power. Shell on Windows with output. UTF- 1. 6 encoding. However, UTF- 1. 6 is not permitted as a connection character set. Section 1. 0. 1. Connection Character Sets and Collationsâ€), so the dump file. To work around this issue, use the. ASCII format. shell> mysqldump [options] - -result- file=dump. Performance and Scalability Considerationsmysqldump advantages include the convenience. You can clone databases for development and DBA work. It is not intended as a fast or scalable solution for. With large data sizes. SQL statements. involves disk I/O for insertion, index creation, and so on. For large- scale backup and restore, a. If your tables are primarily Inno. DB. tables, or if you have a mix of Inno. DB. and My. ISAM tables, consider using the. My. SQL. Enterprise Backup product. Available as part of the. Enterprise subscription.) It provides the best performance. Inno. DB backups with minimal. My. ISAM and other storage engines; and it. See. Section 2. 5. My. SQL Enterprise Backup Overviewâ€. If your tables are primarily My. ISAM. tables, consider using the mysqlhotcopy. See Section 4. 6. A Database Backup Programâ€. Buffering in. memory can be a problem if you are dumping large tables. To dump. tables row by row, use the. The. - -opt option (and hence. If you are using a recent version of. My. SQL server, use the. For additional information about mysqldump. Section 7. 4, “Using mysqldump for Backupsâ€. Invocation Syntax. There are in general three ways to use. My. SQL server—as shown here. To dump entire databases, do not name any tables following. To see a list of the options your version of. Option Syntax - Alphabetical Summarymysqldump supports the following options. For information about option files. My. SQL programs, see Section 4. Using Option Filesâ€. Table 4. 9 mysqldump Options. Connection Options. The mysqldump command logs into a My. SQL. server to extract information. The following options specify how. My. SQL server, either on the same machine or a. On a computer having multiple network interfaces, use this. My. SQL server. This option is supported beginning with My. SQL 5. 6. 1. - -compress, - C. Compress all information sent between the client and the. A hint about the client- side authentication plugin to use. See Section 6. 3. Pluggable Authenticationâ€. Enable the mysql_clear_password cleartext. See. Section 6. 5. The Cleartext Client- Side Authentication Pluginâ€.). This option was added in My. SQL 5. 6. 2. 8. - -host=host_name. Dump data from the My. SQL server on the given host. The. default host is localhost. Read options from the named login path in the. A. “login path†is an option group containing. My. SQL server to connect to and. To create or modify a. See. Section 4. 6. My. SQL Configuration Utilityâ€. This option was added. My. SQL 5. 6. 6. - -password[=password]. The password to use when connecting to the server. If you. use the short option form (- p), you. If you omit the. password value following the. Specifying a password on the command line should be. See. Section 6. 1. End- User Guidelines for Password Securityâ€. You can use an. option file to avoid giving the password on the command. W. On Windows, connect to the server using a named pipe. This. option applies only if the server supports named- pipe. The directory in which to look for plugins. Specify this. option if the. See. Section 6. 3. Pluggable Authenticationâ€. P port_num. The TCP/IP port number to use for the connection. TCP|SOCKET|PIPE|MEMORY}. The connection protocol to use for connecting to the server. It is useful when the other connection parameters normally. For details on the permissible values, see. Section 4. 2. 2, “Connecting to the My. SQL Serverâ€. - -secure- auth. Do not send passwords to the server in old (pre- 4. This prevents connections except for servers that use the. This option is enabled by default. This option was added in My. SQL 5. 6. 1. 7. - S path. For connections to localhost, the Unix. Windows, the name of the named. Options that begin with. SSL and indicate where to find. SSL keys and certificates. See. Section 6. 4. Command Options for Secure Connectionsâ€. The My. SQL user name to use when connecting to the server. You can also set the following variables by using. The maximum size of the buffer for client/server. The default is 2. MB, the maximum is 1. GB. net_buffer_length. The initial size of the buffer for client/server. When creating multiple- row. INSERT statements (as with. If you increase this variable, ensure that the My. SQL. server net_buffer_length. Option- File Options. These options are used to control which option files to read. Read this option file after the global option file but (on. Unix) before the user option file. If the file does not. Use only the given option file. If the file does not exist. Read not only the usual option groups, but also groups with. For example. mysqldump normally reads the. If the. - -defaults- group- suffix=_other. Do not read any option files. If program startup fails due. The exception is that the . This permits. passwords to be specified in a safer way than on the command. See. Section 4. 6. My. SQL Configuration Utilityâ€.). Print the program name and all options that it gets from. Usage scenarios for mysqldump include setting. My. SQL instance (including database tables), and. The following options let you specify. DDL statements within the dump file. The following options print debugging information, encode. Permit creation of column names that are keywords. This. works by prefixing each column name with the table name. Write additional information in the dump file such as. This option is. enabled by default. To suppress this additional information. Write a debugging log. A typical. debug_options string is. The default value is. Print some debugging information when the program exits. Print debugging information and memory and CPU usage. If the - -comments option. Dump completed on DATE. However, the date causes dump files taken at different times. The. default is - -dump- date. Continue even if an SQL error occurs during a table dump. One use for this option is to cause. Without. - -force, mysqldump exits. With - -force. mysqldump prints the error message, but. SQL comment containing the view definition. Log warnings and errors by appending them to the named file. The default is to do no logging. See the description for the. Verbose mode. Print more information about what the program. The following options display information about the. Display a help message and exit. V. Display version information and exit. Internationalization Options. The following options change how the. Replication Options. The mysqldump command is frequently used to. The following. options apply to dumping and restoring data on replication. For a slave dump produced with the. STOP SLAVE statement before. CHANGE MASTER TO. START SLAVE. statement at the end of the output. On a master replication server, delete the binary logs by. PURGE BINARY LOGS. This option automatically enables. This option is similar to. It. causes the dump output to include a. CHANGE MASTER TO statement. These are the master. In. addition, specfiying this option causes the. The option value is handled the same way as for. CHANGE MASTER TO. SQL comments) and has. This option causes mysqldump to stop the. SQL thread before the dump and restart it again after. In conjunction with - -dump- slave, the. For the CHANGE MASTER TO. MASTER_HOST and. MASTER_PORT options for the host name and. TCP/IP port number of the slave's master. Use this option to dump a master replication server to. It causes the dump output. CHANGE MASTER TO. These are the. master server coordinates from which the slave should start. If the option value is 2, the CHANGE. MASTER TO statement is written as an SQL comment. If the option value is 1, the statement is. If no option value is specified, the default. This option requires the. RELOAD privilege and the. The - -master- data option automatically. It also turns on. In. all cases, any action on logs happens at the exact moment of. It is also possible to set up a slave by dumping an existing. Prior to My. SQL 5. Section 1. 7. 2. Replication Relay and Status Logsâ€). This option enables control over global transaction ID. GTID) information written to the dump file, by indicating. SET. @@global. gtid_purged statement to the output. This. option may also cause a statement to be written to the. The following table shows the permitted option values. The. default value is AUTO. Value. Meaning. OFFAdd no SET statement to the output. ONAdd a SET statement to the output. An error occurs if. GTIDs are not enabled on the server. AUTOAdd a SET statement to the output if GTIDs are. The - -set- gtid- purged option has the. OFF: SET. @@SESSION. SQL_LOG_BIN=0; is not added to the. ON: SET. @@SESSION. SQL_LOG_BIN=0; is added to the. AUTO: SET. @@SESSION. SQL_LOG_BIN=0; is added to the. GTIDs are enabled on the server you are. AUTO. evaluates to ON). This option was added in My. SQL 5. 6. 9. The following options specify how to represent the entire dump. They also. control whether certain optional information is written to the. Produce more compact output. This option enables the. Produce output that is more compatible with other database. My. SQL servers. The value of. To use several values. These values have the same meaning. SQL. mode. See Section 5. Server SQL Modesâ€.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2016
Categories |