converting from mysql to sqlite

Mon Aug 4 16:14:43 UTC 2008

If you've gog PHPmyAdmin, export the database (with full export of data)
Go into the SQL-Lite manager and import the file you dumped. It should work,
with the possible exception of removing the commentary at the header of the
dump file...

Jack

On Mon, Aug 4, 2008 at 11:42 AM, Ulin the Tech Mage <
ulinthetechmage at hit-techs.com> wrote:

> anyone know of a good way to convert from mysql to sqlite.  I have been
> running into alot of closed doors attached is a copy of my sql file  and
> a copy of the converter script
>
>
> output:
> ./conv.sh iq-sample
> Enter password:
> SQL error near line 2: near "SET": syntax error
> SQL error near line 3: near "SET": syntax error
> SQL error near line 4: near "auto_increment": syntax error
> SQL error near line 12: near "SET": syntax error
> SQL error near line 13: no such table: page43_1
> SQL error near line 14: no such table: page43_1
> SQL error near line 15: no such table: page43_1
> SQL error near line 16: no such table: page43_1
> SQL error near line 17: no such table: page43_1
> SQL error near line 18: no such table: page43_1
> SQL error near line 19: no such table: page43_1
> SQL error near line 20: no such table: page43_1
> SQL error near line 21: no such table: page43_1
> SQL error near line 22: no such table: page43_1
> SQL error near line 23: no such table: page43_1
> SQL error near line 24: no such table: page43_1
> SQL error near line 25: no such table: page43_1
> SQL error near line 26: no such table: page43_1
> SQL error near line 27: no such table: page43_1
> SQL error near line 28: no such table: page43_1
> SQL error near line 29: no such table: page43_1
> SQL error near line 30: no such table: page43_1
> SQL error near line 31: no such table: page43_1
> SQL error near line 32: no such table: page43_1
> SQL error near line 33: near "SET": syntax error
> SQL error near line 34: near "SET": syntax error
> SQL error near line 35: near "auto_increment": syntax error
> SQL error near line 43: near "SET": syntax error
> SQL error near line 44: no such table: page43_2
> SQL error near line 45: no such table: page43_2
> SQL error near line 46: no such table: page43_2
> SQL error near line 47: no such table: page43_2
> SQL error near line 48: no such table: page43_2
> SQL error near line 49: no such table: page43_2
> SQL error near line 50: no such table: page43_2
> SQL error near line 51: no such table: page43_2
> SQL error near line 52: no such table: page43_2
> SQL error near line 53: near "SET": syntax error
> SQL error near line 54: near "SET": syntax error
> SQL error near line 60: near "SET": syntax error
> SQL error near line 70: near "SET": syntax error
> SQL error near line 71: near "SET": syntax error
> SQL error near line 72: near "auto_increment": syntax error
> SQL error near line 77: near "SET": syntax error
> SQL error near line 78: no such table: page48
> SQL error near line 79: no such table: page48
> SQL error near line 80: no such table: page48
> SQL error near line 81: no such table: page48
> SQL error near line 82: no such table: page48
> SQL error near line 83: no such table: page48
> SQL error near line 84: no such table: page48
> SQL error near line 85: no such table: page48
> SQL error near line 86: no such table: page48
> SQL error near line 87: no such table: page48
> SQL error near line 88: no such table: page48
> SQL error near line 89: no such table: page48
> SQL error near line 90: near "SET": syntax error
> SQL error near line 91: near "SET": syntax error
> SQL error near line 92: near "auto_increment": syntax error
> SQL error near line 101: near "SET": syntax error
> SQL error near line 102: no such table: page52_1
> SQL error near line 103: no such table: page52_1
> SQL error near line 104: no such table: page52_1
> SQL error near line 105: no such table: page52_1
> SQL error near line 106: no such table: page52_1
> SQL error near line 107: no such table: page52_1
> SQL error near line 108: no such table: page52_1
> SQL error near line 109: no such table: page52_1
> SQL error near line 110: no such table: page52_1
> SQL error near line 111: no such table: page52_1
> SQL error near line 112: no such table: page52_1
> SQL error near line 113: no such table: page52_1
> SQL error near line 114: no such table: page52_1
> SQL error near line 115: no such table: page52_1
> SQL error near line 116: no such table: page52_1
> SQL error near line 117: no such table: page52_1
> SQL error near line 118: no such table: page52_1
> SQL error near line 119: no such table: page52_1
> SQL error near line 120: no such table: page52_1
> SQL error near line 121: no such table: page52_1
> SQL error near line 122: near "SET": syntax error
> SQL error near line 123: near "SET": syntax error
> SQL error near line 124: near "auto_increment": syntax error
> SQL error near line 135: near "SET": syntax error
> SQL error near line 136: no such table: page53_1
> SQL error near line 137: no such table: page53_1
> SQL error near line 138: no such table: page53_1
> SQL error near line 139: no such table: page53_1
> SQL error near line 140: no such table: page53_1
> SQL error near line 141: no such table: page53_1
> SQL error near line 142: no such table: page53_1
> SQL error near line 143: no such table: page53_1
> SQL error near line 144: no such table: page53_1
> SQL error near line 145: no such table: page53_1
> SQL error near line 146: no such table: page53_1
> SQL error near line 147: no such table: page53_1
> SQL error near line 148: no such table: page53_1
> SQL error near line 149: no such table: page53_1
> SQL error near line 150: no such table: page53_1
> SQL error near line 151: no such table: page53_1
> SQL error near line 152: no such table: page53_1
> SQL error near line 153: no such table: page53_1
> SQL error near line 154: no such table: page53_1
> SQL error near line 155: no such table: page53_1
> SQL error near line 156: no such table: page53_1
> SQL error near line 157: no such table: page53_1
> SQL error near line 158: no such table: page53_1
> SQL error near line 159: no such table: page53_1
> SQL error near line 160: near "SET": syntax error
> SQL error near line 161: near "SET": syntax error
> SQL error near line 162: near "auto_increment": syntax error
> SQL error near line 167: near "SET": syntax error
> SQL error near line 168: no such table: page54_1
> SQL error near line 169: no such table: page54_1
> SQL error near line 170: no such table: page54_1
> SQL error near line 171: no such table: page54_1
> SQL error near line 172: no such table: page54_1
> SQL error near line 173: no such table: page54_1
> SQL error near line 174: no such table: page54_1
> SQL error near line 175: no such table: page54_1
> SQL error near line 176: no such table: page54_1
> SQL error near line 177: no such table: page54_1
> SQL error near line 178: no such table: page54_1
> SQL error near line 179: no such table: page54_1
> SQL error near line 180: no such table: page54_1
> SQL error near line 181: no such table: page54_1
> SQL error near line 182: no such table: page54_1
> SQL error near line 183: near "SET": syntax error
> SQL error near line 184: near "SET": syntax error
> SQL error near line 185: near "auto_increment": syntax error
> SQL error near line 194: near "SET": syntax error
> SQL error near line 195: no such table: page54_2
> SQL error near line 196: no such table: page54_2
> SQL error near line 197: no such table: page54_2
> SQL error near line 198: no such table: page54_2
> SQL error near line 199: no such table: page54_2
> SQL error near line 200: no such table: page54_2
> SQL error near line 201: no such table: page54_2
> SQL error near line 202: no such table: page54_2
> SQL error near line 203: no such table: page54_2
> SQL error near line 204: no such table: page54_2
>
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20080804/54428776/attachment.html>