Google Cloud SQL:LOAD DATA INFILE的替代方法 [英] Google Cloud SQL: Alternative to LOAD DATA INFILE

问题描述

我正在Google App Engine中工作，我们有一个Python脚本可以在Google Cloud SQL中转储数据.我们必须转储的数据集之一是巨大的.我们每天一次转储约15万行数据.

I am working in Google App Engine and we have a Python script that dumps data in Google Cloud SQL. One of the data sets we have to dump is huge. We dump around 150K rows of data once a day daily.

我知道Google Cloud SQL不支持我通常会使用的LOAD DATA INFILE.我的问题是，是否可以使用LOAD DATA INFILE的替代方法来加快数据转储的过程.

I know Google Cloud SQL does not support LOAD DATA INFILE, which I would have normally used. My question is, whether there is an alternative to LOAD DATA INFILE that I can use to speed up the process of data dumping.

在没有LOAD DATA INFILE的情况下正常插入数据大约需要5分钟.

Inserting the data normally, without LOAD DATA INFILE, takes about 5 minutes.

推荐答案

As stated in this comment of another question, LOAD DATA LOCAL INFILE is supported by App Engine.

MySQL手册解释了如何使用此语句.

The MySQL Manual explains on how to use this statement.

这篇关于Google Cloud SQL:LOAD DATA INFILE的替代方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！