Select Categories Below
Status: Closed Points: 125 Time: 08:55 - Dec 12, 2006
john2
I am trying to install and open source forum program and not really sure where to start. The directions are telling me to: "Next, run the install.sql file in either SQL 2000, Access, or MySQL for Windows. Set up appropriate username/password permissions for access to the tables." But when I try to open the install.sql file in Access it just tells me it doesnt support that file type. Help.
Categories:
Add Categories
When adding more than one category, separate them with commas.
Advertisement
xarcus
Date:: Dec 12, 2006
Time:: 14:32
You can't generate your tables from an sql file in MSAccess. In MSAccess you have the ExecuteSQL action in "macros" where you can write a 256 characters limited SQL String. You need the pricey SQL Server to generate your tables from an sql file with MS stuff. An alternative way to work with Access is: create a MySql database with it create a Windows database source for it : Control panel -> Administrative tools -> Data sources (ODBC) and then from Access create a database and through the File menu -> Get External Data ->set links to the MySql tables
Date:: Dec 13, 2006
Time:: 02:52
Gotcha, I dont really have a ton of knowledge with the server side languages and database work, so I pulled an open source tool for a forum off the web hoping that it would be easy to implement. All I had on my computer is Access so I may just look for another resource. Thanks.
Time:: 02:54
What software do you need to create a MySql database?
Time:: 03:39
Is that a stupid question? I'm guessing that a MySql database is created in MySql... Dont really know. Is there any easy way to accomplish this for somebody who doesn't have a clue about creating/linking/manipulating databases? I'm in the "learning phase" of the server side stuff. Most of my experience is for design.
Time:: 04:32
Just try and find out. After installing MySQL, open "MySql Administrator" click on Restore and specify your sql file. if it failed because of database was not defined in the sql file, follow this link instructions http://dev.mysql.com/doc/world-setup/en/...
Time:: 05:26
I didnt realize that MySql cost so much money. Think I may just skip out on this one, cant really invest that much at this point.
dustPuppy
Time:: 05:42
as far as i know, you can get MySQL for free. You need to download the database engine to run on your computer and then f.ex. the mysqladmin, which is a web interface to administrate the database. Both might not be easy for you to install, but that should work... and for free.
Time:: 05:58
I have MS enterprise on my computer, will that work at a "database engine"? Also, where can I get mysqladmin? James
admin
Date:: Jun 04, 2007
Time:: 11:37
john2, please close this question and distribute the points. If you didn't get a solution to your problem or you found it yourself, please leave a comment here to let the experts know. Thanks, Quomon Admin
Question Answered
This question has been closed, and points have been rewarded to the following experts:
You're welcome however to comment or give additional information or if you wish, you have the ability to write an Answer Summary for the Summary Area.
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
Opening file with .sql extension
You have 100 characters to use
Rank
Expert
Points
1.
315
2.
160
3.
125
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software Real Estate Postcards Marketing Fulfillment