Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Nikola Antonov
On Sunday 23 January 2005 08:33, Valeri Vladev wrote:
   mysqldump

   .  mysqldump,
   MySQL, 1:1 
psql, .
  , 
  psql . 
,  ,
,  .

-- 
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--



pgpfLbUxrYpUN.pgp
Description: PGP signature


Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Valeri Vladev
On Sun, 23 Jan 2005, Nikola Antonov wrote:

 On Sunday 23 January 2005 08:33, Valeri Vladev wrote:
mysqldump
 
.  mysqldump,
MySQL, 1:1 
 psql, .
   , 
   psql . 
 ,  ,
 ,  .
 
 -- 
 .

   . dump
 .  ,   .
  .   
   .
   .

- 
Valeri Vladev [EMAIL PROTECTED]
PGP-Key-ID: 0x9CB166CD ICQ #235683218
Registered Linux User #362712
/**   **/


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html



Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Огнян Кулев
Nikola Antonov wrote:
   
  MySQL  PostgreSQL.
  mysqldump --compatible=postgresql?   
MySQL 4.1,  MySQL 4.1  
mysqldump.

,


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html



Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Nikola Antonov
On Sunday 23 January 2005 11:20,   wrote:
   mysqldump --compatible=postgresql?  
 MySQL 4.1,  MySQL 4.1 
 mysqldump.

 ,
 

,  MySQL-  4.1  .   .  
 .,
;) 

   , . 

-- 
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--



pgpqENXUCLoeZ.pgp
Description: PGP signature


Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Огнян Кулев
Nikola Antonov wrote:
,  MySQL-  4.1  .   .  
 .,
;) 
--compatible=ansi?  ;-) , -   
 .?

,


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html



Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Nikola Antonov
On Sunday 23 January 2005 12:16,   wrote:
 --compatible=ansi?  ;-) , -  
  .?

 ,
 

 . cp1251. ,
  psql,:

---cut---
sql:ezcontents.sql:833: ERROR:  syntax error at or near phpbb_vote_desc at 
character 13
psql:ezcontents.sql:834: ERROR:  syntax error at or near , at character 172
psql:ezcontents.sql:835: ERROR:  syntax error at or near UNLOCK at character 
1
psql:ezcontents.sql:842: ERROR:  syntax error at or near EXISTS at character 
15
psql:ezcontents.sql:850: ERROR:  syntax error at or near ( at character 58
psql:ezcontents.sql:858: ERROR:  syntax error at or near 
phpbb_vote_results at character 13
psql:ezcontents.sql:859: ERROR:  syntax error at or near , at character 55
---cut---

 , ,  .  EXISTS  
   .

-- 
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--



pgp3OCyGvApY7.pgp
Description: PGP signature


Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Nikola Antonov
On Sunday 23 January 2005 12:39, Nikola Antonov wrote:
  , ,  .  EXISTS 
.

,   :

DROP TABLE IF EXISTS phpbb_auth_access;

 ,  PostgreSQL.  
.

-- 
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--



pgpu4lyTHJ1bq.pgp
Description: PGP signature


Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Nikola Antonov
On Sunday 23 January 2005 12:48, Nikola Antonov wrote:
 On Sunday 23 January 2005 12:39, Nikola Antonov wrote:
   , ,  .  EXISTS
  .

 ,   :

 DROP TABLE IF EXISTS phpbb_auth_access;

  ,  PostgreSQL.
  .

  .   dump-INSERT-.   
 PostgreSQL (  
  phpBB).   INSERT-,  
   :

INSERT 18757 1
psql:ezcontents-1.sql:65: ERROR:  syntax error at or near , at character 112
psql:ezcontents-1.sql:66: ERROR:  syntax error at or near , at character 48
psql:ezcontents-1.sql:67: ERROR:  syntax error at or near , at character 47
psql:ezcontents-1.sql:68: ERROR:  syntax error at or near , at character 178
psql:ezcontents-1.sql:69: ERROR:  syntax error at or near , at character 172
psql:ezcontents-1.sql:70: ERROR:  syntax error at or near , at character 55
psql:ezcontents-1.sql:71: ERROR:  syntax error at or near , at character 56

-- 
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--



pgpPKC9Uv2IFk.pgp
Description: PGP signature


Re: lug-bg: От MySQL към PostgreSQL

2005-01-23 Thread Nikola Antonov
   .  
  mysqldump,   --compatible=ansi 
--extended-insert=FALSE -c.  INSERT-
 Postgre- ;)

-- 
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--



pgpvwnycGnisH.pgp
Description: PGP signature


lug-bg: От MySQL към PostgreSQL

2005-01-22 Thread Nikola Antonov
,

   
  MySQL  PostgreSQL. phpBB. 
, postgresql-contrib. 
. 

  my2pg.pl , ,  
,  output ,,
 ( 18).   .

mysql2pgsql   dump,. ,   
psql  , , 
 dump   MySQL.

   
   ,   .

-- 
Nikola ANTONOV, Sofia, Bulgaria
4 Dragan Tsankov blvd., 1000
Bulgarian National Radio
--
http://linux-bg.org
http://mirrors.logos-bg.net
http://debianbookbg.org
--
Public GnuPG key at http://wwwkeys.pgp.net
http://ftp.logos-bg.net/pub/Linux-BG.org/GPG_Keys/
Fingerprint: AD64 2468 0AB4 B298 E7E3 92DA 15F5 7AC5 A05E 0F63
--



pgphOlPLEBTcT.pgp
Description: PGP signature


Re: lug-bg: От MySQL към PostgreSQL

2005-01-22 Thread Valeri Vladev
On Sat, 22 Jan 2005, Nikola Antonov wrote:

 ,
 

   MySQL  PostgreSQL. phpBB. 
 , postgresql-contrib. 
 . 
 
   my2pg.pl , ,  
 ,  output ,,
  ( 18).   .
 
 mysql2pgsql   dump,. ,   
 psql  , , 
  dump   MySQL.
 

,   .
 

  mysqldump

-- 
Valeri Vladev [EMAIL PROTECTED]
PGP-Key-ID: 0x9CB166CD ICQ #235683218
Registered Linux User #362712
/**   **/


A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html