1. Write three command statements to back up the `Orders` Table for data only, structure with...

50.1K

Verified Solution

Question

Programming

1. Write three command statements to back up the `Orders` Tablefor data only, structure with data and structure only usingmysqldump. 2. Write the command statement to import the data usingmysqlimport from customers.csv file. 3. What's the difference touse the LOAD DATA LOCAL INFILE vs mysqlimport. 4. Write SQLstatements: a. Create a database user \"cis495_dev1\" with password\"dolphins\". b. Create the database \"cis495Demo\". c. Grant user\"cis495_user1\" with \"select\" ,\"delete\" and \"execute\" permission toDB \"cis495Demo\". d. Revoke the privilege \"delete\" for the user\"cis495_user1\". 5. List three ways ( SQL statement: update, alter,set) to change the password from \"dolphines\" to \"icando\" for theuser \"cis495_user1\". 6. Explain the difference between user androle.

Answer & Explanation Solved by verified expert

4.3 Ratings (910 Votes)

Solution 1 Mysqldump is a commandline utility that is used to generate the logical backup of the MySQL database To export to file data only mysqldump t u user ppass t orders ordersdatasql To export to file and data backup mysqldump uuser ppass orders dumpfilenamesql To export to file structure only mysqldump d u user ppass d orders ordersstructuresql 2 To Import the data mysqlimport u user ppass customercsv Note The options in use are The u See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member