mysql数据导入到sqlite3中，数据导入sqlite3,家里的路由器没有mysq

mysql数据导入到sqlite3中，数据导入sqlite3,家里的路由器没有mysq

家里的路由器没有mysql数据库，但是能支持sqlite3，所以要把一些数据做个数据库迁移

#!/bin/env python#coding:utf-8import os,time,statimport webmydb = web.database(dbn='mysql', db='db', user='user', pw='password',host='localhost')sqldb = web.database(dbn='sqlite', db='./db.db' )mydb.printing = Falsesqldb.printing = Falseprint 'aa'for tab in ['t_content', 't_tag', 't_content_tag']:    print tab ,     offset = 0    limit = 1000    while 1:        print offset        data = mydb.select( tab, limit = limit, offset = offset )        data_list = data.list()        if not data_list:            break        offset = offset + limit        sqldb.multiple_insert( tab, data_list )    print 'Done'#该片段来自于http://byrx.net