Exporting the project

1 view
Skip to first unread message

Brian McMahon

unread,
Dec 3, 2011, 7:08:11 PM12/3/11
to CPSC410-2011
My team is using a mysql database for our project. How would we export
that database with the project so you wouldn't have to make the
database manually before you try to run it.

Eric Wohlstadter

unread,
Dec 3, 2011, 10:12:37 PM12/3/11
to cpsc41...@googlegroups.com
You can use this command for mysql from a console window (e.g. cmd in Windows).

mysqldump --opt --user=USERNAME --password=PASSWORD DATABASE_NAME > db.sql

Eric

Brian McMahon

unread,
Dec 3, 2011, 11:22:41 PM12/3/11
to cpsc41...@googlegroups.com
I typed that in the window command line and it didn't work. Also, how would I make it so that when the marker imports the project the database gets made if it isn't already? I have a function to make it but it requires having the mysql server installed on the computer and knowing the username and password of the server. should I just make a note to change the username and password in the create function when the marker imports the project?

Eric Wohlstadter

unread,
Dec 3, 2011, 11:48:33 PM12/3/11
to cpsc41...@googlegroups.com
You might need to add the mysql executables to your PATH environment variable:
on Windows: Control Panels->System->Advanced System
Settings->Environment Variables...

For example, on my machine, the mysql executables are at C:\Program
Files\MySQL\MySQL Server 5.1\bin

> should I just make a note to change the username and password
> in the create function when the marker imports the project?

Yeah, that would be fine.

Eric

Reply all
Reply to author
Forward
0 new messages