I need some help with a little mysql coding. Here is the short description...A Database Story: Backup then Recovery [NG]Author: Daniel KillamFramework Category: Operate and MaintainSpecialty Area: Network ServicesWork Role: Network Operations SpecialistTask Description: Develop and implement network backup and recovery procedures. (T0065)ScenarioIt seems that our new intern has deleted some important database files needed for an upcoming project. This incident has caused us to realize that we are severely lacking in our standard recovery and backup procedures. As such , we need you to design and implement a plan for backing up and restoring data critical to our business. After designing these procedures, they need to be tested in order to ensure their functionality.Additional InformationMore details and objectives about this challenge will be introduced during the challenge meeting, which will start once you begin deploying the challenge.You will be able to check your progress during this challenge using the check panel within the workspace once the challenge is deployed. The checks within the check panel report on the state of some or all of the required tasks within the challenge.Once you have completed the requested tasks, you will need to document the methodology you used with as much detail and professionalism as necessary. This should be done on the documentation tab within the workspace once the challenge is deployed. Below the main documentation section be sure to include a tagged list of applications you used to complete the challenge.Your username/password to access all virtual machines and services within the workspace will be the following...Username: playeronePassword: password123 A Database Story: Backup then Recovery | Thomas BrownO 36h 08m LeftSubmit Challenge AttemptVirtual MachinesChecksO Having issues with mouse/keyboard input or connecting to VM consoles?StatusCheck DescriptionCheck TypeCheck StateLast ChangedMachine NameStatusActionsOpen Console ?Wordpress Database SQL Dump Placed on Backup ServerChallenge Check 2.Undesireable State08:44 AM PSTBackupPowered OnAction -S HTML5OVMRCWordpress Database Restored on the Backup Server Mysql InstallationChallenge Check ?Undesireable State08:43 AM PSTDatabasePowered OnAction -同HTML5OVMRCDev-WebPowered OnAction -5 HTML5OVMRCDomain-ControllerPowered OnAction -5 HTML5Q VMRCFilesharePowered OnAction -O VMRCFirewallPowered OnAction -同HTML5VMRCMailPowered OnAction -5 HTML5O VMRCProd-WebPowered OnAction -S HTML5OVMRCSecurity-DeskPowered OnAction -S HTML5OVMRCWorkstation-DeskPowered OnAction -S HTML5QVMRCDocumentationE Challenge InfoMeeting Notes* Network MapD DD D D Security-DeskБ HTML5OVMRCPowered OnActionWorkstation-DeskPowered OnAction -S HTML5O VMRCDocumentationE Challenge InfoMeeting Notes* Network MapGary ThatcherHey, @playerone, I've been taking a look recently and noticed that we haven't been backing anything up. In order to make sure we don't lose data, we should be backing up critical data often. We need you to write up some backup andrestoration procedures with response to database backup. I'd like this task done as soon as possible.Richard LeGrandMAKE SURE EVERYTHING IS WORKING CORRECTLY BEFORE THESE PROCEDURES GO INTO EFFECT!Gary ThatcherOn that note, in order to ensure that the procedures you write up work, we're going to need you to create a sql dump of our 'wordpress' MYSQL database and move it to the Backup server first. When you've finished that go ahead and use theMYSQL server on the Backup machine and restore the wordpress database to said server. Use the steps that you take while doing these things in order to write up a set of procedures that can be used by other employees to replicate thisprocess.lone Leventis@playerone, the MYSQL server is hosted on Database, and I went ahead and created a folder on Backup at filepath /ftp/public/prodbackup/ in which I'd like you to put a sql dump file of the 'wordpress' database. Also, if you can name the file'dump.sql' so we can take a look at it if we need, that would be great. Make sure that the dump includes a backup of all tables. Also, don't do anything else to modify the file contents. Keep it a rather plain SQL dump.© 2016-2022 NICE Challenge ProjectLegal Agreements

I need some help with a little mysql coding. Here is the short description... A Database Story: Backup then Recovery [NG] Author: Daniel Killam Framework Category: Operate and Maintain Specialty Area: Network Services Work Role: Network Operations Specialist Task Description: Develop and implement network backup and recovery procedures. (T0065) Scenario It seems that our new intern has deleted some important database files needed for an upcoming project. This incident has caused us to realize that we are severely lacking in our standard recovery and backup procedures. As such , we need you to design and implement a plan for backing up and restoring data critical to our business. After designing these procedures, they need to be tested in order to ensure their functionality. Additional Information More details and objectives about this challenge will be introduced during the challenge meeting, which will start once you begin deploying the challenge. You will be able to check your progress during this challenge using the check panel within the workspace once the challenge is deployed. The checks within the check panel report on the state of some or all of the required tasks within the challenge. Once you have completed the requested tasks, you will need to document the methodology you used with as much detail and professionalism as necessary. This should be done on the documentation tab within the workspace once the challenge is deployed. Below the main documentation section be sure to include a tagged list of applications you used to complete the challenge. Your username/password to access all virtual machines and services within the workspace will be the following... Username: playerone Password: password123

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

A Database Story: Backup then Recovery [NG]

Author: Daniel Killam
Framework Category: Operate and Maintain
Specialty Area: Network Services
Work Role: Network Operations Specialist
Task Description: Develop and implement network backup and recovery procedures. (T0065)
Scenario

It seems that our new intern has deleted some important database files needed for an upcoming project. This incident has caused us to realize that we are severely lacking in our standard recovery and backup procedures. As such , we need you to design and implement a plan for backing up and restoring data critical to our business. After designing these procedures, they need to be tested in order to ensure their functionality.

Additional Information

More details and objectives about this challenge will be introduced during the challenge meeting, which will start once you begin deploying the challenge.

You will be able to check your progress during this challenge using the check panel within the workspace once the challenge is deployed. The checks within the check panel report on the state of some or all of the required tasks within the challenge.

Once you have completed the requested tasks, you will need to document the methodology you used with as much detail and professionalism as necessary. This should be done on the documentation tab within the workspace once the challenge is deployed. Below the main documentation section be sure to include a tagged list of applications you used to complete the challenge.

Your username/password to access all virtual machines and services within the workspace will be the following...
Username: playerone
Password: password123

A Database Story: Backup then Recovery | Thomas Brown
O 36h 08m Left
Submit Challenge Attempt
Virtual Machines
Checks
O Having issues with mouse/keyboard input or connecting to VM consoles?
Status
Check Description
Check Type
Check State
Last Changed
Machine Name
Status
Actions
Open Console ?
Wordpress Database SQL Dump Placed on Backup Server
Challenge Check 2.
Undesireable State
08:44 AM PST
Backup
Powered On
Action -
S HTML5
OVMRC
Wordpress Database Restored on the Backup Server Mysql Installation
Challenge Check ?
Undesireable State
08:43 AM PST
Database
Powered On
Action -
同HTML5
OVMRC
Dev-Web
Powered On
Action -
5 HTML5
OVMRC
Domain-Controller
Powered On
Action -
5 HTML5
Q VMRC
Fileshare
Powered On
Action -
O VMRC
Firewall
Powered On
Action -
同HTML5
VMRC
Mail
Powered On
Action -
5 HTML5
O VMRC
Prod-Web
Powered On
Action -
S HTML5
OVMRC
Security-Desk
Powered On
Action -
S HTML5
OVMRC
Workstation-Desk
Powered On
Action -
S HTML5
QVMRC
Documentation
E Challenge Info
Meeting Notes
* Network Map
D D
D D D

Security-Desk
Б HTML5
OVMRC
Powered On
Action
Workstation-Desk
Powered On
Action -
S HTML5
O VMRC
Documentation
E Challenge Info
Meeting Notes
* Network Map
Gary Thatcher
Hey, @playerone, I've been taking a look recently and noticed that we haven't been backing anything up. In order to make sure we don't lose data, we should be backing up critical data often. We need you to write up some backup and
restoration procedures with response to database backup. I'd like this task done as soon as possible.
Richard LeGrand
MAKE SURE EVERYTHING IS WORKING CORRECTLY BEFORE THESE PROCEDURES GO INTO EFFECT!
Gary Thatcher
On that note, in order to ensure that the procedures you write up work, we're going to need you to create a sql dump of our 'wordpress' MYSQL database and move it to the Backup server first. When you've finished that go ahead and use the
MYSQL server on the Backup machine and restore the wordpress database to said server. Use the steps that you take while doing these things in order to write up a set of procedures that can be used by other employees to replicate this
process.
lone Leventis
@playerone, the MYSQL server is hosted on Database, and I went ahead and created a folder on Backup at filepath /ftp/public/prodbackup/ in which I'd like you to put a sql dump file of the 'wordpress' database. Also, if you can name the file
'dump.sql' so we can take a look at it if we need, that would be great. Make sure that the dump includes a backup of all tables. Also, don't do anything else to modify the file contents. Keep it a rather plain SQL dump.
© 2016-2022 NICE Challenge Project
Legal Agreements

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.