Unix Technical Forum

creating DB using script

This is a discussion on creating DB using script within the MySQL General forum forums, part of the MySQL category; --> i host several web forums on a home based server using windows 2000 server. im attempting to switch over ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 06:22 AM
Nathan W. Collier
 
Posts: n/a
Default creating DB using script

i host several web forums on a home based server using windows 2000 server.
im attempting to switch over from MS access to mysql for .asp based web
forums. the particular software that im looking at offers a script to
create the forum mysql DB, but i dont know what to do with the script. here
is a small sample of nearly 1000 lines of script:

CREATE TABLE `album-tool-variables` (
`motd` text NOT NULL,
`currentver` float NOT NULL default '0',
`upgradelocation` varchar(100) NOT NULL default ''
) ;

CREATE TABLE `albumnotifications` (
`albumid` int(11) default NULL,
`memberid` int(11) NOT NULL default '0'
) ;

im new to mysql and learning it as i go along. ive installed the current
5.0X from mysql.com as well as sqlyog from webyog.com. im able to create
DBs with sqlyog, but i dont know how to use the script in the DB. any help
would be appreciated.

--
Nathan In Montana
http://ConcealedCarryForum.com
http://1911Talk.com
http://GlockCarry.com


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:28 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com