310-810.pdf - mySQL 310-810 Sun Certified MySQL 5.0...

This preview shows page 1 - 3 out of 5 pages.

310-810mySQLSun Certified MySQL 5.0 Database(R) AdministratorPart 1
A. shell>mysql test < dump.sqlB. shell>mysqladmin recover test dump.sqlC. mysql> USE test;mysql> SOURCE dump.sql;D. mysql> RECOVER test dump.sql;Answer:A,CQUESTION:132You have created a dump using mysqldump with the --extended-insert option. Will yoube able to use this dump on any MySQL server instance?
QUESTION:133The MySQL server host crashes at 10:00 in the morning, and is brought back online at10: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 froma backup made at 03:00 the same morning. What should be done in order to bring thedatabase to the state it was at just before the server host crashed?

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 5 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
N/A
Tags
MYSQL, administrator, Sun Microsystems, InnoDB, MyISAM

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture