Re: Getting started with Postgres or MySQL

2007-02-02 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/02/07 07:54, Dan H. wrote: > Danesh Daroui wrote: > >> 5. Again back to your example, yes, the PayPal web site offers you to >> choose the data by using a combo box and not inserting it manually. So >> the date which is sent to the database is d

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
f you are not asked to do so! Really? Where is your invitation to participate in this thread? The original post that started this thread was a request for help getting started with MySQL or PostgreSQL. I am subscribed to the list and received the message. That's all the invitiation I needed.

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Danesh Daroui
x27;s job to check if the data is "logically" valid. For example not to allow a character to be written in an integer field. There are libraries in each programming language to do so. As I said, MySQL also supports such things and have its own library of functions which are very powerfu

Re: Re: Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 09:10:27PM -0500, Angelo Bertolli wrote: > > But you're coming from an angle where people know or must learn all of > that just before they're able to even start. Don't you see how not > having to learn that is faster for some people? > Ever have to share the road with so

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Fri, Feb 02, 2007 at 05:53:52AM +0100, Danesh Daroui wrote: > > What a useless and boring discussion you have started Ron!! Do you have > to just be against everyone who thinks MySQL has at least some good > features too? I just dropped the discussion when realized that it goes &g

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
or Microsoft? Or maybe you're an MCSE? >> >> It's confirmed. You *are* an MCSE. > > For that I may implement my next database with MySQL (instead of > Postgres like planned), just to spite you. I'll live. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux)

Re: OT MySQL and PostgreSQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 22:19, Paul E Condon wrote: > The recent heated discussion as to the relative merits of MySQL and > PostgresSQL reminded me of a question that I want to ask of RDBMS > experts, particularly experts who are willing to tak

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
Ron Johnson wrote: > That splatting noise is my hurl splatting onto the opposite wall. > > Remind me never to hire you. > > Are you sure you don't work for Microsoft? Or maybe you're an MCSE? > > It's confirmed. You *are* an MCSE. For that I may implement my

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Danesh Daroui
Ron Johnson wrote: > On 02/01/07 20:10, Angelo Bertolli wrote: >> Roberto C. Sanchez wrote: >>> On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: >>> >>>> (2) MySQL is a shorter learning curve for new users >>>> >>>>

OT MySQL and PostgreSQL

2007-02-01 Thread Paul E Condon
The recent heated discussion as to the relative merits of MySQL and PostgresSQL reminded me of a question that I want to ask of RDBMS experts, particularly experts who are willing to take a clear position. Namely, what do you think of the work of C. J. Date? He rejects SQL, as far as I can tell

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Greg Folkert
On Thu, 2007-02-01 at 20:37 -0600, Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/01/07 20:10, Angelo Bertolli wrote: > > Roberto C. Sanchez wrote: > >> On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: > >> &

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 20:10, Angelo Bertolli wrote: > Roberto C. Sanchez wrote: >> On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: >> >>> (2) MySQL is a shorter learning curve for new users >>> >>>

Re: Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
Roberto C. Sanchez wrote: > On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: > >> (2) MySQL is a shorter learning curve for new users >> >> > What? In what way? Learning to develop against MySQL is no harder or > easier than learning to devel

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 17:03, Roberto C. Sanchez wrote: > On Thu, Feb 01, 2007 at 04:37:39PM -0500, Angelo Bertolli wrote: [snip] > Yes, they were "fast" when computers were still slow. Unfortunately, > many people were willing to give up data integrity in excha

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 04:37:39PM -0500, Angelo Bertolli wrote: > > The fundamental difference is licensing. If Windows was open source, I > certainly wouldn't bother disagreeing with them if they specified which > users would benefit more from Windows. And on that

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: > > (1) MySQL is shown to be faster in a single-user environment than > Postgres, especially with complicated SELECT statements > IIRC, this does not hold for transactional tables. So, we are back to the "if you

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 12:16, Angelo Bertolli wrote: I've been debating whether or not to make a comment on this discussion, but it finally got to me. I think you're being way too hard on MySQL considering the fact that thi

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
s >>> if nothing happened." >>> >>> >> I'm sorry, but "our database can't always handle >> transactions" is not a valid excuse for allowing bogus >> data. > >Does this mean that Mysql isn't really a DB, but is in

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 12:16, Angelo Bertolli wrote: > I've been debating whether or not to make a comment on this discussion, > but it finally got to me. I think you're being way too hard on MySQL > considering the fact that this question

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
I've been debating whether or not to make a comment on this discussion, but it finally got to me. I think you're being way too hard on MySQL considering the fact that this question originated from the idea of using a database backend for OpenOffice.org. Yeah, I didn't

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Max Hyre
; case, the update would be ???half done,??? which is >> probably the worst possible scenario. In this case, it's >> better to ???do the best you can??? and then continue as >> if nothing happened." >> >> > I'm sorry, but "our database can't alwa

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Dave Ewart
by 'validate'. The database ought, at least, to return the same value that was INSERTed. Or, if it is not able to do so, it should raise an error on the INSERT. Look! This is MySQL 5: >> mysql> create table foo(a date); >> Query OK, 0 rows af

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 23:18, Danesh Daroui wrote: > Roberto C. Sanchez wrote: >> On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: >> [snip] > Maybe MySQL is not the best database engine in the world but it is one > the

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 06:18:03AM +0100, Danesh Daroui wrote: > > Maybe MySQL is not the best database engine in the world but it is one > the best engines. I have worked on MySQL for several years and from four > years ago I have started to develop my own database engine inspired

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Danesh Daroui
f enabling the "traditional" strict behavior. So, with one config option, MySQL will now reject all invalid data (providing you're using transactional engines, for reasons described above). Please read this: http://developers.slashdot.org/comments.pl?sid=219722&cid=17824

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
de a way (from 5.0.2 on) of enabling the "traditional" strict > behavior. So, with one config option, MySQL will now reject all invalid data > (providing you're using transactional engines, for reasons described above). > Please read this: http://developers.slashdot.org

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Wed, Jan 31, 2007 at 01:50:14PM -0900, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > > > How do I get started here? > > > > First. Please do not use MySQL, unless you don't care about your data. > > Please sto

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 15:27, Ron Johnson wrote: > You're talking to someone who's been a DBA for 10 years; you will > not win this argument. Eh, so ya got three years on me. :) j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
gt;> How do I get started here? >>>> First. Please do not use MySQL, unless you don't care about your data. >>> Please stop this MySQL vs. PostgreSQL bashing. Each has their place. If >>> users of MySQL don't care about their data, then I guess Bayer, Colgate

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 14:20, Ron Johnson wrote: > On 01/31/07 16:50, Joshua J. Kugler wrote: > > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > >>> How do I get started here? > >> > >> First. Please do not use MySQL, unless you don

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 16:50, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: >>> How do I get started here? >> First. Please do not use MySQL, unless you don't care about your data. > &

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > > How do I get started here? > > First. Please do not use MySQL, unless you don't care about your data. Please stop this MySQL vs. PostgreSQL bashing. Each has their place. If users of MySQL don't care ab

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
first line in the spreadsheet. This can, indeed, be queried, sort of. > > I would like to get this data into a Postgres or MySQL database. Using > pgadmin3, I cannot get a connection connected. Does not accept my password. > Their docs cited Debian problems here and recommended md5 au

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 12:29, Danesh Daroui wrote: > David Baron wrote: [snip] > MySQL is definitely best choice. If you have not still installed > latest version of MySQL do it as following: Well, if you *insist* on starting a war, so be it. MySQL

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Danesh Daroui
indeed, be queried, sort of. > > I would like to get this data into a Postgres or MySQL database. Using > pgadmin3, I cannot get a connection connected. Does not accept my password. > Their docs cited Debian problems here and recommended md5 authorization. > Tried that. No ava

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Clive Menzies
eadsheet. This can, indeed, be queried, sort of. > > I would like to get this data into a Postgres or MySQL database. Using > pgadmin3, I cannot get a connection connected. Does not accept my password. > Their docs cited Debian problems here and recommended md5 authorization. > T

Getting started with Postgres or MySQL

2007-01-31 Thread David Baron
this data into a Postgres or MySQL database. Using pgadmin3, I cannot get a connection connected. Does not accept my password. Their docs cited Debian problems here and recommended md5 authorization. Tried that. No avail. One can also simply say trust (localhost only). No avail. How do I get

Mysql on Sarge

2007-01-30 Thread Joe Tannenbaum
Hello, I loaded Sarge with php and mysql and got php4 and mysql-4 I updated php to php5 and it seems ok I updated mysql to mysql-5.0, but though apt-get says I have the 5.0 client and not the 4.1, my info page and mysql-admin says the client is 4.1!!?? How can I fix this? Any help appreciated

Re: Mysql filling /var partition with logs

2007-01-16 Thread Kevin Ross
I don't know if this will help, but when I look at the documentation link at the top of the config file: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html It shows all of the variable names with underscores "_" and not hyphens "-". Maybe that's why your config settings are

Re: mysql error problem

2007-01-16 Thread mouss
Jan Willem Stumpel wrote: I have mysql running (installed by the music management program, prokyon3) but I do not know anything about mysql really. Recently, mysql, on startup, started mailing error messages to my root account with the subject "WARNING: mysqlcheck has found corrupt t

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-15 Thread Abu Zaher
my hdd so that I can boot and do all my stuff from that hdd? I mean the above discussion is for /var/lib/mysql, will the same work for / ? Bought a new hdd yesterday and solved the problem in my way. First i booted with ubuntu live cd. Partitioned the new hard drive with some ext3 filesyst

mysql error problem

2007-01-15 Thread Jan Willem Stumpel
I have mysql running (installed by the music management program, prokyon3) but I do not know anything about mysql really. Recently, mysql, on startup, started mailing error messages to my root account with the subject "WARNING: mysqlcheck has found corrupt tables". The mail itself co

Mysql filling /var partition with logs

2007-01-15 Thread Chrom_
Hi all. I'm running into the following problem. Mysql is filling my /var partition because the log limit doesn't seem to be respected. I've tried many different settings in /etc/mysql/my.cnf but nothing works. Logrotate is not enabled/configured. I just want mysql to use a maximu

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-14 Thread Douglas Tutty
y 2 dump my whole / > to my hdd so that I can boot and do all my stuff from that hdd? I mean the > above discussion is for /var/lib/mysql, will the same work for / ? > > Sorry 4 any inconveniences. > You __can__ go through the hoops to do this. See the HOWTOs (multi-disk, large di

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-14 Thread Andy Smith
On Sun, Jan 14, 2007 at 11:34:02AM +0600, Abu Zaher wrote: >My question is slightly related to this post, so I'm posting it here. >I'm currently running my Sid on a 40GB hdd which is running out of >life, In a few days I'll buy a new 80GB. Now what is the best way 2 >dump my whole /

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-13 Thread Abu Zaher
hdd? I mean the above discussion is for /var/lib/mysql, will the same work for / ? Sorry 4 any inconveniences. Regards Abu Zaher Md. Faridee --- Time heals every wound, but time itself is a wound that never heals.

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-13 Thread Cameron L. Spitzer
nd run your system from a chroot some day. Symlinks should usually be relative paths. In any case, I wouldn't just move all of /var. If the problem is /var/lib/mysql, then just move that. Make a partition or a logical volume /extra and copy /var/lib/mysql to /extra/lib/mysql. Then yo

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-11 Thread Andrei Popescu
On Thu, 11 Jan 2007 14:33:45 -0500 [EMAIL PROTECTED] wrote: > On Thu, Jan 11, 2007 at 06:14:44PM +0200, Andrei Popescu wrote: > > On Thu, 11 Jan 2007 09:02:02 -0500 > > [EMAIL PROTECTED] wrote: > > > > > > So the effect of ln is the same as cp, except that no copy is > > > made. > > > > Not real

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-11 Thread hendrik
On Thu, Jan 11, 2007 at 06:14:44PM +0200, Andrei Popescu wrote: > On Thu, 11 Jan 2007 09:02:02 -0500 > [EMAIL PROTECTED] wrote: > > > > So the effect of ln is the same as cp, except that no copy is made. > > Not really. If you make a link (soft or hard) you get one file/dir with > two names and/o

RE: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-11 Thread James Stevenson
> -Original Message- > From: Andrei Popescu [mailto:[EMAIL PROTECTED] > Sent: 11 January 2007 16:15 > To: debian-user@lists.debian.org > Subject: Re: Adding a new HDD - how do I move /var/lib/mysql ? > > On Thu, 11 Jan 2007 09:02:02 -0500 > [EMAIL PROTECTED] wrot

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-11 Thread Andrei Popescu
On Thu, 11 Jan 2007 09:02:02 -0500 [EMAIL PROTECTED] wrote: > On Wed, Jan 10, 2007 at 10:20:57PM -0800, Marc Shapiro wrote: > > -Original Message- > > >Ln -s /var/lib/mysql /mnt/hdx/mysql > > > > > Shouldn't the last line be replaced with: > >

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-11 Thread hendrik
On Wed, Jan 10, 2007 at 10:20:57PM -0800, Marc Shapiro wrote: > -Original Message- > >Ln -s /var/lib/mysql /mnt/hdx/mysql > > > Shouldn't the last line be replaced with: > >ln -s /mnt/hdx/mysql /var/lib/mysql > > Although I would actually do: >

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-10 Thread Marc Shapiro
-Original Message- From: Justin Hartman [mailto:[EMAIL PROTECTED] Sent: 10 January 2007 19:32 To: debian-user@lists.debian.org Subject: Adding a new HDD - how do I move /var/lib/mysql ? I currently have a server with an 80GB hdd which is running out of space very quickly. I want to now

RE: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-10 Thread James Stevenson
Install new hard driver. Create a partition Fdisk /dev/hdx Add to fstab As /dev/hdx /mnt/hdx Format it Mkfs /dev/hdx Mount /dev/hdx Stop mysql Mv /var/lib/mysql /mnt/hdx Link it over Ln -s /var/lib/mysql /mnt/hdx/mysql Start mysql Means you can move other things into it if you run out of space

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-10 Thread Roberto C. Sanchez
On Wed, Jan 10, 2007 at 02:46:29PM -0500, Kevin Mark wrote: > probably the simplest way is to just make a new /var on the new drive > and move all of it there. > -add new HD to computer > -partition HD > -format HD > -mount new HD as /mnt/newvar > -stop all processes (like single user mode) > -copy

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-10 Thread Tyler MacDonald
Kevin Mark <[EMAIL PROTECTED]> wrote: I've had to do this several times now, it's a fairly painless procedure. I've added a few notes... > Hi Justin, > probably the simplest way is to just make a new /var on the new drive > and move all of it there. > -add new HD to computer > -partition HD > -fo

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-10 Thread Justin Hartman
09:31:31PM +0200, Justin Hartman wrote: > I currently have a server with an 80GB hdd which is running out of > space very quickly. I want to now add a 250GB hdd in addition to the > 80GB one and move my mysql data to this new 250GB drive. > > I am running mysql-5.0.30 on Etch which was insta

Re: Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-10 Thread Kevin Mark
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, Jan 10, 2007 at 09:31:31PM +0200, Justin Hartman wrote: > I currently have a server with an 80GB hdd which is running out of > space very quickly. I want to now add a 250GB hdd in addition to the > 80GB one and move my mysql data to

Adding a new HDD - how do I move /var/lib/mysql ?

2007-01-10 Thread Justin Hartman
I currently have a server with an 80GB hdd which is running out of space very quickly. I want to now add a 250GB hdd in addition to the 80GB one and move my mysql data to this new 250GB drive. I am running mysql-5.0.30 on Etch which was installed via apt-get so there has been no modifications

Re: Problems with phpbb and mysql vi dselect

2006-12-20 Thread Bill Warren
Bill Warren wrote: > > > > -Original Message- > From: Angelo Bertolli [mailto:[EMAIL PROTECTED] > Sent: Mon 12/18/2006 10:20 PM > To: Bill Warren > Cc: debian-user@lists.debian.org > Subject: Re: Problems with phpbb and mysql vi dselect > > Bill Warren wro

Re: Problems with phpbb and mysql vi dselect

2006-12-19 Thread Bill Warren
Angelo Bertolli wrote: >Bill Warren wrote: > > >> >>-Original Message- >>From: Angelo Bertolli [mailto:[EMAIL PROTECTED] >>Sent: Mon 12/18/2006 10:20 PM >>To: Bill Warren >>Cc: debian-user@lists.debian.org >>Subject: Re: Problems wit

RE: Problems with phpbb and mysql vi dselect

2006-12-18 Thread Bill Warren
-Original Message- From: Angelo Bertolli [mailto:[EMAIL PROTECTED] Sent: Mon 12/18/2006 10:20 PM To: Bill Warren Cc: debian-user@lists.debian.org Subject: Re: Problems with phpbb and mysql vi dselect Bill Warren wrote: > > Hello, > > I have dselected phpbb2 and mysql. The

Re: Problems with phpbb and mysql vi dselect

2006-12-18 Thread Angelo Bertolli
Bill Warren wrote: > > Hello, > > I have dselected phpbb2 and mysql. The database is done and works. > When I go to http://mywebsite.com/phpbb the web page I get: > > The database module for the database you are using, MySQL, is not > available. Please (re)install the php4-

Problems with phpbb and mysql vi dselect

2006-12-18 Thread Bill Warren
Hello, I have dselected phpbb2 and mysql. The database is done and works. When I go to http://mywebsite.com/phpbb the web page I get: The database module for the database you are using, MySQL, is not available. Please (re)install the php4-mysql package or if it's already installed

Re: Remote MySQL connect

2006-12-13 Thread Joe
marc wrote: Joe said... marc wrote: Joe said... marc wrote: What is the 'correct' way to configure MySQL for remote connections? The db in question is running fine and can be accessed via phpmyadmin, amongst other things. The default my.cnf has: bind-address - 127.0.0

Re: Remote MySQL connect

2006-12-13 Thread marc
Joe said... > marc wrote: > > Joe said... > >> marc wrote: > >>> What is the 'correct' way to configure MySQL for remote connections? > >>> > >>> The db in question is running fine and can be accessed via phpmyadmin,

Re: Remote MySQL connect

2006-12-12 Thread Joe
marc wrote: Joe said... marc wrote: What is the 'correct' way to configure MySQL for remote connections? The db in question is running fine and can be accessed via phpmyadmin, amongst other things. The default my.cnf has: bind-address - 127.0.0.1 When I comment this out (a

Re: Remote MySQL connect

2006-12-12 Thread marc
Joe said... > marc wrote: > > What is the 'correct' way to configure MySQL for remote connections? > > > > The db in question is running fine and can be accessed via phpmyadmin, > > amongst other things. > > > > The default my.cnf has: > >

Re: Remote MySQL connect

2006-12-12 Thread Joe
marc wrote: What is the 'correct' way to configure MySQL for remote connections? The db in question is running fine and can be accessed via phpmyadmin, amongst other things. The default my.cnf has: bind-address - 127.0.0.1 When I comment this out (and restart the db), I c

Remote MySQL connect

2006-12-12 Thread marc
What is the 'correct' way to configure MySQL for remote connections? The db in question is running fine and can be accessed via phpmyadmin, amongst other things. The default my.cnf has: bind-address - 127.0.0.1 When I comment this out (and restart the db), I can connect remotely

Apache2 Mysql Auth problem

2006-11-29 Thread Dave Whiteley
An upgrade has broken my Apache installation. I have been using old modules to allow autentication from a MySQL database for years. The most recent upgrade to Apache2 has killed this because the relevent modules have been changed/split/renamed. I think I have re-configured accordingly, but I

Re: mysql client fail to start.

2006-11-16 Thread Stephen
On Thu, Nov 16, 2006 at 10:53:45AM +0700 or thereabouts, Surachai Locharoen wrote: > I use lastest Debian testing. mysql client fail to start. > error message show: > mysql: relocation error: mysql: symbol errno, version GLIBC_2.0 not > defined in file libc.so.6 with link time refere

mysql client fail to start.

2006-11-15 Thread Surachai Locharoen
I use lastest Debian testing. mysql client fail to start. error message show: mysql: relocation error: mysql: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference

Re: cannot remove mysql-server-5.0

2006-11-14 Thread Florian Kulzer
On Mon, Nov 13, 2006 at 18:04:12 -0800, Tom Brown wrote: > On Monday 13 November 2006 17:53, Kevin Mark wrote: > > On Mon, Nov 13, 2006 at 10:46:26AM -0800, Tom Brown wrote: > > > On Monday 13 November 2006 09:40, Tom Brown wrote: > > > > I installed some mysql 5 pac

Re: cannot remove mysql-server-5.0

2006-11-13 Thread Kevin Mark
> Building Dependency Tree... Done > E: The package mysql-server-5.0 needs to be reinstalled, but I can't find an > archive for it. > > Does this mean there's no hope for my poor dev server? A fresh install > wouldn't kill me. Although, if there is way out of this

Re: cannot remove mysql-server-5.0

2006-11-13 Thread Tom Brown
On Monday 13 November 2006 17:53, Kevin Mark wrote: > On Mon, Nov 13, 2006 at 10:46:26AM -0800, Tom Brown wrote: > > On Monday 13 November 2006 09:40, Tom Brown wrote: > > > I installed some mysql 5 packages on my development server. I had to do > > > a --force-all t

Re: cannot remove mysql-server-5.0

2006-11-13 Thread Kevin Mark
On Mon, Nov 13, 2006 at 10:46:26AM -0800, Tom Brown wrote: > On Monday 13 November 2006 09:40, Tom Brown wrote: > > I installed some mysql 5 packages on my development server. I had to do a > > --force-all to get them to install. I've tried three different ways to > >

Re: cannot remove mysql-server-5.0

2006-11-13 Thread Tom Brown
On Monday 13 November 2006 09:40, Tom Brown wrote: > I installed some mysql 5 packages on my development server. I had to do a > --force-all to get them to install. I've tried three different ways to > remove the package but all fail (shown below). Any ideas on how to remove > t

cannot remove mysql-server-5.0

2006-11-13 Thread Tom Brown
Hi, I installed some mysql 5 packages on my development server. I had to do a --force-all to get them to install. I've tried three different ways to remove the package but all fail (shown below). Any ideas on how to remove the package? Thanks, Tom $ sudo apt-get remove mysql-serve

Re: mysql upgrade broke server

2006-11-12 Thread Kevin Mark
On Mon, Nov 13, 2006 at 07:39:06AM +1100, Russell Weatherburn wrote: > Wackojacko wrote: > > Kevin Mark wrote: > >> On Fri, Nov 10, 2006 at 05:57:13PM -0500, Rick Pasotto wrote: > > > > > > > >>> I used 'querybts' *after* apt-get broke my installation. Are you in the > >>> habit of checking for

Re: mysql upgrade broke server

2006-11-12 Thread Russell Weatherburn
Wackojacko wrote: > Kevin Mark wrote: >> On Fri, Nov 10, 2006 at 05:57:13PM -0500, Rick Pasotto wrote: > > > >>> I used 'querybts' *after* apt-get broke my installation. Are you in the >>> habit of checking for bugs on *every* package before upgrading it? >>> I'm not. >> Hi Rick, >> as you sugge

Re: mysql upgrade broke server

2006-11-11 Thread Wackojacko
Kevin Mark wrote: On Fri, Nov 10, 2006 at 05:57:13PM -0500, Rick Pasotto wrote: I used 'querybts' *after* apt-get broke my installation. Are you in the habit of checking for bugs on *every* package before upgrading it? I'm not. Hi Rick, as you suggest, I dont check for bugs before upgrading

Re: mysql upgrade broke server [solved!]

2006-11-10 Thread Rick Pasotto
On Fri, Nov 10, 2006 at 07:01:26PM -0500, Roberto C. Sanchez wrote: > On Fri, Nov 10, 2006 at 06:57:28PM -0500, Rick Pasotto wrote: > > > > dpkg -i --force all mysql-common-4.1_4.1.11a-4sarge7_all.deb > > dpkg -i --force all mysql-client-4.1_4.1.11a-4sarge7_i386.deb > >

Re: apt-get mysql-server

2006-11-10 Thread Tom Brown
On Friday 10 November 2006 15:46, Kevin Mark wrote: > Hi Tom, > if you used apt-get with the above sources, you couldnt install version > 5. So it must have been a download from maybe backports.org or someother > location. Thats my guess. You can certainly try to remove any mysql &g

Re: mysql upgrade broke server [solved!]

2006-11-10 Thread Roberto C. Sanchez
On Fri, Nov 10, 2006 at 06:57:28PM -0500, Rick Pasotto wrote: > > dpkg -i --force all mysql-common-4.1_4.1.11a-4sarge7_all.deb > dpkg -i --force all mysql-client-4.1_4.1.11a-4sarge7_i386.deb > dpkg -i --force all mysql-server-4.1_4.1.11a-4sarge7_i386.deb > Be careful telling dp

Re: apt-get mysql-server

2006-11-10 Thread Douglas Tutty
On Fri, Nov 10, 2006 at 03:32:42PM -0700, Tom Brown wrote: > Hello, > > I apt-got mysql-server on two debian sarge machines. On the first machine, > mysql-server 5 was installed. The second machine, mysql-server 4 was > installed. They both have the same sources.list. Any ideas

Re: mysql upgrade broke server [solved!]

2006-11-10 Thread Rick Pasotto
u can install it with "dpkg --install". > > > > So I added to /etc/apt/sources.list: > > > > deb http://snapshot.debian.net/archive pool mysql-dfsg-4.1 > > > > and updated. Now what? > > > > 'apt-get install mysql-dfsg-4.1&#x

Re: mysql upgrade broke server

2006-11-10 Thread Kevin Mark
On Fri, Nov 10, 2006 at 05:57:13PM -0500, Rick Pasotto wrote: > On Fri, Nov 10, 2006 at 05:43:53PM -0500, Kevin Mark wrote: > > On Fri, Nov 10, 2006 at 04:39:23PM -0500, Rick Pasotto wrote: > > > I just tried to upgrade mysql-server which replaces 4.1 with 5.0. The > >

Re: apt-get mysql-server

2006-11-10 Thread Kevin Mark
On Fri, Nov 10, 2006 at 03:47:04PM -0700, Tom Brown wrote: > On Friday 10 November 2006 14:50, Kevin Mark wrote: > > On Fri, Nov 10, 2006 at 03:32:42PM -0700, Tom Brown wrote: > > > Hello, > > > > > > I apt-got mysql-server on two debian sarge machines. On the

Re: mysql upgrade broke server

2006-11-10 Thread Florian Kulzer
On Fri, Nov 10, 2006 at 17:54:10 -0500, Rick Pasotto wrote: > On Fri, Nov 10, 2006 at 11:20:50PM +0100, Florian Kulzer wrote: > > On Fri, Nov 10, 2006 at 16:39:23 -0500, Rick Pasotto wrote: > > > I just tried to upgrade mysql-server which replaces 4.1 with 5.0. The > >

Re: mysql upgrade broke server

2006-11-10 Thread Rick Pasotto
On Fri, Nov 10, 2006 at 05:43:53PM -0500, Kevin Mark wrote: > On Fri, Nov 10, 2006 at 04:39:23PM -0500, Rick Pasotto wrote: > > I just tried to upgrade mysql-server which replaces 4.1 with 5.0. The > > upgrade aborts because there are supposedly MyISAM files and so I should >

Re: mysql upgrade broke server

2006-11-10 Thread Rick Pasotto
On Fri, Nov 10, 2006 at 11:20:50PM +0100, Florian Kulzer wrote: > On Fri, Nov 10, 2006 at 16:39:23 -0500, Rick Pasotto wrote: > > I just tried to upgrade mysql-server which replaces 4.1 with 5.0. The > > upgrade aborts because there are supposedly MyISAM files and so I should >

Re: apt-get mysql-server

2006-11-10 Thread Tom Brown
On Friday 10 November 2006 14:50, Kevin Mark wrote: > On Fri, Nov 10, 2006 at 03:32:42PM -0700, Tom Brown wrote: > > Hello, > > > > I apt-got mysql-server on two debian sarge machines. On the first > > machine, mysql-server 5 was installed. The second machine, mysql

Re: apt-get mysql-server

2006-11-10 Thread Kevin Mark
On Fri, Nov 10, 2006 at 03:32:42PM -0700, Tom Brown wrote: > Hello, > > I apt-got mysql-server on two debian sarge machines. On the first machine, > mysql-server 5 was installed. The second machine, mysql-server 4 was > installed. They both have the same sources.list. Any ideas

Re: apt-get mysql-server

2006-11-10 Thread Tom Brown
On Friday 10 November 2006 14:32, Tom Brown wrote: > I apt-got mysql-server on two debian sarge machines. On the first machine, > mysql-server 5 was installed. The second machine, mysql-server 4 was > installed. They both have the same sources.list. Any ideas why this would > happen?

apt-get mysql-server

2006-11-10 Thread Tom Brown
Hello, I apt-got mysql-server on two debian sarge machines. On the first machine, mysql-server 5 was installed. The second machine, mysql-server 4 was installed. They both have the same sources.list. Any ideas why this would happen? How would I fix this? Thanks, Tom -- To UNSUBSCRIBE

Re: mysql upgrade broke server

2006-11-10 Thread Kevin Mark
On Fri, Nov 10, 2006 at 04:39:23PM -0500, Rick Pasotto wrote: > I just tried to upgrade mysql-server which replaces 4.1 with 5.0. The > upgrade aborts because there are supposedly MyISAM files and so I should > reinstall 4.1 to fix them then try the upgrade again. > > The proble

<    3   4   5   6   7   8   9   10   11   12   >