FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Ubuntu > Ubuntu User

 
 
LinkBack Thread Tools
 
Old 08-04-2008, 03:42 PM
Ulin the Tech Mage
 
Default converting from mysql to sqlite

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@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 04:14 PM
"Verde Denim"
 
Default converting from mysql to sqlite

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@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@lists.ubuntu.com

Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users




--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 04:27 PM
Derek Broughton
 
Default converting from mysql to sqlite

Please don't top post.

Greenjeans 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@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

It sure looks like he _did_ use PHPmyAdmin.

When converting between SQL databases, you normally need to restrict
yourself to ANSI SQL to keep compatibility.

1) SET statements are not ANSI SQL so you can't expect them to work.
2) Do either "CREATE TABLE IF NOT EXISTS" or "ENGINE=MyISAM" exist in
SQLlite? They're non standard. You should be able to remove all of those
clauses.
--
derek


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 04:31 PM
Ulin the Tech Mage
 
Default converting from mysql to sqlite

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@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@lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
>
>
>


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 04:37 PM
Ulin the Tech Mage
 
Default converting from mysql to sqlite

On Mon, 2008-08-04 at 13:27 -0300, Derek Broughton wrote:
> Please don't top post.
>
> Greenjeans 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@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
>
> It sure looks like he _did_ use PHPmyAdmin.
>
> When converting between SQL databases, you normally need to restrict
> yourself to ANSI SQL to keep compatibility.
>
> 1) SET statements are not ANSI SQL so you can't expect them to work.
> 2) Do either "CREATE TABLE IF NOT EXISTS" or "ENGINE=MyISAM" exist in
> SQLlite? They're non standard. You should be able to remove all of those
> clauses.
> --
> derek
>

tried it in ansi and got this error message:

near "auto_increment": syntax error

i am really confued, i have sqlite3 installed, would that do it?


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 05:23 PM
Leo Cacciari
 
Default converting from mysql to sqlite

Il giorno lun, 04/08/2008 alle 11.31 -0500, Ulin the Tech Mage ha
scritto:
> 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...
> >
Hi,
I do not understand one little thing. As you are writing from a
technical outfit [by the way, WTF is a christian based computer repair
biz? WTF has the name of your god to do with your business?] I strongly
suspect that this is something pertaining to your work. That is, you'll
be paid to do it. You'll be paid for doing something that you have not a
clue how to do (and when I say not a clue, is not even the smallest. You
do not know sql, nor has you read the mysql or SQLite manual).

I'm working on this kind of stuff for living too, and I truly do not see
why should I help you get some money you do not deserve. I'm ready to
help people which does a modicum of effort on their own side, and I'll
do that even if it is clear they will be paid for it. But _my_ gods
forbid me to help someone who does not even RTFM.

As far I'm concerned, you already got to much help. Read the manual,
learn sql and (by the way) submit your question to the relevant mailing
list (the SQLite one should be a good place to start) This one is for
ubuntu-related question, and your definitively isn't.

If the above is not possible for you, then get some paid help, by hiring
someone who can do the job (not me, I do not work for religious
institutions of any kind, they disgust me).

Enjoy

--
Leo Cacciari
--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 05:36 PM
Ulin the Tech Mage
 
Default converting from mysql to sqlite

On Mon, 2008-08-04 at 19:23 +0200, Leo Cacciari wrote:
> Il giorno lun, 04/08/2008 alle 11.31 -0500, Ulin the Tech Mage ha
> scritto:
> > 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...
> > >
> Hi,
> I do not understand one little thing. As you are writing from a
> technical outfit [by the way, WTF is a christian based computer repair
> biz? WTF has the name of your god to do with your business?] I strongly
> suspect that this is something pertaining to your work. That is, you'll
> be paid to do it. You'll be paid for doing something that you have not a
> clue how to do (and when I say not a clue, is not even the smallest. You
> do not know sql, nor has you read the mysql or SQLite manual).
>
> I'm working on this kind of stuff for living too, and I truly do not see
> why should I help you get some money you do not deserve. I'm ready to
> help people which does a modicum of effort on their own side, and I'll
> do that even if it is clear they will be paid for it. But _my_ gods
> forbid me to help someone who does not even RTFM.
>
> As far I'm concerned, you already got to much help. Read the manual,
> learn sql and (by the way) submit your question to the relevant mailing
> list (the SQLite one should be a good place to start) This one is for
> ubuntu-related question, and your definitively isn't.
>
> If the above is not possible for you, then get some paid help, by hiring
> someone who can do the job (not me, I do not work for religious
> institutions of any kind, they disgust me).
>
> Enjoy
>

that was not needed. however i am sorry that i wasted YOUR time. if i
remember correctly though you can choose what messages you read and
respond to and what messages you choose not to respond to. so therefore
it is not I who looks like a dolt and irrational. it is you. i am sorry
but over egos are worthless in society. if we are to bring linux to the
masses, people like you will have to go. sorry dude, but that kind of
ego centric foolishness is worthless to the outside world. I do not
attack your lack of faith. I try to respect it, but guess what. you
proved that you don't know crap!


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 05:40 PM
Derek Broughton
 
Default converting from mysql to sqlite

Leo Cacciari wrote:

> Il giorno lun, 04/08/2008 alle 11.31 -0500, Ulin the Tech Mage ha
> scritto:
>> i tried that, gives me a weird syntax error:
>> near "SET": syntax error
>>
> I do not understand one little thing. As you are writing from a
> technical outfit [by the way, WTF is a christian based computer repair
> biz? WTF has the name of your god to do with your business?]

WTF is your problem?
--
derek


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 05:51 PM
Leo Cacciari
 
Default converting from mysql to sqlite

Il giorno lun, 04/08/2008 alle 12.36 -0500, Ulin the Tech Mage ha
scritto:
> On Mon, 2008-08-04 at 19:23 +0200, Leo Cacciari wrote:
> > Il giorno lun, 04/08/2008 alle 11.31 -0500, Ulin the Tech Mage ha
> > scritto:
> > > i tried that, gives me a weird syntax error:
> > > near "SET": syntax error
> > >

> > Enjoy
> >
>
> that was not needed. however i am sorry that i wasted YOUR time. if i
> remember correctly though you can choose what messages you read and
> respond to and what messages you choose not to respond to. so therefore
> it is not I who looks like a dolt and irrational. it is you. i am sorry
> but over egos are worthless in society. if we are to bring linux to the
> masses, people like you will have to go. sorry dude, but that kind of
> ego centric foolishness is worthless to the outside world. I do not
> attack your lack of faith. I try to respect it, but guess what. you
> proved that you don't know crap!
>
>
Who on this green earth gave you the idea that, not beliving in that
travesty which is monotheism (a great man of the past described it as
"a barbarous superstition") means I've no faith?

And the basic fact remains, you are trying to get help for doing a job
you have no qualification whatsoever, nor any desire to get them. And it
is the second half of this statement which for me is an inexcusable sin.

--
Leo Cacciari

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 
Old 08-04-2008, 05:54 PM
Ulin the Tech Mage
 
Default converting from mysql to sqlite

On Mon, 2008-08-04 at 19:51 +0200, Leo Cacciari wrote:
> Il giorno lun, 04/08/2008 alle 12.36 -0500, Ulin the Tech Mage ha
> scritto:
> > On Mon, 2008-08-04 at 19:23 +0200, Leo Cacciari wrote:
> > > Il giorno lun, 04/08/2008 alle 11.31 -0500, Ulin the Tech Mage ha
> > > scritto:
> > > > i tried that, gives me a weird syntax error:
> > > > near "SET": syntax error
> > > >
>
> > > Enjoy
> > >
> >
> > that was not needed. however i am sorry that i wasted YOUR time. if i
> > remember correctly though you can choose what messages you read and
> > respond to and what messages you choose not to respond to. so therefore
> > it is not I who looks like a dolt and irrational. it is you. i am sorry
> > but over egos are worthless in society. if we are to bring linux to the
> > masses, people like you will have to go. sorry dude, but that kind of
> > ego centric foolishness is worthless to the outside world. I do not
> > attack your lack of faith. I try to respect it, but guess what. you
> > proved that you don't know crap!
> >
> >
> Who on this green earth gave you the idea that, not beliving in that
> travesty which is monotheism (a great man of the past described it as
> "a barbarous superstition") means I've no faith?
>
> And the basic fact remains, you are trying to get help for doing a job
> you have no qualification whatsoever, nor any desire to get them. And it
> is the second half of this statement which for me is an inexcusable sin.
>

must....resist.....the.....urge......to.....feed.. ....the.......trolls


--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users
 

Thread Tools




All times are GMT. The time now is 04:02 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org