SET GLOBAL local_infile = 'ON';
USE my_guitar_shop;


LOAD DATA LOCAL INFILE '/Users/kevintrainor/trainor_kevin_dump_restore_load_database/administrators.csv'
INTO TABLE administrators
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/trainor_kevin_dump_restore_load_database/categories.csv'
INTO TABLE categories
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/trainor_kevin_dump_restore_load_database/products.csv'
INTO TABLE products
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/trainor_kevin_dump_restore_load_database/customers.csv'
INTO TABLE customers
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/trainor_kevin_dump_restore_load_database/addresses.csv'
INTO TABLE addresses
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/trainor_kevin_dump_restore_load_database/orders.csv'
INTO TABLE orders
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;

LOAD DATA LOCAL INFILE '/Users/kevintrainor/trainor_kevin_dump_restore_load_database/order_items.csv'
INTO TABLE order_items
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
IGNORE 1 LINES;
