Hello i am trying to export data from a specific innodb table on a myql prod server (MySQL 5.1.68_community Server). The table need to be unloaded to a .csv format
There is that method i found online:
SELECT * FROM orders
INTO OUTFILE '/tmp/orders.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ';' ESCAPED BY '"' LINES TERMINATED BY '\r\n';
My questions would be the following:
- Could that method generate some data integrity issue if it is executed while the server is still running? (the estimated size of the table is around 4G)
- Is it possible to do the exact same type of extraction using the command mysqldump?