Originally Posted by carolwebb

Can you dump the old table info into a csv file, then upload the csv to the new database table?

Like so?
SELECT customer_id, firstname, surname INTO OUTFILE '/customers.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM customers;


LOAD DATA INFILE '/customers.csv'
INTO TABLE customers
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;