Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
(See Section 2.1.5, “Installation Layouts”.) mysqld_safe expects one of the following conditions to be true: The server and databases can be found relative to the working directory (the directory from which mysqld_safe is invoked). If the server ... mysqld_safe is the recommended way to start a mysqld server on ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-upgrade-testing.html
Then you can dump the database and database object definitions from the production server and load them into the new server to verify that they are handled properly. (This is also useful for testing downgrades.) On the production server: $> ... When ...
https://dev.mysql.com/doc/refman/8.4/en/option-defaults-equals.html
080112 12:53:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var $> After shutting down the server, restart it as follows: $> mysqld_safe --log-error & [1] 11699 $> 080112 12:53:40 mysqld_safe Logging to ...Due to this ...
https://dev.mysql.com/doc/refman/8.4/en/perl-support.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI, you must install the DBI module, as well as a DataBase Driver (DBD) module ...You can obtain the necessary modules from http://search.cpan.org for Unix, or by using the ActiveState ppm program on ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
For some distribution types (such as binary distributions on Windows, or RPM and DEB distributions on Linux), the installation process initializes the MySQL data directory, including the mysql system database containing the grant tables. (The data ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Access privileges for the connection metadata repository table mysql.slave_master_info should be restricted to the database administrator, because it contains the replication user account name and password for connecting to the source. Use a ... A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-performance.html
Figure 19.3 Using an Additional Replication Source to Improve Performance For this to work, you must configure the MySQL instances as follows: Source 1 is the primary source where all changes and updates are written to the database. The above ... As ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-scaleout.html
You can use replication as a scale-out solution; that is, where you want to split up the load of database queries across multiple database servers, within some reasonable limitations. Figure 19.1 Using Replication to Improve Performance During ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-switch.html
The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary log. In a failover situation, all the ...
https://dev.mysql.com/doc/refman/8.4/en/reproducible-test-case.html
The binary log is saved in the MySQL database directory with the name hostname-bin.NNNNNN. FTP the tables and the binary log to our bugs database using the instructions given in Section 1.6, “How to Report Bugs or Problems”. For information ...