bmews — 2011-02-22T20:53:10-05:00 — #1
I am doing a project for school and we need to create a html website using PHP to communicate with a relational database (MySQL) and host it online. It is a website project that has to make use of a relational database. So far I am creating it with Apache + PHP + MySQL + basic html on my own local machine WinXP localhost and it works out..
The steps in the book demonstrate on how to create a database and table manually. But I have a bunch of .sql creates/loads/and inserts in .sql (text) format read to go and don't want to manually type all that in from the command line. How can I bulk import all this directly into my MySQL engine so I can move on and start with the html/php stuff? I figured out how to use the workbench to draw the ERD models, but it exports into a bunch of .sql code/text and I still have to find a way to actually insert it into the InnoDB.
r937 — 2011-02-22T22:40:19-05:00 — #2
i don't do command line stuff, but i believe it's as simple as pointing to the .sql file --
shell> mysql db_name < script.sql
ralphm — 2011-02-23T00:21:44-05:00 — #3
Thread moved to appropriate forum.