This could help you : If you want to do it manually (if you dataset is not so big and you can rapidly check the data integrity) : http://sqlite.phxsoftware.com/forums/p/941/4725.aspx Not recommended
Or "automatically" first answer: http://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql The DAL should help you doing just that. Also, I remember having seen mail about UUID on the group that were talking about this problem. Can't find the thread back and my memory may tricks me :) Hope it helps Richard On Fri, Oct 12, 2012 at 3:14 PM, Hassan Alnatour <[email protected] > wrote: > Dear Richerd , > > am moving my database from sqlite to mysql, what is the best way ? and > keeping the ids the same > > regards, > > > > On Friday, October 12, 2012 9:44:59 PM UTC+3, Richard wrote: > >> Depending of your backend, for example with postgres : >> >> pg_dump --attribute-inserts --file=/**whereYouWantToPutTheFile/"** >> dbName_with_inserts_commands_**and_blobs_dump_"`date >> +"%Y-%m-%d_%H-%M-%S"`".gz" --compress=9 --role=roleName --username=postgres >> dbName >> >> From the command line. >> >> Or you may also use pgAdmin. >> >> Once you have the file you can just open it (depend how big is you >> database) or pg_restore it (if to big to open it in a editor). >> >> >> Richard >> >> On Wed, Oct 10, 2012 at 3:00 AM, hasan alnator <[email protected] >> > wrote: >> >>> Dear Simon, >>> >>> What i use the ids in my tables so the ids changed , who can i export >>> and import data in backup/restore mechanism as you said above ? >>> >>> can you give me an example ? >>> >>> regards, >>> >>> On Wed, Oct 10, 2012 at 1:58 AM, hasan alnator < >>> [email protected]> wrote: >>> >>>> Dear Massimo, >>>> >>>> i have web2py >>>> Version 1.99.4 (2011-12-14 14:46:14) stable >>>> >>>> i opend the dal.py and this is what i have in there : >>>> >>>> def import_from_csv_file(self, ifile, id_map=None, null='<NULL>', >>>> unique='uuid', *args, **kwargs): >>>> if id_map is None: id_map={} >>>> for line in ifile: >>>> line = line.strip() >>>> if not line: >>>> continue >>>> elif line == 'END': >>>> return >>>> elif not line.startswith('TABLE ') or not line[6:] in >>>> self.tables: >>>> raise SyntaxError, 'invalid file format' >>>> else: >>>> tablename = line[6:] >>>> self[tablename].import_from_**csv_file(ifile, id_map, >>>> null, >>>> unique, *args, >>>> **kwargs) >>>> >>>> >>>> >>>> Regards, >>>> >>>>> >>>>> -- >>>>> >>>>> >>>>> >>>>> >>>> >>> -- >>> >>> >>> >>> >> >> -- > > > > --
