I have an SQL dumpfile that was converted from access. It looks basically like a SQL script (see below). Does anyone know how I can load this, or run this from the mysql command line?

Thanks,

pat pawlowski


DROP TABLE IF EXISTS `cat_index`;
CREATE TABLE `cat_index` (
`cat_index_id` INT NOT NULL AUTO_INCREMENT,
`cat_id` INT NOT NULL DEFAULT 0,
`sub_cat_id` INT NOT NULL DEFAULT 0,
`sub_cat_sort` INT DEFAULT 20,
INDEX `cat_id` (`cat_id`),
INDEX `cat_index_id` (`cat_index_id`),
PRIMARY KEY `PrimaryKey` (`cat_index_id`),
INDEX `sub_cat_id` (`sub_cat_id`)
);

#
# Dumping data for table 'cat_index'
#

LOCK TABLES `cat_index` WRITE;
INSERT INTO `cat_index` VALUES(40, 2, 1, 1);
INSERT INTO `cat_index` VALUES(41, 2, 2, 2);
INSERT INTO `cat_index` VALUES(42, 2, 3, 5);
INSERT INTO `cat_index` VALUES(44, 2, 5, 8);
INSERT INTO `cat_index` VALUES(45, 2, 6, 7);
INSERT INTO `cat_index` VALUES(48, 3, 8, 1);

The following should work:

mysql -u username -p database_name < filename

If you don't use passwords, drop the "-p" option.

Worked like a charm. I wish I could solve all my computer questions that easily.