ASSESSMENT 3- Individual Project- Submission Guide You need to submit three things:ERD in word document formatDatabase file (Using export option in My SQL workbench or Mysqldump command. The procedure is explained below)Queries (execute your queries and take the screen shot)Put all three files (Word, screenshot, SQL file) in a folder, zip it and upload it in your assessment 3 submission folder. EXPORTING DATABASE IN MYSQL WORKBENCH Go to MySQL Workbench, Click on SERVER and then DATA EXPROT option as shown below: A dialog box will open, choose your schema to be exported as below: Click on Start Export button to export your schema. You will be prompted for your password, provide the password (if you have specified a password earlier), otherwise leave it empty and your export will start.In some versions of MYSQL workbench you might encounter an error. In that case use following command to dump your database. Using Mysqldump command for exporting database: Go to command prompt and switch to the path of MySQL till BIN folder. In my case MYSQL is in XAMPP2 folder and hence my bath to bin would be C:xampp2mysqlbinWrite the command: mysqldump -u [user name] –p [password] [database_name] > [dumpfilename.sql] Here “mysqldump” is the command, -u is switch for providing the username, -p for providing password, followed by database name that you want to export (without the extension .sql) followed by > and then name of your dump file with .sql extension. For instance, my username is “root” and I did not specify a password when I created my database. If I want to export my database called “Trial” to a dump file called “trialdump”, this is how it would be done: I will be prompted for password, If you have a password provide it, otherwise leave it empty. If you do not have an error, you will be back on prompt as shown above. You can see your sql file in Bin folder as shown below in screenshot.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.
