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/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You might have to run commands as the MySQL root user on the new machine until you have the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. By default, the server interprets ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. If the OR REPLACE clause is present, you must also have the DROP privilege for the view. By default, a new ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET ...If ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
Replacing a database directory with a symbolic link works as long as you do not make a symbolic link between databases. On Unix, the way to symlink a database is first to create a directory on some disk where you have free space and then to create ...If one client updates db1.tbl_a and another client updates db2.tbl_a, problems are likely to ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
The server's binary log consists of files containing “events” that describe modifications to database contents. --database=db_name, -d db_name Command-Line Format --database=db_name Type String This option causes mysqlbinlog to output entries ...To display their contents in text format, use the mysqlbinlog ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules-db-options.html
In those cases, the database being created, altered, or dropped replaces the default database when determining whether to log or ignore updates. The database that is checked for a match depends on the binary log format of the statement that is being ... When evaluating replication options, the replica begins by checking to see whether there are any --replicate-do-db or --replicate-ignore-db options that ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
If you use the --databases or --all-databases option to process all tables in one or more databases, an invocation of mysqlcheck might take a long time. There are three general ways to invoke mysqlcheck: mysqlcheck [options] db_name [tbl_name ...] ... The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
These privileges are global because they are not specific to a particular database. Database privileges apply to a database and to all objects within it. These privileges can be granted for specific databases, or globally so that they apply to all ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
If it does, the relative part of the path is replaced with the absolute path set using the --log-bin option. Only those statements are written to the binary log where the default database (that is, the one selected by USE) is db_name. To specify ...