Populating the Auction House

# first we tell it to use the right database
USE dspdb;
# clear out the contents of the AH
DELETE FROM auction_house;
# reset the auto increment thingy
ALTER TABLE action_house AUTO_INCREMENT=1;
# import the file
LOAD DATA INFILE '/var/lib/mysql-files/ah.csv' INTO TABLE auction_house FIELDS TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES;
# TADA! Should have worked. Verify a few (100) of them with:
SELECT * FROM auction_house LIMIT 100;