converting from mysql to sqlite
Ulin the Tech Mage
ulinthetechmage at hit-techs.com
Mon Aug 4 15:42:04 UTC 2008
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: iq-sample.sql
Type: text/x-vhdl
Size: 6693 bytes
Desc: not available
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20080804/23b62ffa/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: conv.sh
Type: application/x-shellscript
Size: 355 bytes
Desc: not available
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20080804/23b62ffa/attachment-0001.bin>
More information about the ubuntu-users
mailing list