310-810 mySQL Sun Certified MySQL 5.0 Database(R) Administrator Part 1
A. shell>mysql test < dump.sql B. shell>mysqladmin recover test dump.sql C. mysql> USE test;mysql> SOURCE dump.sql; D. mysql> RECOVER test dump.sql; Answer: A,C QUESTION: 132 You have created a dump using mysqldump with the --extended-insert option. Will you be able to use this dump on any MySQL server instance? A. Always B. Yes, provided that --max-allowed-packet is set correctly C. Yes, provided that binary logging is turned off during the re-reading of the dump. D. No, the new server instance must be the same version as the one which created the dump for everything to work Answer: B QUESTION: 133 The MySQL server host crashes at 10:00 in the morning, and is brought back online at 10:30. In order to ensure that all data are consistent, a copy is first made of the table, tablespace and log files currently on the server host, and these files are then restored from a backup made at 03:00 the same morning. What should be done in order to bring the database to the state it was at just before the server host crashed?
You've reached the end of your free preview.
Want to read all 5 pages?
- Fall '20
- MYSQL , administrator, Sun Microsystems, InnoDB, MyISAM