Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-to-other-server.html
On Server 1: $> mysqldump --databases db1 > dump.sql Copy the dump file from Server 1 to Server 2. On Server 2: $> mysql < dump.sql Use of --databases with the mysqldump command line causes the dump file to include CREATE DATABASE and USE ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-partitioning.html
There may be situations where you have a single source server and want to replicate different databases to different replicas. A sample of this layout is shown in Figure 19.2, “Replicating Databases to Separate Replicas”. Figure 19.2 ...For ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-sles-repo.html
If you have installed MySQL with RPMs from the MySQL Developer Zone or the native software repository of SLES and want to replace the installation using the RPM from the MySQL SLES repository, follow these steps: Back up your database to avoid data ...Among other instructions discussed there, it is especially important to back up your database before the ... The MySQL SLES repository provides RPM ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-sample-data.html
Importing Sample Database 7.2.1.1 Importing Sample Database Oracle provides on AWS sample databases for you to test out MySQL HeatWave on AWS. Use the Import sample data feature in MySQL HeatWave Console to import the sample database into a DB ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
To restore a MySQL instance from a backup to a database server: Shut down the database server. 240426 13:17:07 PCR3 INFO: Copying database directory: meta 240426 13:17:07 RDR1 INFO: Copying undo_002. 240426 13:17:08 PCR1 INFO: Starting to apply a ...Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and --innodb_undo_directory options for restore, if the directories are different from the data ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
Note that the replacement variable authentication_policy is not set by MySQL Configurator. These variables are listed here, with their replacements in brackets: Com_slave_start (Com_replica_start); Com_slave_stop (Com_replica_stop); ...(Bug ...
https://dev.mysql.com/doc/refman/8.4/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. The SELECT statement can use a VALUES statement as its source, or can be replaced with a TABLE statement, as ...For information about restrictions on view use, see Section 27.9, “Restrictions on ...
https://dev.mysql.com/doc/workbench/en/wb-documenting-sakila.html
This chapter demonstrates the capabilities of MySQL Workbench as a documentation tool by using the sakila database, which is a database sample provided by MySQL. You can find this database sample, and others, by visiting the ...Rather than reading ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-prep-gather.html
Before backing up a particular database server for the first time, gather some information and use it to make some planning decisions, as outlined in the following table. Table 4.1 Information Needed to Back Up a Database Information to Gather ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html
To reverse-engineer a live database, click Database and then Reverse Engineer from the menu. The figure that follows shows an example of the Reverse Engineer Database wizard. Figure 9.49 Reverse Engineer Database Wizard The first step of the wizard ...You can set up a new connection or select a previously created stored ...