Member Avatar for Samyx

How can I create a SQL Script using MySql?

I already created a database and tables. I populated the tables and wrote queries to solve the questions in my homework. But the professor want me to submit the SQL script.

Can anyone help me?

  • 3 Contributors
  • 7 Replies
  • 129 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by peter_budo
Member Avatar for pritaeas

You can use mysqldump. You can find examples in this site.

Member Avatar for Samyx

I tried but it gave me the error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ...

Member Avatar for pritaeas

I tried but it gave me the error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ...

Can you post what you did ?

Member Avatar for Samyx 
mysqldump -u root -p mypassword assignment2 > /C:/Users/Samara/Desktop/HW1.sql
Member Avatar for peter_budo

If you let MySQL register its PATH on install you can run dump from any location in your pc, if you did not do so you need to run dump from MySQL installation folder. Point of this is that you do not need to give absolute path to save the SQL file. Your dump command is almost correct beside that slash in front of of C hard drive

mysqldump -u root -p mypassword assignment2 > C:/Users/Samara/Desktop/HW1.sql

but I would prefer it as

mysqldump -u root -p mypassword assignment2 > HW1.sql

this will create HW1.sql in directory from which at that point you calling dump command

Member Avatar for Samyx

I am still getting the same error msg :/

Member Avatar for peter_budo

Strange, try this there is virtually no difference just after executing you need to provide password.

mysqldump -u root assignment2 > HW1.sql -p

If this doesn't work try to install MySQL GUI Tools which unlike phpMyAdmin do not need PHP on your pc. Through Administrator you set up connection and then use Query Browser

Edited by peter_budo because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.