Which two capabilities are granted with the SUPER privilege?
You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead.
You execute the following commands:
ServerB commands:
Shell> mysqldump --u root --h server --no-data apps userdata | mysql --u root --p apps
Shell> mysql --u root --p --h server --e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;'
Shell> mysqldump --u root --p --h server --no-create-info --order-by-primary apps userdata | mysql
--u root --p apps
What effect does the -- order-by-primary argument have on the mysqldump command?
A user executes the statement;
PURGE BINARY LOGS TO 'mysql-bin.010';
What is the result?
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a RAW backup in this way?
MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
As the 'root' user, change the datadir location by executing:
Shell> cp --R /var/lib/mysql/data/mysql/
Shell> chown --R mysql /data/mysql/
What is the purpose of changing ownership of datadir to the 'mysql' user?