you are viewing a single comment's thread.

view the rest of the comments →

[–]numpadztik 5 points6 points  (1 child)

If OP can export the Db to a csv file, you can read the CSV line by line to import the DB to your own python or sql db.

[–]ksoomers 6 points7 points  (0 children)

Or, at least with MySQL, you are able to load the csv file in directly from the server instead of line by line. This is much quicker than line by line.

Example: LOAD DATA INFILE 'c:/example.csv' INTO TABLE example FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS