MySQL Question

running 8mb of sql code in wamp?

i have about 8mb of sql code i need to run. it looks like this:

/*
MySQL Data Transfer
Source Host: 10.0.0.5
Source Database: jnetdata
Target Host: 10.0.0.5
Target Database: jnetdata
Date: 5/26/2009 12:27:33 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for chavrusas
-- ----------------------------
CREATE TABLE `chavrusas` (
`id` int(11) NOT NULL auto_increment,
`date_created` datetime default NULL,
`luser_id` int(11) default NULL,
`ruser_id` int(11) default NULL,
`luser_type` varchar(50) default NULL,
`ruser_type` varchar(50) default NULL,
`SessionDay` varchar(250) default NULL,
`SessionTime` datetime default NULL,
`WeeklyReminder` tinyint(1) NOT NULL default '0',
`reminder_phone` tinyint(1) NOT NULL default '0',
`calling_card` varchar(50) default NULL,
`active` tinyint(1) NOT NULL default '0',
`notes` mediumtext,
`ended` tinyint(1) NOT NULL default '0',
`end_date` datetime default NULL,
`initiated_by_student` tinyint(1) NOT NULL default '0',
`initiated_by_volunteer` tinyint(1) NOT NULL default '0',
`student_general_reason` varchar(50) default NULL,
`volunteer_general_reason` varchar(50) default NULL,
`student_reason` varchar(250) default NULL,
`volunteer_reason` varchar(250) default NULL,
`student_nli` tinyint(1) NOT NULL default '0',
`volunteer_nli` tinyint(1) NOT NULL default '0',
`jnet_initiated` tinyint(1) default '0',
`belongs_to` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5913 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for tbluseravailability
-- ----------------------------
CREATE TABLE `tbluseravailability` (
`availability_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL,
`weekday_id` int(11) NOT NULL,
`timeslot_id` int(11) NOT NULL,
PRIMARY KEY (`availability_id`)
) ENGINE=MyISAM AUTO_INCREMENT=10865 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for tblusers
-- ----------------------------
CREATE TABLE `tblusers` (
`id` int(11) NOT NULL auto_increment,
`


etc

how do i run it on http://www.wampserver.com/en/download.php

Answer

Find the mysql.exe in your wamp installation, then run

 mysql.exe -u username -p password database < textfile.sql
Comments