|
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;
__________________
hard core redditor
|