Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/exec-option.html
The --exec-when-locked option of mysqlbackup lets you specify a command (together with the desired command arguments) to run near the end of the backup while the database's non-InnoDB tables are still locked. This command can copy or create ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-session.html
Table 4.48 currentTransaction() Parameter Description return the transaction 4.3.1.22.6 deletePersistent(Class<T>, Object) public abstract void deletePersistent(Class<T> cls, Object key); Delete an instance of a class from the database given its ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
If the source database contains existing data it is necessary to copy this data to each replica. There are different ways to dump the data from the source database. To select the appropriate method of dumping the database, choose between these ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restore-cluster.html
Prevent one or more databases or tables from being restored using the options --exclude-databases and --exclude-tables. --exclude-databases takes a comma-delimited list of one or more databases that should not be restored. --exclude-tables takes a ...Stop the cluster using stop cluster, then restart it using start cluster with the --initial option, which causes the data node file systems to be ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-connection-macos.html
Connection parameters are similar to Linux, see Section 10.5.3.2, “Linux”.
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-connection.html
This section focuses on creating a connection to the source Microsoft SQL Server, because creating a MySQL connection is a standard operation. Note Prerequisite: that you already installed and configured the required Microsoft SQL Server driver on ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-linux.html
Many distributions ship older versions of FreeTDS, so it may need to be installed separately. Additionally, the FreeTDS version provided by distributions may also be compiled for the wrong ODBC library (usually to unixODBC instead of iODBC, which ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-macos.html
See the FreeTDS setup notes for Linux, Section 10.5.2.2, “Linux”.
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers.html
Microsoft Windows does not require additional drivers to be installed and configured, but Linux (and macOS) do. The following sections include specific instructions for each type of system.
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-typemapping.html
The following table shows the mapping between Microsoft SQL Server (source) data types and MySQL data types. Table 10.2 Type mapping Source Type MySQL Type Comment INT INT TINYINT TINYINT UNSIGNED flag set in MySQL. SMALLINT SMALLINT BIGINT BIGINT ...