Re: MySQL to Postgres

2007-02-06 Thread Jim C.
e line just to get my data in. This is a *real* pain since I'm not really very experienced with either Postgres or MySQL. It's cost me a weeks work already. It's fortunate that we planned for this kind of thing. Jim C. signature.asc Description: OpenPGP digital signature

Re: MySQL to Postgres

2007-02-05 Thread Jim C.
Chris White wrote: > Jim C. wrote: >>> CREATE TABLE "credits" ( >>> "person" integer NOT NULL default '0', >>> "chanid" int NOT NULL default '0', >>> "starttime" timestamp NOT NULL default &#

Re: MySQL to Postgres

2007-02-05 Thread Jim C.
(Pacific)','',NULL,'','10150',0,32768,32768,32768,32768,'Default',0,1,'',0,32767,0,NULL,0,47,0),(1024,'24','24',1,'CSPAN','Cable Satellite Public Affairs ... [goes on for another page or two] While the error is: > [EMAIL PROTECTED] jims]$ psql inscom < mysqlDump.postgres.working.sql 2>&1 | > grep ERROR > ERROR: syntax error at or near "," at character 164 So anyway, it's all in the same INSERT command although there are additional INSERT's for the same table. Think I'm on the right track? Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL to Postgres

2007-02-05 Thread Jim C.
> CREATE TABLE "credits" ( > "person" integer NOT NULL default '0', > "chanid" int NOT NULL default '0', > "starttime" timestamp NOT NULL default '1970-01-01 00:00:00+00', > "role" VARCHAR NOT NULL, > CONSTRAINT role_check CHECK "role" IN > ('actor','director','producer','executive_produ

Re: MySQL to Postgres

2007-02-05 Thread Jim C.
> It looks more like the person that designed the schema has payed very > little attention to the SQL standard. You can not blame anyone but the > designer for naming a field 'role' (which is a keyword in the SQL > standard) or using a non-standard set field type instead of a proper > lookup table.

Re: MySQL to Postgres

2007-02-05 Thread Jim C.
proper > lookup table. I live in the commercial sector where users can blame me for anything they want. Even if it isn't justified. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL to Postgres

2007-02-02 Thread Jim C.
x27;presenter','commentator','guest') > NOT NULL default '' > -- CONSTRAINT "chanid_constraint0" UNIQUE > ("chanid","starttime","person","role") > -- UNIQUE KEY "chanid" ("chanid"

Dump to old dump format?

2007-02-01 Thread Jim C.
Is it possible to dump to the old MySQL 4.x format? There are some conversion tools I would like to use and they don't support 5.0 yet. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[ SOLVED I think ] Re: Mandriva 2007 rpm's hosed - Detailed procedural info included - Need help badly

2007-01-30 Thread Jim C.
nt. Thanks again, Dave G. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mandriva 2007 rpm's hosed - Detailed procedural info included - Need help badly

2007-01-30 Thread Jim C.
> [EMAIL PROTECTED] jim]# mysqladmin -u [EMAIL PROTECTED] password new_password > mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER > privilege for this operation' HUH? What's wrong? : > [EMAIL PROTECTED] jim]# mysql -u [EMAIL PROTECTED] > Welcome to the MySQL mon

Re: Setup for MythTV

2005-10-26 Thread Jim C.
Hey! Those are some pretty handy looking links. :-) Thanks!! > Did you see this: > > http://www.mythtv.org/docs/mythtv-HOWTO-6.html > > And also: > > http://wilsonet.com/mythtv/tips.php (see the section on Front Ends) > > And lastly: > > http://dipper.info/project/ivtv/ > signature.asc

Re: Setup for MythTV

2005-10-26 Thread Jim C.
> So follow the installation directions appropriate for the flavor of Linux > you are using. That's where MySQL lives, in the OS, not the application As far as I can tell, there are none. At least not for Mandriva. The attitude seems to be that MySQL is "just the backe

Setup for MythTV

2005-10-25 Thread Jim C.
Where can I get tips on how to manually set up MySQL for MythTV? MythTV's site was not very helpful in this regards. Jim C. signature.asc Description: OpenPGP digital signature

Re: Problems setting up on Mac OS X

2005-09-28 Thread Jim C.
ormation. I'll look around for this kind of stuff. . I'm not fond of the idea, but perhaps if I can't get it working, I'll try compiling it from source. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems setting up on Mac OS X

2005-09-28 Thread Jim C.
Jim C. wrote: > I had the same problem with both of these: > > mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg > and > mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg > > They seem to install OK, but when I set the root password I can't get in > afterwards as

Problems setting up on Mac OS X

2005-09-28 Thread Jim C.
I had the same problem with both of these: mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg and mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg They seem to install OK, but when I set the root password I can't get in afterwards as root. Clues? Jim C. -- MySQL General Mailing Lis