Batch FIle to create database

[kellan4459]

I am trying to create a batch file to create a database and populate it with create table statements. I can't figure out why it will not create the database and load the tables. I have the following in my batch file

/mysql/bin/mysql.exe -vvv -u root -pcs3911 < C:\mySql\test.txt

and the following is my test.txt file

CREATE DATABASE 'lovettsite';


CREATE TABLE `applications` (
`username` varchar(255) NOT NULL default '',
`firstname` varchar(255) NOT NULL default '',
`middlename` varchar(255) NOT NULL default '',
`lastname` varchar(255) NOT NULL default '',
`current_address_line_1` varchar(255) NOT NULL default '',
`current_address_line_2` varchar(255) NOT NULL default '',
`current_city_town` varchar(255) NOT NULL default '',
`current_state_province` varchar(255) NOT NULL default '',
`current_zip_code` varchar(16) NOT NULL default '',
`permanent_address_line_1` varchar(255) NOT NULL default '',
`permanent_address_line_2` varchar(255) NOT NULL default '',
`permanent_city_town` varchar(255) NOT NULL default '',
`permanent_state_province` varchar(255) NOT NULL default '',
`permanent_zip_code` varchar(16) NOT NULL default '',
`email_address` varchar(255) NOT NULL default '',
`home_phone` varchar(255) NOT NULL default '',
`business_phone` varchar(255) NOT NULL default '',
`mobile_phone` varchar(255) NOT NULL default '',
`citizenship_status` varchar(255) NOT NULL default '',
`citizenship_description` varchar(255) NOT NULL default '',
`visa_other` varchar(255) NOT NULL default '',
`convicted_of_crime` varchar(4) NOT NULL default '',
`crime_description` longtext NOT NULL,
`teaching_position` varchar(255) NOT NULL default '',
`date_available_month` varchar(255) NOT NULL default '',
`date_available_day` varchar(255) NOT NULL default '',
`date_available_year` varchar(255) NOT NULL default '',
`certificate_subject` varchar(255) NOT NULL default '',
`certificate_state` varchar(255) NOT NULL default '',
`certificate_year` varchar(255) NOT NULL default '',
`certificate_experation_month` varchar(255) NOT NULL default '',
`certificate_experation_date` varchar(255) NOT NULL default '',
`certificate_experation_year` varchar(255) NOT NULL default '',
`total_years_teaching` int(11) default NULL,
`under_contract` varchar(255) NOT NULL default '',
`current_salary` varchar(255) NOT NULL default '',
`contact_current_employer` varchar(255) NOT NULL default '',
`computer_skills` longtext NOT NULL,
`extra_activities_proficient` varchar(255) NOT NULL default '',
`extra_activities_assist` varchar(255) NOT NULL default '',
`extra_activities_proficient_other` varchar(255) NOT NULL default '',
`extra_activities_assist_other` varchar(255) NOT NULL default '',
`personal_interests` longtext NOT NULL,
`workshops` longtext NOT NULL,
`reading` longtext NOT NULL,
`professional_organization` longtext NOT NULL,
`publications` longtext NOT NULL,
`honors` longtext NOT NULL,
`civic_activities` longtext NOT NULL,
`personal_statement` longtext NOT NULL,
`signature` varchar(255) NOT NULL default '',
`signature_date` varchar(255) NOT NULL default '',
`source` varchar(255) NOT NULL default '',
`rating` varchar(255) NOT NULL default '',
`initially_submitted` varchar(255) NOT NULL default '',
`recent_update` timestamp NOT NULL default CURRENT_TIMESTAMP on update

CURRENT_TIMESTAMP,
`association` varchar(255) NOT NULL default '',
`status` varchar(255) NOT NULL default '',
`activated` varchar(5) NOT NULL default 'undef',
`school_preference_1` varchar(255) NOT NULL default '',
`school_preference_2` varchar(255) NOT NULL default '',
`school_preference_3` varchar(255) NOT NULL default '',
`subject_preference_1` varchar(255) NOT NULL default '',
`subject_preference_2` varchar(255) NOT NULL default '',
`subject_preference_3` varchar(255) NOT NULL default '',
`subject_preference_4` varchar(255) NOT NULL default '',
`gender` varchar(255) NOT NULL default '',
`ethnicity` varchar(255) NOT NULL default '',
`extra` longtext NOT NULL,
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;







CREATE TABLE `athletics` (
`username` varchar(20) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`number` varchar(255) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;









CREATE TABLE `comments` (
`id` bigint(20) NOT NULL auto_increment,
`applicant` varchar(20) NOT NULL default '',
`reviewer` varchar(20) NOT NULL default '',
`type` varchar(100) NOT NULL default '',
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`comment` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;







CREATE TABLE `contact_log` (
`id` bigint(20) NOT NULL auto_increment,
`applicant` varchar(20) NOT NULL default '',
`reviewer` varchar(20) NOT NULL default '',
`date` varchar(255) NOT NULL default '',
`time` varchar(255) NOT NULL default '',
`comment` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;







CREATE TABLE `courses` (
`username` varchar(255) NOT NULL default '',
`course_name` varchar(255) NOT NULL default '',
`number_of_hours` varchar(255) NOT NULL default '',
`hours_type` varchar(255) NOT NULL default '',
`grade` varchar(255) NOT NULL default '',
`number` int(11) NOT NULL default '0',
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;








CREATE TABLE `customs` (
`name` varchar(255) NOT NULL default '',
`text` longtext NOT NULL,
`function` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;







CREATE TABLE `documents` (
`id` bigint(20) NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`document` longblob,
`label` varchar(255) NOT NULL default '',
`filesize` int(11) default NULL,
`filetype` varchar(255) default NULL,
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;






CREATE TABLE `education` (
`id` bigint(20) NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`college_name` varchar(255) NOT NULL default '',
`college_city` varchar(255) NOT NULL default '',
`college_state` varchar(255) NOT NULL default '',
`college_country` varchar(255) NOT NULL default '',
`degree_level` varchar(255) NOT NULL default '',
`completion_date_month` varchar(255) NOT NULL default '',
`completion_date_year` varchar(255) NOT NULL default '',
`major` varchar(255) NOT NULL default '',
`minor` varchar(255) NOT NULL default '',
`gpa_attained` varchar(255) NOT NULL default '',
`max_gpa` varchar(255) NOT NULL default '',
`total_credits_in_major` varchar(255) NOT NULL default '',
`grad_degree_concentration` varchar(255) NOT NULL default '',
`thesis_topic` varchar(255) NOT NULL default '',
`start_date_month` varchar(255) NOT NULL default '',
`start_date_year` varchar(255) NOT NULL default '',
`major_credit_type` varchar(255) NOT NULL default '',
`total_credits_minor` varchar(255) NOT NULL default '',
`minor_credit_type` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;







CREATE TABLE `extracurriculars` (
`username` varchar(255) NOT NULL default '',
`extracurricular` varchar(255) NOT NULL default '',
`response` varchar(255) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `file_log` (
`id` bigint(20) NOT NULL auto_increment,
`applicant` varchar(20) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`date` varchar(255) NOT NULL default '',
`storage` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;







CREATE TABLE `lovett_ip` (
`id` int(11) NOT NULL auto_increment,
`ip_addr_1` varchar(255) NOT NULL default '',
`ip_addr_2` varchar(255) NOT NULL default '',
`ip_addr_3` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;





CREATE TABLE `references` (
`id` bigint(20) NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`address_1` varchar(255) NOT NULL default '',
`phone` varchar(255) NOT NULL default '',
`address_2` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`state` varchar(255) NOT NULL default '',
`country` varchar(255) NOT NULL default '',
`relationship` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '',
`company` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;





CREATE TABLE `routing` (
`id` bigint(20) NOT NULL auto_increment,
`applicant` varchar(20) NOT NULL default '',
`reviewer` varchar(20) NOT NULL default '',
`status` varchar(20) default NULL,
`subject` varchar(100) default NULL,
`last_viewed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;






CREATE TABLE `teaching_experience` (
`id` bigint(20) NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`school_name` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`state` varchar(255) NOT NULL default '',
`country` varchar(255) NOT NULL default '',
`start_date_month` varchar(255) NOT NULL default '',
`start_date_year` varchar(255) NOT NULL default '',
`end_date_month` varchar(255) NOT NULL default '',
`end_date_year` varchar(255) NOT NULL default '',
`leaving_reason` longtext NOT NULL,
`subject_1` varchar(255) NOT NULL default '',
`subject_2` varchar(255) NOT NULL default '',
`subject_3` varchar(255) NOT NULL default '',
`sport_1` varchar(255) NOT NULL default '',
`sport_2` varchar(255) NOT NULL default '',
`sport_3` varchar(255) NOT NULL default '',
`salary` varchar(255) NOT NULL default '',
`under_contract` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;





CREATE TABLE `users` (
`username` varchar(20) NOT NULL default '',
`password` varchar(255) NOT NULL default '',
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`type` varchar(20) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`flags` varchar(255) NOT NULL default '',
PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;





CREATE TABLE `work_experience` (
`id` bigint(20) NOT NULL auto_increment,
`username` varchar(20) NOT NULL default '',
`employer_name` varchar(255) NOT NULL default '',
`city` varchar(255) NOT NULL default '',
`state` varchar(255) NOT NULL default '',
`country` varchar(255) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`start_date_month` varchar(255) NOT NULL default '',
`start_date_year` varchar(255) NOT NULL default '',
`end_date_month` varchar(255) NOT NULL default '',
`end_date_year` varchar(255) NOT NULL default '',
`leaving_reason` longtext NOT NULL,
`salary` varchar(255) NOT NULL default '',
`currently_employed` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;


INSERT INTO `users` VALUES ('admin', '$1$Cz/.jv5.$lFiqjJ2LhAqV1Df7atDMv1', '2005-04-28

09:40:47', 'admin', 'jason.hurley@cc.gatech.edu', 'yes');

 

[TonyGroves]

You need to remove the apostrophes from the first line, giving:[tt]
CREATE DATABASE lovettsite;[/tt]
Then specify:[tt]
USE lovettsite;[/tt]