converting from mysql to sqlite
Ulin the Tech Mage
ulinthetechmage at hit-techs.com
Mon Aug 4 16:31:31 UTC 2008
i tried that, gives me a weird syntax error:
near "SET": syntax error
On Mon, 2008-08-04 at 12:14 -0400, Verde Denim wrote:
> 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
>
>
>
More information about the ubuntu-users
mailing list