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


Re: lug-bg: Îò MySQL êúì PostgreSQL

2005-01-23 Thread raptor
http://sqlfairy.sourceforge.net/

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: squid въпрос

2005-01-23 Thread Stefan Stoilov

iptables -t nat -A PREROUTING -i eth0 -p tcp -d ! 1.2.3.4 (warez IP)
--dport 80 -j REDIRECT --to-port 8080

, .
  iptables,.

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: squid ??????

2005-01-23 Thread Stoimen Gerenski
Title: RE: lug-bg: squid ??





!  -?
 , .


Regards,
Stoimen 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 bulgaria.org] On Behalf Of Danail Petrov
 Sent: Monday, January 24, 2005 9:24 AM
 To: lug-bg@linux-bulgaria.org
 Subject: Re: lug-bg: squid ??
 
 Stefan Stoilov wrote:
 
 
  iptables -t nat -A PREROUTING -i eth0 -p tcp -d ! 1.2.3.4 (warez IP)
  --dport 80 -j REDIRECT --to-port 8080
 
 
 
  , .  
 iptables,   
  .
 
 ==
 ==
 
  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
 
 ==
 ==
 
 
 ,
 2 :
 
-I (iptables). (-i eth0) :
 
 iptables -t nat -I PREROUTING -p tcp -m multiport --dport 80,3128 -d !
 1.2.3.4 -j REDIRECT --to 8080 ()
 
   :
 
 iptables -t mangle -I PREROUTING -s 1.2.3.4 -j MARK --set-mark 1
 iptables -t nat -I PREROUTING -m mark --mark 1 -j RETURN
 
 ,
  
 ==
 ==
 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
 ==
 ==