Changes between Version 1 and Version 2 of SqLiteToMySql

Timestamp:

Jan 2, 2007, 11:59:48 AM (17 years ago)

Author:

anonymous

Comment:

a little suggestion for automation of sql structure cleaning

SqLiteToMySql

@@ -14 +14 @@
  3. Use sqlite .dump to dump the structure + data from sqlite into trac.sqlite.sql (unfortunately there's no option to only dump the data).
  4. Remove all the structure ('create table' and 'create index') from trac.sqlite.sql
- 5. Concatenate trac.mysql.sql and trac.sqlite.sql into trac.sql
+    You could use this simple perl script:
+    {{{
+$ cat cleansql
+#!/usr/bin/env perl
 
+while (<>) {
+  $i = $i . $_;
+}
+
+$i =~ s/^CREATE.*?\);$//smgi;
+
+print $i;
+
+# NEOF
+
+$ ./cleansql trac.sqlite.sql >  trac.sqlite.sql.dataonly
+    }}}
+ 5. Concatenate trac.mysql.sql and trac.sqlite.sql.dataonly into trac.sql
+    {{{
+cat trac.mysql.sql trac.sqlite.sql.dataonly > trac.sql  
+    }}}