mysql on linux tutorials written by me for community

[shahryar ghazi]

More MySQL tutorials:

opensource-db-tools - A set of open source tools for MySQL



How to install MySQL Gearman UDF on Ubuntu/Debian
Linux


Installing MySQL Client tools, binaries, and library on
Ubuntu





-- 
Shahryar Ghazi
IT Professional
--
Geeks Worldwide (www.geeksww.com)

Re: Automate Install/Configuration of MySQL on Linux

[Todd E Thomas]

To answer both emails...

My first install is Puppet :)

1) I have many clients (schools with Macs/Linux) that could use this 
package. This is in the works - good call.


For the sake of DRP (Disaster Recovery Planning) I automate all of my 
installs on the 1% off-chance that my backups are partially fouled for 
some reason.


2) I used the .sql file that you recommended and wow - it's so much 
easier than expect.


Once I had the right key-words (mysql .sql script) Google returned the 
right pages:


4.5.1.4. Executing SQL Statements from a Text File
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

The problem I have now is variable substitution. But, that's another thread.

Thanks guys,

TT





On 07/27/2010 11:40 PM, Andrés Tello wrote:
just place all your sql sentences in a file, setup the database and 
then use:


mysql -uroot -hlocalhost < file_with_allsql_you_need.sql
or
cat file_file_with_allsql_you_need.sql  | mysql -u root -hlocalhost

and you are done.


On Tue, Jul 27, 2010 at 3:56 PM, Todd E Thomas 
mailto:todd_...@ssiresults.com>> wrote:


I'm looking for automation direction...

I've found many packages that sit on top of MySQL. For the
purposes of consistency I'd like to automate these installs.

I've been able to automate the install and configuration of
everything except the mysql part.

I'm using CentOS 5.5. Installing/verifying is no big deal.

It's the MySQL configuration that's holding me up.

Basically I've created an expect script. It works 99% but it's a
PITA to finish. Here's what I'd like to accomplish:
 *Set the default admin password
   # mysqladmin -u root password 'root-password'

 *login to mysql
   mysql> mysql -u root -p

 *Drop the anonymous accounts
   mysql> DELETE FROM mysql.user WHERE user = '';

 *Sync all of the root passwords
   mysql> UPDATE mysql.user SET Password =
PASSWORD('root-password') WHERE User = 'root';

 *Remove the test database:
   mysql>  drop database test;


In another script I would like to create databases for specific
packages. EG:
Concrete5, for example needs:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON
concrete5.db TO 'admin'@'localhost' IDENTIFIED BY 'admin-password';



If there is a better way to do this than using expect I would
greatly appreciate any pointers in the right direction. Bash is
comfortable for me and perl is within reach. I'm not much versed
in anything else right now.


--
Thanks for the assist,

Todd E Thomas
"It's a frail music knits the world together."
-Robert Dana

-- 
MySQL General Mailing List

For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=mr.crip...@gmail.com

Re: Automate Install/Configuration of MySQL on Linux

[Rob Wultsch]

On Tue, Jul 27, 2010 at 1:56 PM, Todd E Thomas  wrote:
> I'm looking for automation direction...
>
> I've found many packages that sit on top of MySQL. For the purposes of
> consistency I'd like to automate these installs.
>
> I've been able to automate the install and configuration of everything
> except the mysql part.
>
> I'm using CentOS 5.5. Installing/verifying is no big deal.
>
> It's the MySQL configuration that's holding me up.
>
> Basically I've created an expect script. It works 99% but it's a PITA to
> finish. Here's what I'd like to accomplish:
>  *Set the default admin password
>    # mysqladmin -u root password 'root-password'
>
>  *login to mysql
>    mysql> mysql -u root -p
>
>  *Drop the anonymous accounts
>    mysql> DELETE FROM mysql.user WHERE user = '';
>
>  *Sync all of the root passwords
>    mysql> UPDATE mysql.user SET Password = PASSWORD('root-password') WHERE
> User = 'root';
>
>  *Remove the test database:
>    mysql>  drop database test;
>
>
> In another script I would like to create databases for specific packages.
> EG:
> Concrete5, for example needs:
> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON concrete5.db TO
> 'admin'@'localhost' IDENTIFIED BY 'admin-password';
>
>
>
> If there is a better way to do this than using expect I would greatly
> appreciate any pointers in the right direction. Bash is comfortable for me
> and perl is within reach. I'm not much versed in anything else right now.
>


If you are serious about spending time and doing automation well then
Puppet or cfengine would be the way to go.

As for the basic tasks that you describe, have you considered
modifying the rpm/deb/whatever to distribute a data dir with whatever
you want?

In addition, do you really need expect? Could you get the same effect
with good use of the sleep command inside bash?


-- 
Rob Wultsch
wult...@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Automate Install/Configuration of MySQL on Linux

[Todd E Thomas]

I'm looking for automation direction...

I've found many packages that sit on top of MySQL. For the purposes of 
consistency I'd like to automate these installs.


I've been able to automate the install and configuration of everything 
except the mysql part.


I'm using CentOS 5.5. Installing/verifying is no big deal.

It's the MySQL configuration that's holding me up.

Basically I've created an expect script. It works 99% but it's a PITA to 
finish. Here's what I'd like to accomplish:

  *Set the default admin password
# mysqladmin -u root password 'root-password'

  *login to mysql
mysql> mysql -u root -p

  *Drop the anonymous accounts
mysql> DELETE FROM mysql.user WHERE user = '';

  *Sync all of the root passwords
mysql> UPDATE mysql.user SET Password = PASSWORD('root-password') 
WHERE User = 'root';


  *Remove the test database:
mysql>  drop database test;


In another script I would like to create databases for specific 
packages. EG:

Concrete5, for example needs:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON 
concrete5.db TO 'admin'@'localhost' IDENTIFIED BY 'admin-password';




If there is a better way to do this than using expect I would greatly 
appreciate any pointers in the right direction. Bash is comfortable for 
me and perl is within reach. I'm not much versed in anything else right now.



--
Thanks for the assist,

Todd E Thomas
"It's a frail music knits the world together."
-Robert Dana

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Mysql on linux - choosing the right filesystem

[Kevin Burton]

On 2/24/07, Jean-Sebastien Pilon <[EMAIL PROTECTED]> wrote:


Hello,

I would like to get some of your input on file systems to use with
mysql. Should I use a journaling filesystem ? Should I choose a
different one based on what I store (log files, myisam dbs, innodb
datafiles, etc ) ? Is there any file system tweaks you recommend ?

TIA
NOTICE: This email contains privileged and confidential information and is
intended only for the individual to whom it is addressed. If you are not the
named addressee, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately by e-mail if you have received this
transmission by mistake and delete this communication from your system.
E-mail transmission cannot be guaranteed to be secured or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses.

AVIS: Le présent courriel contient des renseignements de nature
privilégiée et confidentielle et n'est destiné qu'à la personne à qui il est
adressé. Si vous n'êtes pas le destinataire prévu, vous êtes par les
présentes avisés que toute diffusion, distribution ou reproduction de cette
communication est strictement interdite. Si vous avez reçu ce courriel par
erreur, veuillez en aviser immédiatement l'expéditeur et le supprimer de
votre système. Notez que la transmission de courriel ne peut en aucun cas
être considéré comme inviolable ou exempt d'erreur puisque les informations
qu'il contient pourraient être interceptés, corrompues, perdues, détruites,
arrivées en retard ou incomplètes ou contenir un virus.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078

Mysql on linux - choosing the right filesystem

[Jean-Sebastien Pilon]

Hello, 

I would like to get some of your input on file systems to use with
mysql. Should I use a journaling filesystem ? Should I choose a
different one based on what I store (log files, myisam dbs, innodb
datafiles, etc ) ? Is there any file system tweaks you recommend ? 

TIA
NOTICE: This email contains privileged and confidential information and is 
intended only for the individual to whom it is addressed. If you are not the 
named addressee, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately by e-mail if you have received this 
transmission by mistake and delete this communication from your system. E-mail 
transmission cannot be guaranteed to be secured or error-free as information 
could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or 
contain viruses. 

AVIS: Le présent courriel contient des renseignements de nature privilégiée et 
confidentielle et n’est destiné qu'à la personne à qui il est adressé. Si vous 
n’êtes pas le destinataire prévu, vous êtes par les présentes avisés que toute 
diffusion, distribution ou reproduction de cette communication est strictement 
interdite.  Si vous avez reçu ce courriel par erreur, veuillez en aviser 
immédiatement l’expéditeur et le supprimer de votre système. Notez que la 
transmission de courriel ne peut en aucun cas être considéré comme inviolable 
ou exempt d’erreur puisque les informations qu’il contient pourraient être 
interceptés, corrompues, perdues, détruites, arrivées en retard ou incomplètes 
ou contenir un virus.  

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

install mysql on linux AMD64 processor

[jean-marc Jegou]

SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: mysql@lists.mysql.com
Subject: [50 character or so descriptive subject here (for reference)]






>Description:
i try to install mysql-standard-5.0.17_linux-x86_64-glibc23, but it did
not work !

when i run ./mysql_safe --user=mysql & -> message error is "cannot
execute binary file !

mysqld did not work too !




>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: [none | licence | email support | extended email
support ]
>Synopsis:  
>Severity:  <[ non-critical | serious | critical ] (one line)>
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release:   mysql-5.0.17-standard (MySQL Community Edition - Standard
(GPL))

>C compiler:gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>C++ compiler:  gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-52)
>Environment:

System: Linux localhost.localdomain 2.6.9-10.2.aur.2 #1 Thu Feb 10
04:34:27 EST 2005 i686 athlon i386 GNU/Linux
Architecture: i686

Some
paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Lecture des spécification à partir de /usr/lib/gcc/i386-redhat-
linux/3.4.2/specs
Configuré avec: ../configure --prefix=/usr --mandir=/usr/share/man --
infodir=/usr/share/info --enable-shared --enable-threads=posix --
disable-checking --with-system-zlib --enable-__cxa_atexit --disable-
libunwind-exceptions --enable-java-awt=gtk --host=i386-redhat-linux
Modèle de thread: posix
version gcc 3.4.2 20041017 (Red Hat 3.4.2-6)
Compilation info: CC='gcc'  CFLAGS=''  CXX='gcc'  CXXFLAGS=''
LDFLAGS=''  ASFLAGS=''
LIBC: 
lrwxrwxrwx  1 root root 13 sep  8 10:40 /lib/libc.so.6 -> libc-2.3.3.so
-rwxr-xr-x  1 root root 1504728 oct 28  2004 /lib/libc-2.3.3.so
-rw-r--r--  1 root root 2404716 oct 28  2004 /usr/lib/libc.a
-rw-r--r--  1 root root 204 oct 28  2004 /usr/lib/libc.so
Configure command: ./configure '--prefix=/usr/local/mysql' '--
localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/bin'
'--with-comment=MySQL Community Edition - Standard (GPL)' '--with-extra-
charsets=complex' '--with-server-suffix=-standard' '--enable-thread-
safe-client' '--enable-local-infile' '--enable-assembler' '--disable-
shared' '--with-zlib-dir=bundled' '--with-big-tables' '--with-readline'
'--with-archive-storage-engine' '--with-innodb' 'CC=gcc' 'CXX=gcc'




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to start mysql on linux?

[Hassan Schroeder]

Jerry Swanson wrote:
> I have sudo access to Linux box. How to start mysql 4.0.14.

For 4.1, but you can probably figure out the differences :-)

  

-- 
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

  dream.  code.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to start mysql on linux?

[Jerry Swanson]

I have sudo access to Linux box. How to start mysql 4.0.14.

TH

Re: Max Connections of MySQL on Linux

[Gleb Paharenko]

Hello.



Check your results with official binaries. Set max_connections

variable to big enough value. Combinations of different versions of compilers 

and glibc sometimes could give unpredictable results.





"huang leo" <[EMAIL PROTECTED]> wrote:

> Hi, everyone:

>I had done a test on Linux2.6. I got the max connections of 1079 when I 

> complied the MySQL with static link. But I got the max connections of 7159 

> when I complied the MySQL with dynamic link. Why has so much difference 

> between the static link and dynamic link? Has anybody know it?

> 

> $$

>

> Best regards,

> leo huang

> 2005-06-27

> 

> _

> $$$ MSN Hotmail$  http://www.hotmail.com  

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Max Connections of MySQL on Linux

[huang leo]

Hi, everyone:
   I had done a test on Linux2.6. I got the max connections of 1079 when I 
complied the MySQL with static link. But I got the max connections of 7159 
when I complied the MySQL with dynamic link. Why has so much difference 
between the static link and dynamic link? Has anybody know it?


　　

Best regards,
leo huang
2005-06-27

_
享用世界上最大的电子邮件系统― MSN Hotmail。  http://www.hotmail.com  



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

msAccess to Mysql on Linux

[Patrick Marquetecken]

Hi,

I'm trying to move databases from msaccess to Mysql and do this on a Linux
machine.
i have used following tools
mdbtools:
 mdb-export -d# ./recepten.mdb tblRecepten > recepten.txt
dos2unix:
 dos2unix recepten.txt
mysqlimport:
mysqlimport -uroot -p --fields-terminated-by='#'
--fields-optionally-enclosed-by='"' --ignore-lines='1' --replace --verbose
recepten /tmp/recepten.txt

I see in some text fields:
4 stuks bizonmedaillon Covee

some strage signs like  and  anyone a idea how i get rid of it?

Patrick


-- 
Sex is like hacking. You get in, you get out, and you hope you didnt leave
something behind that can be traced back to you.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: New to MySQL on Linux

[Terry Riley]

Thanks, Joshua - just the sort of info I needed.

Off to find a more recent distro

Cheers
Terry

- Original Message -

> On Friday 11 February 2005 09:15, Terry Riley said something like:
> > Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk,
> > that had an apparently unusable XP SP2 OS on it, I decided to wipe
> > the disk and install my first Linux instead, using an ancient RedHat
> > 7.3 distribution.
> 
> First suggestion: get something recent: Suse 9.2, Mandrake 10.1, Fedora 
> Core 3, the latest Debian.  A distro that old will have major security 
> (and probably usability issues).
> 
> > Now the question: If I'm only using this as a database (no
> > development) on RH7.3, which is the preferred download? I am confused
> > by the plethora of options available for Linux. Just need something
> > that is relatively simple to install (either 4.1.9 or 5.0.x).
> 
> I would doubt the current MySQL RPM's would support something as old as 
> RH 7.3.  If you install something recent, there will be recent versions 
> of MySQL (Mandrake even has 5.0 in the contrib section, I would assume 
> Fedora would too.
> 
> You will have to intstall the server portion, and probably the client 
> portion.  You then can use the MySQL GUI tools to admin the box from a 
> Windows machine.
> 
> Using something like Mandrake or Fedora, their installer tools will 
> resolve all the dependencies for you.
> 
> Hope that gets you started a little.  If you need more detail, feel 
> free to ask.
> 
> j- k-
> 
> 
> -- 
> Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
> Every knee shall bow, and every tongue confess, in heaven, on earth, 
> and under the earth, that Jesus Christ is LORD -- Count on it!



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: New to MySQL on Linux

[Joshua J. Kugler]

On Friday 11 February 2005 09:15, Terry Riley said something like:
> Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk,
> that had an apparently unusable XP SP2 OS on it, I decided to wipe
> the disk and install my first Linux instead, using an ancient RedHat
> 7.3 distribution.

First suggestion: get something recent: Suse 9.2, Mandrake 10.1, Fedora 
Core 3, the latest Debian.  A distro that old will have major security 
(and probably usability issues).

> Now the question: If I'm only using this as a database (no
> development) on RH7.3, which is the preferred download? I am confused
> by the plethora of options available for Linux. Just need something
> that is relatively simple to install (either 4.1.9 or 5.0.x).

I would doubt the current MySQL RPM's would support something as old as 
RH 7.3.  If you install something recent, there will be recent versions 
of MySQL (Mandrake even has 5.0 in the contrib section, I would assume 
Fedora would too.

You will have to intstall the server portion, and probably the client 
portion.  You then can use the MySQL GUI tools to admin the box from a 
Windows machine.

Using something like Mandrake or Fedora, their installer tools will 
resolve all the dependencies for you.

Hope that gets you started a little.  If you need more detail, feel free 
to ask.

j- k-


-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and 
under the earth, that Jesus Christ is LORD -- Count on it!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: New to MySQL on Linux

[Terry Riley]

Thanks to all who replied - food for thought...

Cheers
Terry
- Original Message -

> Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that 
> had an apparently unusable XP SP2 OS on it, I decided to wipe the disk 
> and install my first Linux instead, using an ancient RedHat 7.3 
> distribution.
> 
> Having done that successfully, and increased the memory from 256 to 
> 768Mb, I think I'm now ready to install the latest MySQL on it. All my 
> previous MySQL experience, unfortunatley, has been on WinNT, usually 
> installed with the msi installer.
> 
> Now the question: If I'm only using this as a database (no development) 
> on RH7.3, which is the preferred download? I am confused by the 
> plethora of options available for Linux. Just need something that is 
> relatively simple to install (either 4.1.9 or 5.0.x).
> 
> Suggestions, please?
> 
> Cheers
> Terry Riley



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: New to MySQL on Linux

[Dean, Michael L USAATC]

I'd have to agree with Hassan here, with MySQL having the binaries built,
it's quite easy if you can set PATHs and make some symbolic links (for
"service mysql start" to work).

Michael 

-Original Message-
From: Hassan Schroeder [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 11, 2005 2:31 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: Re: New to MySQL on Linux

Terry Riley wrote:

> install my first Linux instead, using an ancient RedHat 7.3 distribution.
> 
> Having done that successfully, and increased the memory from 256 to 
> 768Mb, I think I'm now ready to install the latest MySQL on it. All my 
> previous MySQL experience, unfortunatley, has been on WinNT, usually 
> installed with the msi installer.
> 
> Now the question: If I'm only using this as a database (no 
> development) on RH7.3, which is the preferred download? I am confused 
> by the plethora of options available for Linux. Just need something 
> that is relatively simple to install (either 4.1.9 or 5.0.x).

Personally, I hate installers, so I'd get the non-rpm Linux distro.
Unzip/untar and you have a nice self-contained directory, so *you* know
where everything is, in case you want to de-install, install a later version
in parallel, etc.

And as it happens, that's at the very top of the list on the MySQL downloads
page :-)

Linux (x86, glibc-2.2, static, gcc) Standard 4.1.9  26.9M

HTH!
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com

   dream.  code.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: New to MySQL on Linux

[Hassan Schroeder]

Terry Riley wrote:
install my first Linux instead, using an ancient RedHat 7.3 distribution.
Having done that successfully, and increased the memory from 256 to 768Mb, 
I think I'm now ready to install the latest MySQL on it. All my previous 
MySQL experience, unfortunatley, has been on WinNT, usually installed with 
the msi installer.

Now the question: If I'm only using this as a database (no development) on 
RH7.3, which is the preferred download? I am confused by the plethora of 
options available for Linux. Just need something that is relatively simple 
to install (either 4.1.9 or 5.0.x).
Personally, I hate installers, so I'd get the non-rpm Linux distro.
Unzip/untar and you have a nice self-contained directory, so *you*
know where everything is, in case you want to de-install, install a
later version in parallel, etc.
And as it happens, that's at the very top of the list on the MySQL
downloads page :-)
Linux (x86, glibc-2.2, static, gcc) Standard 4.1.9  26.9M
HTH!
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design ===  (+1) 408-938-0567   === http://webtuitive.com
  dream.  code.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: New to MySQL on Linux

[Andy]

On Fri February 11 2005 19:15, Terry Riley wrote:
> Now the question: If I'm only using this as a database (no development) on
> RH7.3, which is the preferred download? I am confused by the plethora of
> options available for Linux. Just need something that is relatively simple
> to install (either 4.1.9 or 5.0.x).
>
Well you should know that you can just install MySQL from withing your install 
cd. (at least with RH-9).

If not, I recommend you use the RH update utility.  up2date (requires root 
privileges) and then just choose MySQL from the list of items.  Then 
installing it is as simple as clicking finish.


Good luck and kind regards

PS: if you prefer commandline utilities, you might interest yourself in 

apt-get

See www.apt-get.org (it says it's for debian but I use it for my Fedora Core 
which is RedHat anyway)

Once you've installed it, installing any package is as simple as typing 
(example for mysql) 

apt-get install mysql

it will download the packages and perform the installation (note: root 
privileges required)



Andy

-- 
---
Registered Linux user number 379093
---

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

New to MySQL on Linux

[Terry Riley]

Having inherited an elderly PIII/500MHz box with an 8Gb SCSI disk, that 
had an apparently unusable XP SP2 OS on it, I decided to wipe the disk and 
install my first Linux instead, using an ancient RedHat 7.3 distribution.

Having done that successfully, and increased the memory from 256 to 768Mb, 
I think I'm now ready to install the latest MySQL on it. All my previous 
MySQL experience, unfortunatley, has been on WinNT, usually installed with 
the msi installer.

Now the question: If I'm only using this as a database (no development) on 
RH7.3, which is the preferred download? I am confused by the plethora of 
options available for Linux. Just need something that is relatively simple 
to install (either 4.1.9 or 5.0.x).

Suggestions, please?

Cheers
Terry Riley


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update on installing mysql on linux

[Egor Egorov]

"Levi Campbell" <[EMAIL PROTECTED]> wrote:

> Okay, I got the RPM package installed but when I use rpm -I =
> mysql-server-4.0.20-0.i386.rpm, I am told that I need several files, =
> most of which I can't find in the Debian package library. I need the =
> following files: /usr/bin/perl, sh-utils and sh, where can I get these?

Install it like this: 

rpm --install -v -h --nodeps MySQL-server-4.0.20-0.i386.rpm ... and other rpms

Debian RPM database may be missing some dependencies but the chances are that MySQL
will work installed without dependency check. 





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update on installing mysql on linux

[Philippe Poelvoorde]

Levi Campbell wrote:
Okay, I got the RPM package installed but when I use rpm -I mysql-server-4.0.20-0.i386.rpm, I am told that I need several files, most of which I can't find in the Debian package library. I need the following files: /usr/bin/perl, sh-utils and sh, where can I get these?
my guess is that your RPM configuration don't know about packages 
installed with apt-get. try to post on debian-list ?

--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Update on installing mysql on linux

[Levi Campbell]

Okay, I got the RPM package installed but when I use rpm -I 
mysql-server-4.0.20-0.i386.rpm, I am told that I need several files, most of which I 
can't find in the Debian package library. I need the following files: /usr/bin/perl, 
sh-utils and sh, where can I get these?

Re: cannot install mysql on linux using RPM's

[Egor Egorov]

"Levi Campbell" <[EMAIL PROTECTED]> wrote:

> Hi, I'm trying to install MySQL on Debian Linux on an old computer whe =
> had lying around. (Pentium 2 or three) and I'm trying to install the RPM =
> files so I can install the software. my problem is with the Perl debian =
> packages, I can't get them configured, can anyone help?

So you can't install MySQL packages or perl packages? 

If the problem is in MySQL RPMs, use "mysql binary distribution" downloaded
from http://www.mysql.com/ The one in .tar.gz, not in RPM. 

If you are trying to install Perl DBI modules from RPM and you cannot, download
them and install manually from http://dbi.perl.org/





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

cannot install mysql on linux using RPM's

[Levi Campbell]

Hi, I'm trying to install MySQL on Debian Linux on an old computer whe had lying 
around. (Pentium 2 or three) and I'm trying to install the RPM files so I can install 
the software. my problem is with the Perl debian packages, I can't get them 
configured, can anyone help?

Failed reports for installing MySQL on Linux(AMD64)

[sclinm]

Hi,
Deeply appreciated your helps.

(See attached file: failed_mysql_report)

S.C. Lin 林聖哲
Taiwan Semiconductor Manufacturing Company, Ltd.
No. 6, Li-Hsin Rd.6, Science-Based Industrial Park Hsin-Chu, Taiwan 300-77,
R.O.C.
Tel: 03-666
Ext: 4770
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Restore problem between MySQL on Win32 and MySQL on Linux?

[g . lams]

It works like a charme with the -Q option

Thank you

Gael

Victoria Reznichenko <[EMAIL PROTECTED]> wrote on 23/04/2004 
11.26.01:

> [EMAIL PROTECTED] wrote:
> > 
> > I performed the backup (mysqldump -u username -p db > backup.sql) of a 

> > database on a Win32 (4.0.15-max-debug) server in order to restore it 
on 
> > Linux server (4.0.15-9)
> > When I try to restore it on the linux machine (with mysql -u username 
-p 
> > db < backup.sql), there is an error saying:
> > ERROR 1064 at line 12748: You have an error in your SQL syntax.  Check 
the 
> > manual that corresponds to your MySQL server version for the right 
syntax 
> > to use near 'Order tinyint(4) default NULL
> > ) TYPE=MyISAM' at line 6
> > 
> > I searched the mailing list but nothing seems to apply to my case.
> > The database has been created with the same name, cmsdb, which has no 
> > special characters
> > 
> 
> ORDER is a reserved  word in MySQL:
>http://dev.mysql.com/doc/mysql/en/Reserved_words.html
> 
> Use -Q (--quote-names) option of mysqldump.
> 
> 
> -- 
> For technical support contracts, goto 
https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
> 
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 

Re: Restore problem between MySQL on Win32 and MySQL on Linux?

[Victoria Reznichenko]

[EMAIL PROTECTED] wrote:
> 
> I performed the backup (mysqldump -u username -p db > backup.sql) of a 
> database on a Win32 (4.0.15-max-debug) server in order to restore it on 
> Linux server (4.0.15-9)
> When I try to restore it on the linux machine (with mysql -u username -p 
> db < backup.sql), there is an error saying:
> ERROR 1064 at line 12748: You have an error in your SQL syntax.  Check the 
> manual that corresponds to your MySQL server version for the right syntax 
> to use near 'Order tinyint(4) default NULL
> ) TYPE=MyISAM' at line 6
> 
> I searched the mailing list but nothing seems to apply to my case.
> The database has been created with the same name, cmsdb, which has no 
> special characters
> 

ORDER is a reserved  word in MySQL:
http://dev.mysql.com/doc/mysql/en/Reserved_words.html

Use -Q (--quote-names) option of mysqldump.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Restore problem between MySQL on Win32 and MySQL on Linux?

[g . lams]

Hi All,

I performed the backup (mysqldump -u username -p db > backup.sql) of a 
database on a Win32 (4.0.15-max-debug) server in order to restore it on 
Linux server (4.0.15-9)
When I try to restore it on the linux machine (with mysql -u username -p 
db < backup.sql), there is an error saying:
ERROR 1064 at line 12748: You have an error in your SQL syntax.  Check the 
manual that corresponds to your MySQL server version for the right syntax 
to use near 'Order tinyint(4) default NULL
) TYPE=MyISAM' at line 6

I searched the mailing list but nothing seems to apply to my case.
The database has been created with the same name, cmsdb, which has no 
special characters

Any help would be appreciated

Gael

first rows of backup file:

-- MySQL dump 9.09
--
-- Host: localhostDatabase: cmsdb
-
-- Server version   4.0.15-max-debug

--
-- Table structure for table `block`
--

CREATE TABLE block (
  BlockID int(11) NOT NULL auto_increment,
  PageID int(11) default NULL,
  BlockOrder int(11) default NULL,
  StyleID int(11) default NULL,
  BlockTypeID int(11) default NULL,
  PRIMARY KEY  (BlockID)
) TYPE=MyISAM;

--
-- Dumping data for table `block`
--

INSERT INTO block VALUES (202176,8908,1,136,NULL);
INSERT INTO block VALUES (201758,8890,2,150,NULL);
INSERT INTO block VALUES (201757,8890,2,162,NULL);
INSERT INTO block VALUES (201756,8890,1,162,NULL);
INSERT INTO block VALUES (201755,8890,2,148,NULL);
INSERT INTO block VALUES (201754,8890,1,110,NULL);
INSERT INTO block VALUES (201753,8890,1,147,NULL);

and then around row 12748:

-- Table structure for table `contenttypeversion`
--

CREATE TABLE contenttypeversion (
  ContentTypeID int(11) default NULL,
  VersionID int(11) default NULL,
  Name varchar(100) default NULL,
  HTML_Label blob,
  Order tinyint(4) default NULL
) TYPE=MyISAM;

--

Re: MySQL on Linux

[Dan]

Perhaps stated a bit more correctly:

Apache is NOT unique to Linux, so any system using Apache would need this
configuration, that would include windows, MAC OS, Solaris, Irix, etc.
Can't blame the OS on a softwares requirements...

Dan.
At 08:07 AM 4/9/2004, Paul Smith wrote:
%% Dan Nelson <[EMAIL PROTECTED]> writes:

  dn> That is because although Linux binaries can access files over 2gb,
  dn> they do not do so by default.  Apache was probably not compiled
  dn> with the required defines (-D_LARGEFILE_SOURCE
  dn> -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though
  dn> both the kernel and filesystem most likely do support larger
  dn> files.
Just to point out this (needing extra compile flags to get large file
support) is not unique to Linux.  Most OSs require these kinds of flags;
Solaris for example also requires special flags to get LFS.
--
---
 Paul D. Smith <[EMAIL PROTECTED]>   HASMAT--HA Software Mthds & 
Tools
 "Please remain calm...I may be mad, but I am a professional." --Mad 
Scientist
---
   These are my opinions---Nortel Networks takes no responsibility for them.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Paul Smith]

%% Dan Nelson <[EMAIL PROTECTED]> writes:

  dn> That is because although Linux binaries can access files over 2gb,
  dn> they do not do so by default.  Apache was probably not compiled
  dn> with the required defines (-D_LARGEFILE_SOURCE
  dn> -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even though
  dn> both the kernel and filesystem most likely do support larger
  dn> files.

Just to point out this (needing extra compile flags to get large file
support) is not unique to Linux.  Most OSs require these kinds of flags;
Solaris for example also requires special flags to get LFS.

-- 
---
 Paul D. Smith <[EMAIL PROTECTED]>   HASMAT--HA Software Mthds & Tools
 "Please remain calm...I may be mad, but I am a professional." --Mad Scientist
---
   These are my opinions---Nortel Networks takes no responsibility for them.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Benjamin Arai]

Just to be complete, linux does have limitations depending upon
limitations of the file-system, and the kernel.  All modern filesystems
(XFS, EXT3, ...) all allow files over a terabyte is size.

On Tue, 2004-04-06 at 13:39, Ronan Lucio wrote:

> > Uhm,
> > what are you talking about?!?
> 
> When I put our site on a Linux system, apache stop working when
> it´s logfile get major than 2 Gb.
> 
> I was afraid of it´d happen with MySQL, too.
> 
> > Linux has no such limitation.
> > you can grow files as large as you like.
> > right now I have an InnoDB dbase with Mysql on a linux
> > system and the file is over 60 GIGS in size!
> 
> Great!!! So, I don´t need to worry about it... :-)
> 
> Thanks Dan,
> Ronan

Benjamin Arai
Araisoft

Email: [EMAIL PROTECTED]
Website: http://www.araisoft.com

Re: MySQL on Linux

[dan]

Well I guess it depends on what is meant by "Default".
I was using RH8 and had no such issues, even with RH7...

I think it's important to note the filesystem chosen
can make a huge difference.

as of RH8 and onward I'd suggest EXT3, especially for Peter's
issue of possible corruption - because it is a fully journalling
filesystem.

of course, a filesystem cannot (and will not) overcome issues with the
software or OS itself. It's always best to use the latest "stable"
Mysql (4.0.18 as of last I checked), and don't always upgrade "just
because".

too many admins will upgrade just because the latest thing is out,
if it's working, stable, etc, leave it alone. don't fix it if it aint
broke.

the point is, choosing the right options during install. myself, I never
had an issue with the defaults, even back as far as RH7, using files
larger than 2gigs with mysql. perhaps because I always choose the best
file system available at the time. I chose journalling as soon as it was
available, things like ReiserFS come to mind.

for me, large files was always the default, never had to choose it
manually or change any settings. oh well...

Dan.


On Wed, 7 Apr 2004, Peter J Milanese wrote:

> I ran into the same issues on RH8, with a default implmentation. It can be 
> overcome, but the mysql failed to 
> write to the table after 2gb or so. It turned out to be a filesystem 
> limitation issue, which was fixable. I am 
> not sure, but given the size of files nowadays, RH9 defaults probably take 
> care of it. I am currently running
> several very large tables on RH8 (5-30G) and it is stable. One should 
> always beware that large tables
> can easily be corrupted, and are not a joy to recover though  :-/
> 
> 
> P
>  
> 
> 
> 
> 
> Alan Williamson <[EMAIL PROTECTED]>
> 04/06/2004 05:57 PM
>  
> To: Dan Nelson <[EMAIL PROTECTED]>
> cc: [EMAIL PROTECTED]
> Subject:Re: MySQL on Linux
> 
> 
> Thank you, a much reasoned and sensible reply.
> 
> This is information people can use, as oppose to the posts that 'say 
> well its okay for me, you must be stupid' types.
> 
> ;)
> 
> 
> Dan Nelson wrote:
> 
> > In the last episode (Apr 06), Alan Williamson said:
> > 
> >>>the most popular would have been Red Hat, which doesn't have this
> >>>limit you speak of, even plain vanilla install (no twiddling
> >>>needed).
> >>
> >>Not to spoil a perfectly good pontification ... but i have to say
> >>that we have a Redhat8 distribution running on a Dell PowerEdge
> >>Server and when Apache gets to the 2GB size on its access file, it
> >>does indeed stop.  This is not old hardware (12months old).
> > 
> > 
> > That is because although Linux binaries can access files over 2gb, they
> > do not do so by default.  Apache was probably not compiled with the
> > required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so
> > that's why it stops at 2gb even though both the kernel and filesystem
> > most likely do support larger files.
> > 
> > 
> >>So the question still remains.  What would happen in MySQL when that 
> >>file isn't allowed to grow any further?
> > 
> > 
> > Mysql's configure script checks for systems that require special flags
> > to access large files, so no mysql binaries should have this problem on
> > modern Linux systems (i.e. any 2.4 kernel)
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Peter J Milanese]

I ran into the same issues on RH8, with a default implmentation. It can be 
overcome, but the mysql failed to 
write to the table after 2gb or so. It turned out to be a filesystem 
limitation issue, which was fixable. I am 
not sure, but given the size of files nowadays, RH9 defaults probably take 
care of it. I am currently running
several very large tables on RH8 (5-30G) and it is stable. One should 
always beware that large tables
can easily be corrupted, and are not a joy to recover though  :-/


P
 




Alan Williamson <[EMAIL PROTECTED]>
04/06/2004 05:57 PM
 
To: Dan Nelson <[EMAIL PROTECTED]>
cc: [EMAIL PROTECTED]
Subject:    Re: MySQL on Linux


Thank you, a much reasoned and sensible reply.

This is information people can use, as oppose to the posts that 'say 
well its okay for me, you must be stupid' types.

;)


Dan Nelson wrote:

> In the last episode (Apr 06), Alan Williamson said:
> 
>>>the most popular would have been Red Hat, which doesn't have this
>>>limit you speak of, even plain vanilla install (no twiddling
>>>needed).
>>
>>Not to spoil a perfectly good pontification ... but i have to say
>>that we have a Redhat8 distribution running on a Dell PowerEdge
>>Server and when Apache gets to the 2GB size on its access file, it
>>does indeed stop.  This is not old hardware (12months old).
> 
> 
> That is because although Linux binaries can access files over 2gb, they
> do not do so by default.  Apache was probably not compiled with the
> required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so
> that's why it stops at 2gb even though both the kernel and filesystem
> most likely do support larger files.
> 
> 
>>So the question still remains.  What would happen in MySQL when that 
>>file isn't allowed to grow any further?
> 
> 
> Mysql's configure script checks for systems that require special flags
> to access large files, so no mysql binaries should have this problem on
> modern Linux systems (i.e. any 2.4 kernel)


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL on Linux

[DChristensen]

What we've done on Red Hat 7.3, 8.0 and 9.0 boxes, then on a SuSE 9.0 box is
to set up InnoDB and have multiple files defined at 2GB.  We just keep
adding additional files as we need them and performance seems to be holding
okay.

-Original Message-
From: Eric Gunnett [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 06, 2004 4:54 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: MySQL on Linux


  I have had this happen on 2 boxes one running Redhat 7.2 and the other
running Redhat 8. I can tell MySQL does not like not being able to write to
the file anymore. We were using MySQL 3.23 on one box and 4 on the other
box. The table crashed. Causing a lot of corruption. In one instance it
actually took the table and zeroed it out leaving me with no data, and
having to recover the 2 gig table, then watching it happen again.



Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED]


>>> Alan Williamson <[EMAIL PROTECTED]> 04/06/04 02:47PM >>>


dan wrote:

> the most popular would have been Red Hat, which doesn't have this 
> limit you speak of, even plain vanilla install (no twiddling needed).

Not to spoil a perfectly good pontification ... but i have to say that 
we have a Redhat8 distribution running on a Dell PowerEdge Server and 
when Apache gets to the 2GB size on its access file, it does indeed 
stop.  This is not old hardware (12months old).

So don't be spouting any sweeping statements.  If your distribution 
doesn't have that limitation, then fantastic, good for you.  But for 
others it is indeed a real limitation.

The original question was indeed a geniue one, and while the poster 
accidently typed in the wrong size, i wouldn't be so quick to jump all 
over him.

So the question still remains.  What would happen in MySQL when that 
file isn't allowed to grow any further?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Alan Williamson]

Thank you, a much reasoned and sensible reply.

This is information people can use, as oppose to the posts that 'say 
well its okay for me, you must be stupid' types.

;)

Dan Nelson wrote:

In the last episode (Apr 06), Alan Williamson said:

the most popular would have been Red Hat, which doesn't have this
limit you speak of, even plain vanilla install (no twiddling
needed).
Not to spoil a perfectly good pontification ... but i have to say
that we have a Redhat8 distribution running on a Dell PowerEdge
Server and when Apache gets to the 2GB size on its access file, it
does indeed stop.  This is not old hardware (12months old).


That is because although Linux binaries can access files over 2gb, they
do not do so by default.  Apache was probably not compiled with the
required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so
that's why it stops at 2gb even though both the kernel and filesystem
most likely do support larger files.
 

So the question still remains.  What would happen in MySQL when that 
file isn't allowed to grow any further?


Mysql's configure script checks for systems that require special flags
to access large files, so no mysql binaries should have this problem on
modern Linux systems (i.e. any 2.4 kernel)


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Dan Nelson]

In the last episode (Apr 06), Alan Williamson said:
> >the most popular would have been Red Hat, which doesn't have this
> >limit you speak of, even plain vanilla install (no twiddling
> >needed).
> 
> Not to spoil a perfectly good pontification ... but i have to say
> that we have a Redhat8 distribution running on a Dell PowerEdge
> Server and when Apache gets to the 2GB size on its access file, it
> does indeed stop.  This is not old hardware (12months old).

That is because although Linux binaries can access files over 2gb, they
do not do so by default.  Apache was probably not compiled with the
required defines (-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64), so
that's why it stops at 2gb even though both the kernel and filesystem
most likely do support larger files.
 
> So the question still remains.  What would happen in MySQL when that 
> file isn't allowed to grow any further?

Mysql's configure script checks for systems that require special flags
to access large files, so no mysql binaries should have this problem on
modern Linux systems (i.e. any 2.4 kernel)


-- 
Dan Nelson
[EMAIL PROTECTED]

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Chris W]

Brad Tilley wrote:

On Tuesday 06 April 2004 17:28, dan wrote:
 

Just wanted to point out that 32 bit 
systems have limitations. 2^32 = 4 billion that's the max. Addressing more space than that requires a bit of black magic. 

All it takes a some arbitrary precision math.  Since we are talking 
about integers, that's not all that hard, and far from black magic.  But 
I digress :)

Chris W

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Eric Gunnett]

  I have had this happen on 2 boxes one running Redhat 7.2 and the other running 
Redhat 8. I can tell MySQL does not like not being able to write to the file anymore. 
We were using MySQL 3.23 on one box and 4 on the other box. The table crashed. Causing 
a lot of corruption. In one instance it actually took the table and zeroed it out 
leaving me with no data, and having to recover the 2 gig table, then watching it 
happen again.



Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED]


>>> Alan Williamson <[EMAIL PROTECTED]> 04/06/04 02:47PM >>>


dan wrote:

> the most popular would have been Red Hat, which doesn't have this limit
> you speak of, even plain vanilla install (no twiddling needed).

Not to spoil a perfectly good pontification ... but i have to say that 
we have a Redhat8 distribution running on a Dell PowerEdge Server and 
when Apache gets to the 2GB size on its access file, it does indeed 
stop.  This is not old hardware (12months old).

So don't be spouting any sweeping statements.  If your distribution 
doesn't have that limitation, then fantastic, good for you.  But for 
others it is indeed a real limitation.

The original question was indeed a geniue one, and while the poster 
accidently typed in the wrong size, i wouldn't be so quick to jump all 
over him.

So the question still remains.  What would happen in MySQL when that 
file isn't allowed to grow any further?


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Alan Williamson]

dan wrote:

the most popular would have been Red Hat, which doesn't have this limit
you speak of, even plain vanilla install (no twiddling needed).
Not to spoil a perfectly good pontification ... but i have to say that 
we have a Redhat8 distribution running on a Dell PowerEdge Server and 
when Apache gets to the 2GB size on its access file, it does indeed 
stop.  This is not old hardware (12months old).

So don't be spouting any sweeping statements.  If your distribution 
doesn't have that limitation, then fantastic, good for you.  But for 
others it is indeed a real limitation.

The original question was indeed a geniue one, and while the poster 
accidently typed in the wrong size, i wouldn't be so quick to jump all 
over him.

So the question still remains.  What would happen in MySQL when that 
file isn't allowed to grow any further?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Brad Tilley]

On Tuesday 06 April 2004 17:28, dan wrote:
> nice flame! :)
> btw-
> Doesnt exist in out-of-the-box Linux distros,
> or any distro you can currently download.
> or any distro you could download (or buy) over the last few years.
>
> it doesnt occur in "vanilla" distributions or any other
> retail, commercial, or otherwise distribution...

Sorry, didn't mean to sound flameish. Just wanted to point out that 32 bit 
systems have limitations. 2^32 = 4 billion that's the max. Addressing more 
space than that requires a bit of black magic. That's why IPv4 only has 4 
billion IP addresses... why x86 systems only support 4GB of RAM... why linux 
systems w/o the LFS black magic are limited to 2GB file sizes. For 
addressable space more than that one needs 64 bits... no black magic there.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[dan]

nice flame! :)
btw-
Doesnt exist in out-of-the-box Linux distros,
or any distro you can currently download.
or any distro you could download (or buy) over the last few years.

it doesnt occur in "vanilla" distributions or any other
retail, commercial, or otherwise distribution...

well maybe Suse, since I stopped looking at it once it went commercial.
but SUSE is NOT the linux standard. Neither are any of them actually.

the most popular would have been Red Hat, which doesn't have this limit
you speak of, even plain vanilla install (no twiddling needed).

contrary to your statement, SUSE is not the bar by which other linux's are
measured.

Did you even read that document you're referring to?
I think you should at least READ it before speaking up on stuff you know
nothing about.

Look at it, it refers to linux kernel 2.4.0-test7, not even a release
kernel. and glibc 2.1 and all the way back to SUSE 7.0 running the 2.2
kernel! It also refers to Red Hat 6.2, I mean, come on man...

taking a document like that, which has been sparsely updated to reflect
new versions of Linux and just says "now has support" for those versions
is hardly a decent reference...

any current linux in any format will support large files "out of the box"
as they say. so yes, I know what I'm talking about, thanks.

sheesh.

> He's talking about a 32 bit filesystem w/o large file support. There is indeed 
> a 2GB limit on such systems. You may want to read this before speaking up 
> again: http://www.suse.de/~aj/linux_lfs.html
> 
> 
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Brad Tilley]

On Tuesday 06 April 2004 16:31, dan wrote:
> Uhm,
> what are you talking about?!?
>
> Linux has no such limitation.
> you can grow files as large as you like.
> right now I have an InnoDB dbase with Mysql on a linux
> system and the file is over 60 GIGS in size!
>
> maybe you meant 2 Tb? and if you did, let's see you make one that big.
>
> Dan.

He's talking about a 32 bit filesystem w/o large file support. There is indeed 
a 2GB limit on such systems. You may want to read this before speaking up 
again: http://www.suse.de/~aj/linux_lfs.html



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Ronan Lucio]

> Uhm,
> what are you talking about?!?

When I put our site on a Linux system, apache stop working when
it´s logfile get major than 2 Gb.

I was afraid of it´d happen with MySQL, too.

> Linux has no such limitation.
> you can grow files as large as you like.
> right now I have an InnoDB dbase with Mysql on a linux
> system and the file is over 60 GIGS in size!

Great!!! So, I don´t need to worry about it... :-)

Thanks Dan,
Ronan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[Pete Harlan]

The 2GB (not 2 Mb) file size limitation on Linux went away years ago.
Unless your distribution is very old you won't have a problem.

--Pete


On Tue, Apr 06, 2004 at 05:05:59PM -0300, Ronan Lucio wrote:
> Hi All,
> 
> I always worked with MySQL on FreeBSD systems.
> 
> Now I need to install am MySQL with InnoDB and MyISAM
> tables in ta Linux RH system.
> 
> So, do I need to care about the Linux file size limitation of 2 Mb?
> Or MySQL deal this situation with Linux FS?
> 
> In other words, will my MySQL stop working when the database
> get major then 2 Mb?
> Or such situation won?t happen?
> 
> thanks
> Ronan
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL on Linux

[dan]

Uhm,
what are you talking about?!?

Linux has no such limitation.
you can grow files as large as you like.
right now I have an InnoDB dbase with Mysql on a linux
system and the file is over 60 GIGS in size!

maybe you meant 2 Tb? and if you did, let's see you make one that big.

Dan.

On Tue, 6 Apr 2004, Ronan Lucio wrote:

> Hi All,
> 
> I always worked with MySQL on FreeBSD systems.
> 
> Now I need to install am MySQL with InnoDB and MyISAM
> tables in ta Linux RH system.
> 
> So, do I need to care about the Linux file size limitation of 2 Mb?
> Or MySQL deal this situation with Linux FS?
> 
> In other words, will my MySQL stop working when the database
> get major then 2 Mb?
> Or such situation won´t happen?
> 
> thanks
> Ronan
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL on Linux

[Ronan Lucio]

Hi All,

I always worked with MySQL on FreeBSD systems.

Now I need to install am MySQL with InnoDB and MyISAM
tables in ta Linux RH system.

So, do I need to care about the Linux file size limitation of 2 Mb?
Or MySQL deal this situation with Linux FS?

In other words, will my MySQL stop working when the database
get major then 2 Mb?
Or such situation won´t happen?

thanks
Ronan




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Installing MySQL on Linux, HELP!

[dpgirago]

And then Eve said...

>After some trouble with rpm, I managed to create a file of installed
>packages. Redhat 9 says I have installed:

>MySQL-client-4.0.1-2
>perl-DBD-MySQL-2.1021-3
>mysql-3.23.58-1.9
>mysql-server-3.23.58-1.9

That's right. That's what you get with RH9. I'm repeating myself here from 
my email to you directly last evening, but I'd use the very clear, very 
accurate manual to build and install from source given at 
http://www.InternetSecurityGuru.com. Everything in that manual, related 
especially to MySQL, works just as documented. 

>And I am not having any luck with these...starting them, installing them,
>compiling them. I have read manuals, taken advice, but nothing 
comprehensive
>to get things to work.

>I would prefer to install a version of at least 4 for a server.

The manual uses 4.0.16 but you could substitute whatever version you'd 
like. 

>Any help is appreciated!

Help was given. You refused it.

>Thanks,
>Eve

BTW, at a MySQL training course I attended, the instructor advised _NOT_ 
to go the rpm route.

dave

RE: Installing MySQL on Linux, HELP!

[Eve Atley]

After some trouble with rpm, I managed to create a file of installed
packages. Redhat 9 says I have installed:

MySQL-client-4.0.1-2
perl-DBD-MySQL-2.1021-3
mysql-3.23.58-1.9
mysql-server-3.23.58-1.9

And I am not having any luck with these...starting them, installing them,
compiling them. I have read manuals, taken advice, but nothing comprehensive
to get things to work.

I would prefer to install a version of at least 4 for a server.

Any help is appreciated!

Thanks,
Eve



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Installing MySQL on Linux, HELP!

[Scott Pippin]

>I was going to output a new list of installed packages to ensure that mysql
>was in there, but rpm -qa | ./installed_packages doesn't seem to work at the
>moment...I can't restart the server right now, so perhaps I could kill and
>restart some process? However, this is from yesterday's output:
 
The RPM database can become corrupted, causing the rpm -qa to hang.  To rebuild the 
database follow the following instructions:
 
ps -ef |grep rpm  - kill all rpm processes
rm -rf /var/lib/rpm/__db*
rpm --rebuild
 
You should then be able to query the rpms.

Scott Pippin
[EMAIL PROTECTED]

RE: Installing MySQL on Linux, HELP!

[Eve Atley]

I have had some help on my mysql install woes, and here's the latest.

rpm -qa | grep MySQL - this just hung and never returned anything (see
below)
# service mysqld start
or
# service mysql start - these just returned a new command prompt, so
couldn't tell whether or not they worked. I checked my processes and never
saw mysqld.

I put in 'whereis mysql', and this returned:
/usr/bin/mysql
/user/lib/mysql
/user/share/mysql
/user/share/man/man1/mysql.1.gz

I was going to output a new list of installed packages to ensure that mysql
was in there, but rpm -qa | ./installed_packages doesn't seem to work at the
moment...I can't restart the server right now, so perhaps I could kill and
restart some process? However, this is from yesterday's output:
postgresql-libs-7.3.4-3.rhl9
postgresql-7.3.4-3.rhl9
mysql-3.23.58-1.9
mysql-server-3.23.58-1.9
postgresql-server-7.3.4-3.rhl9

Thanks,
Eve



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Installing MySQL on Linux, HELP!

[Eve Atley]

Well, RedHat 9 says mysql is *already* installed. But I can't start it. And
when I attempt to configure it using mysql_install_db, it says to run make
install on it first. When I try to ./configure, it says it can't be found.
(i know gcc exists) When trying "make && make install", it says nothing to
be done.

Now I think I'm just goofing things up. Ran a 4.0.1 rpm, and it said it
installed; but still nothing. Then ran another one, and now it says
dependencies are missing.

I am following instructions from http://www.brtnet.org/linux/lamp.htm.

- Eve




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Japanese display problem with mysql on Linux

[kayamboo]

Hi folks
  I wrote an application which uses japanese characters. I can display
japanese characters, fetching from a mysql database on my WindowsXP
machine.
  I moved the same to a Linux machine and could see only junk characters.


Any suggestions?

MySQL version 4.0.13 on Win XP Japanese
MySQL version 4.0.14 on Linux English

But the charset is set to latin1 on both installation. I used the mysql
binary distribution. Do I need to change this. If so how?

Best Regards
K.Suresh





___
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Problems with MySQL on Linux (Linux Newbie)

[Victoria Reznichenko]

Donald Tyler <[EMAIL PROTECTED]> wrote:
> 
> I am just learning to use Linux and I am having some problems with
> getting MySQL to load.
> 
> 
> I have successfully installed & tested both Apache & PHP, so I am pretty
> comfortable with the whole configure and make processes.
> 
> 
> I followed the MySQL installation docs to the letter, however when I try
> to load the MySQL daemon as instructed, the program just quits after a
> few seconds. Here is the terminal output:
> 
> 
> [EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql &
> 
> [1] 30010
> 
> [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
> /var/lib/mysql
> 
> 030923 09:30:18 mysqld ended
> 
> Anyone know what I am doing wrong?

You can find causes in the error log file (.err file in the /var/lib/mysql).


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems with MySQL on Linux (Linux Newbie)

[Donald Tyler]

Hi,

 

I am just learning to use Linux and I am having some problems with
getting MySQL to load.

 

I have successfully installed & tested both Apache & PHP, so I am pretty
comfortable with the whole configure and make processes.

 

I followed the MySQL installation docs to the letter, however when I try
to load the MySQL daemon as instructed, the program just quits after a
few seconds. Here is the terminal output:

 

[EMAIL PROTECTED] mysql]# ./bin/mysqld_safe --user=mysql &

[1] 30010

[EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from
/var/lib/mysql

030923 09:30:18 mysqld ended

 

Anyone know what I am doing wrong?

 

Thanks

re: Have a problem when I try to connect MySQL( on Linux) thru win32

[Egor Egorov]

Cem,
Tuesday, November 26, 2002, 1:13:45 PM, you wrote:

CY> I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
CY> working successfully on the server, and can response all request
CY> comming on Server. But, when I try to connect to the database thru
CY> any client running on a Windows 2000  (like MySQLAdmin), I can't
CY> connect it.

CY> Firstly, I got an error message like "Error 2013: Lost Connection
CY> to MySQL Server during query". I checked the mysqld log file
CY> on Server (/var/log/mysqld.log)  and I was sure that, when I try to
CY> connect to the server, my attempt is received by mysql with an error
CY> like:

CY> "Cannot   initialize Innodb as 'innodb_data_file_path" is not set.
CY> If you do not want to use transactional InnoDB tables, add a line
CY> skip_Innodb
CY> to the [mysqld] section of init parameters in your my.cnf" ...

CY> I did it. But still I can't see the databases declared on the mysql (On
CY> Linux) from my win2000 PC.

CY> Still, on every attempt of connection, a new paragraph is being added to
CY> the mysqld.log, now without any error message
CY> ("mysqld process hanging, pid  - killed
CY> 020210 03:26:11 mysqld restarted
CY> /usr/libexec/mysqld: ready for connection.

CY> I am dying to see any databases existing on the Linux server.

CY> (In order to be sure that, there is no problem on my client configuration,
CY> I installed Mysql win32 version into my friends PC (Win2000).My PC can
CY> easily connect and operate the databases that are on my friends PC over
CY> network.)

What is the version of  glibc? There was a bug with 2.2.5-40 glibc, see: 
 https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Have a problem when I try to connect MySQL( on Linux) thru win32

[Cem Yagli]

He all,

I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
working successfully on the server, and can response all request
comming on Server. But, when I try to connect to the database thru
any client running on a Windows 2000  (like MySQLAdmin), I can't
connect it.

Firstly, I got an error message like "Error 2013: Lost Connection
to MySQL Server during query". I checked the mysqld log file
on Server (/var/log/mysqld.log)  and I was sure that, when I try to
connect to the server, my attempt is received by mysql with an error
like:

"Cannot   initialize Innodb as 'innodb_data_file_path" is not set.
If you do not want to use transactional InnoDB tables, add a line
skip_Innodb
to the [mysqld] section of init parameters in your my.cnf" ...

I did it. But still I can't see the databases declared on the mysql (On
Linux) from my win2000 PC.

Still, on every attempt of connection, a new paragraph is being added to
the mysqld.log, now without any error message
("mysqld process hanging, pid  - killed
020210 03:26:11 mysqld restarted
/usr/libexec/mysqld: ready for connection.

I am dying to see any databases existing on the Linux server.

(In order to be sure that, there is no problem on my client configuration,
I installed Mysql win32 version into my friends PC (Win2000).My PC can
easily connect and operate the databases that are on my friends PC over
network.)

Would anyone help me!

Cem Yagli


// keywords: sql, query



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Have a problem when I try to connect MySQL( on Linux) thru win32

[Cem Yagli]

He all,

I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is
working successfully on the server, and can response all request
comming on Server. But, when I try to connect to the database thru
any client running on a Windows 2000  (like MySQLAdmin), I can't
connect it.

Firstly, I got an error message like "Error 2013: Lost Connection
to MySQL Server during query". I checked the mysqld log file
on Server (/var/log/mysqld.log)  and I was sure that, when I try to
connect to the server, my attempt is received by mysql with an error
like:

"Cannot   initialize Innodb as 'innodb_data_file_path" is not set.
If you do not want to use transactional InnoDB tables, add a line
skip_Innodb
to the [mysqld] section of init parameters in your my.cnf" ...

I did it. But still I can't see the databases declared on the mysql (On
Linux) from my win2000 PC.

Still, on every attempt of connection, a new paragraph is being added to
the mysqld.log, now without any error message
("mysqld process hanging, pid  - killed
020210 03:26:11 mysqld restarted
/usr/libexec/mysqld: ready for connection.

I am dying to see any databases existing on the Linux server.

(In order to be sure that, there is no problem on my client configuration,
I installed Mysql win32 version into my friends PC (Win2000).My PC can
easily connect and operate the databases that are on my friends PC over
network.)

Would anyone help me!

Cem Yagli



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: starting Mysql on linux

[Bhavin Vyas]

Make sure that your mysql daemon is running, if not, start it. Also, make
sure the mysql.sock file is present in /var/lib/mysql.

Bhavin.
- Original Message -
From: "Stick Dragon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, November 10, 2002 3:44 PM
Subject: starting Mysql on linux


> i have installed redhat 8 and slackware linux and been trying to get mysql
> to run. when i get to the console and type 'mysql' i get, error 2002; cant
> connect to local mysql server through socket '/var/lib/mysql/mysql.sock' i
> have tried to run mysqld through the console but says it cant find the
> command. i'm not really linux or mysql savy. any help on getting it to run
> would be great.
>
> _
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: starting Mysql on linux

[Adolfo Bello]

Make sure the service is started. If no, enter the command:
console> service mysql start

Adolfo



On Sun, 2002-11-10 at 16:44, Stick Dragon wrote:
i have installed redhat 8 and slackware linux and been trying to get mysql 
to run. when i get to the console and type 'mysql' i get, error 2002; cant 
connect to local mysql server through socket '/var/lib/mysql/mysql.sock' i 
have tried to run mysqld through the console but says it cant find the 
command. i'm not really linux or mysql savy. any help on getting it to run 
would be great.

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-- 
___
   // \\   @   ___ ___@
  //  //  // /\   /  \\   //  \  //   Adolfo Bello
<[EMAIL PROTECTED]>
 //  \\  // / \\ /   //  //   / //Bello Ingenieria S.A, Presidente
//___// // / <_/ \___\\ //___/ // cel: +58 416 609-6213
   // fax: +58 212 952-6797
http://www.bisapi.com //  sms: www.tun-tun.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

starting Mysql on linux

[Stick Dragon]

i have installed redhat 8 and slackware linux and been trying to get mysql 
to run. when i get to the console and type 'mysql' i get, error 2002; cant 
connect to local mysql server through socket '/var/lib/mysql/mysql.sock' i 
have tried to run mysqld through the console but says it cant find the 
command. i'm not really linux or mysql savy. any help on getting it to run 
would be great.

_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Connecting to MySQL on Linux from a Windows machine. -- Resolved !!

[Will Merrell]

Well, after much fussing around with RPM's and searching this list, I have
resolved my problem.

The clue was the discussion on this list regarding the glibc bug. I upgraded
to the 4.0.x RPM's that I got from the MySQL site and after I got all of the
dependency problems fixed I was able to start up a MySQL/PHP setup that
worked. Now both the website development works and I can use MyCC on the
windows machine to administer the database.

Thank you to all that considered my problem.

--Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Connecting to MySQL on Linux from a Windows machine.

[Ed Carp]

> Thank you, but at this point I am pretty sure that my problem is not a
> matter of entries in the user table. When I attempt to telnet
> into port 3306
> the connection is immediately dropped. I don't really know if
> any connection
> is actually established at all, it may be established and immediately
> dropped on simply refused from the start. There does not appear to be any
> exchange of user names or passwords. I have several variations of my
> username and host name in the user table. I believe that one of
> them should
> have worked if that was the problem.

If you try and telnet to port 3306 on the machine that MySQL is running on,
you will see the connection being established, then you'll see garbage, as
MySQL is designed to talk to clients on that port, not humans ;)

If you are seeing the connection being established, then *immediately*
dropped, not refused, then the problem may be in MySQL.  If the connection
is refused, this is a different issue.

Depending on what version of MySQL and Linux/whatever you're running, I
believe there's a verified problem with MySQL and RedHat Linux - mismatch
of glibc version, I think.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Connecting to MySQL on Linux from a Windows machine.

[Will Merrell]

Thank you, but at this point I am pretty sure that my problem is not a
matter of entries in the user table. When I attempt to telnet into port 3306
the connection is immediately dropped. I don't really know if any connection
is actually established at all, it may be established and immediately
dropped on simply refused from the start. There does not appear to be any
exchange of user names or passwords. I have several variations of my
username and host name in the user table. I believe that one of them should
have worked if that was the problem.

I believe that the problem lies in the mysql configuration. I think that it
is not responding to the TCP/IP port in the way that I need it to. I have
verified that the --skip-network flag is NOT set (set to OFF) so it is not
that simple, but I cannot find any other flag that looks any more promising.

Any other Ideas?

BTW Thanks for the webmin tip, I'll give it a try. Doesn't solve all of my
problem, but it may help.

Thanks,
--Will


> -Original Message-
> From: STIBS [mailto:stibs-pi@;gmx.de]
> Sent: Friday, October 18, 2002 1:35 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Connecting to MySQL on Linux from a Windows machine.
>
>
> Will,
>
> |||)So I still need some more ideas.
>
> I have to learn your problem each time again when I setup a new
> machine every half a year.
>
> I try each time the following hostnames:
>
> localhost (didn't work 4u)
> 127.0.0.1 (IP for localhost)
> hostname (e.g. databaseserver.mydomain.com- what you called the machine)
> 192.168.0.x  (Your real network IP, can also be in 10.* or 172.25.*)
> localhost.localdomain (results to same as hostname)
>
> one of them fit's ;o) ... if not I install webmin from
> www.webmin.com and connect via Browser to the machine
> (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server
> section you have a complete webbased MySQL administration. There
> I make all settings and forget about it. It just works after this setup.
>
> STIBS
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Connecting to MySQL on Linux from a Windows machine.

[STIBS]

Will,

|||)So I still need some more ideas.

I have to learn your problem each time again when I setup a new machine every half a 
year.

I try each time the following hostnames:

localhost (didn't work 4u)
127.0.0.1 (IP for localhost)
hostname (e.g. databaseserver.mydomain.com- what you called the machine)
192.168.0.x  (Your real network IP, can also be in 10.* or 172.25.*)
localhost.localdomain (results to same as hostname)

one of them fit's ;o) ... if not I install webmin from www.webmin.com and connect via 
Browser to the machine (http://IP.ADD.RE.SS:1 - login as root). In Webmin's server 
section you have a complete webbased MySQL administration. There I make all settings 
and forget about it. It just works after this setup.

STIBS


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Connecting to MySQL on Linux from a Windows machine.

[Will Merrell]

Thank you to both of you who responded to my question. I have checked both
of these issues and found that neither solve  my situation.

1) I have (and had) both a 'will@localhost' and a 'will@"%"' entry in the
user table. Is there something else that has to be done to set up the host?

2) According to 'mysqladmin variables' the --skip-networking option is set
to OFF. That should mean that Olaf's suggestion is satisfied, right?

So I still need some more ideas. Why am I not able to connect to MySQL from
another machine?

Thanks,
-- Will


Randy Witt wrote:
>Will,
>
>Do you have a user/host pair for the client in the user table within the
>mysql database?? It's not good enough just to have a user, the host has
>to be setup too.

And
Olaf van Zandwijk wrote:
> Hi,
>
> It seems to me that you can't connect to MySQL from an other machine at
> all. Did you start MySQL with the --skip-networking option? Try removing
> that option from the start-up scripts.
>
> \Olaf
>

In response to my Original Post:
>Will Merrell wrote:
>
>I cannot connect from my Windows machine to the MySQL database running on
>the Linux server.
>
>I have tried several different programs and they all report an error that
>says "Lost connection to MySQL server during connection".
>
>I have read all the articles I can find and searched the archives as well
as
>I can figure out but I am still stumped.
>
>Here are some pertinent details.
>
>1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local
>network at 192.168.3.2 and there are no firewalls between it and the
Windows
>machine. (Both are behind the same firewall, and completely open to each
>other.)
>
>2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP).
>
>3) On the linux machine I can access MySQL just fine. The mysql command
>works, and I can serve web pages with PHP/MySQL content.
>
>4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can
>telnet to port 80 and get a connection although it doesn't do much there.
>
>5) I cannot telnet to port 3306. When I try, I get an immediate "Host
>connection lost." error.
>
>Any ideas would be most appreciated.
>
>   Thanks,
>   -- Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Connecting to MySQL on Linux from a Windows machine.

[Olaf van Zandwijk]

Hi,

It seems to me that you can't connect to MySQL from an other machine at 
all. Did you start MySQL with the --skip-networking option? Try removing 
that option from the start-up scripts.

\Olaf

Will Merrell wrote:

I cannot connect from my Windows machine to the MySQL database running on
the Linux server.

I have tried several different programs and they all report an error that
says "Lost connection to MySQL server during connection".

I have read all the articles I can find and searched the archives as well as
I can figure out but I am still stumped.

Here are some pertinent details.

1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local
network at 192.168.3.2 and there are no firewalls between it and the Windows
machine. (Both are behind the same firewall, and completely open to each
other.)

2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP).

3) On the linux machine I can access MySQL just fine. The mysql command
works, and I can serve web pages with PHP/MySQL content.

4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can
telnet to port 80 and get a connection although it doesn't do much there.

5) I cannot telnet to port 3306. When I try, I get an immediate "Host
connection lost." error.

Any ideas would be most appreciated.

	Thanks,
		-- Will


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 


--
 __XXX__
  (0-0)
+--ooO--(_)--Ooo---+
|  |
| Olaf van Zandwijk|
|  |
| ICQ# 30231605|
| PGP Public Key: http://www.vanzandwijk.net/pgp.txt   |
+--+





-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Connecting to MySQL on Linux from a Windows machine.

[Will Merrell]

I cannot connect from my Windows machine to the MySQL database running on
the Linux server.

I have tried several different programs and they all report an error that
says "Lost connection to MySQL server during connection".

I have read all the articles I can find and searched the archives as well as
I can figure out but I am still stumped.

Here are some pertinent details.

1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my local
network at 192.168.3.2 and there are no firewalls between it and the Windows
machine. (Both are behind the same firewall, and completely open to each
other.)

2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP).

3) On the linux machine I can access MySQL just fine. The mysql command
works, and I can serve web pages with PHP/MySQL content.

4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I can
telnet to port 80 and get a connection although it doesn't do much there.

5) I cannot telnet to port 3306. When I try, I get an immediate "Host
connection lost." error.

Any ideas would be most appreciated.

Thanks,
-- Will


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Connecting to MySQL on Linux from a Windows machine.

[Randy Witt]

Will,

Do you have a user/host pair for the client in the user table within the
mysql database?? It's not good enough just to have a user, the host has
to be setup too.


> I cannot connect from my Windows machine to the MySQL database running
on
> the Linux server.
> 
> I have tried several different programs and they all report an error
that
> says "Lost connection to MySQL server during connection".
> 
> I have read all the articles I can find and searched the archives as
well
> as
> I can figure out but I am still stumped.
> 
> Here are some pertinent details.
> 
> 1) The Server is running Redhat 7.3 and MySQL 3.23.49. It is on my
local
> network at 192.168.3.2 and there are no firewalls between it and the
> Windows
> machine. (Both are behind the same firewall, and completely open to
each
> other.)
> 
> 2) The Windows machine is running Win98 SE at 192.168.3.x (DHCP).
> 
> 3) On the linux machine I can access MySQL just fine. The mysql
command
> works, and I can serve web pages with PHP/MySQL content.
> 
> 4) I can telnet, Samba, xterm, etc. to the linux machine just fine. I
can
> telnet to port 80 and get a connection although it doesn't do much
there.
> 
> 5) I cannot telnet to port 3306. When I try, I get an immediate "Host
> connection lost." error.
> 
> Any ideas would be most appreciated.
> 
>   Thanks,
>   -- Will



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySql on Linux Clustering..?

[Kerry Ancheta]

I should clarify that you could have a cluster of MySQL servers using our
replication.  However for clustering you should consider the following:
Maybe the most powerful project in this area is Beowulf (not Linux only)
http://www.beowulf.org, but there are many such projects like:
Cplant http://www.cs.sandia.gov/cplant/
Legion http://legion.virginia.edu
Linux Virtual Server Project: http://www.linuxvirtualserver.org
MOSIX: http://www.mosix.cs.huji.ac.il/
High-Availability Linux Project: http://www.linux-ha.org

Kerry

 > -Original Message-
 > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 > Sent: Thursday, August 01, 2002 9:09 AM
 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
 > Subject: MySql on Linux Clustering..?
 >
 >
 >
 > I want to run MySql on Linux Clustering Sever.
 > But I can't find about that.
 >
 > Would you tell me ,
 > Where can I get MySql Clustering HOW-TO Docs?
 >
 >
 >
 >


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySql on Linux Clustering..?

[Mike Hall]

Replication, however, is no good for scaling update load. What happens when
you're update load is too much for the box? Are you just meant to buy a
bigger box? What happens if you already have the biggest box and the update
load is too high? Is there no way to scale the update load wide in MySQL?

--Mike

- Original Message -
From: "Kerry Ancheta" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 9:37 PM
Subject: RE: MySql on Linux Clustering..?


> You could set up a clustering configuration using our replication.  Just
> take a look at the replication section of our online docs:
> http://www.mysql.com/documentation/index.html
>
> Kerry
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySql on Linux Clustering..?

[Kerry Ancheta]

You could set up a clustering configuration using our replication.  Just
take a look at the replication section of our online docs:
http://www.mysql.com/documentation/index.html

Kerry

 > -Original Message-
 > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
 > Sent: Thursday, August 01, 2002 9:09 AM
 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
 > Subject: MySql on Linux Clustering..?
 >
 >
 >
 > I want to run MySql on Linux Clustering Sever.
 > But I can't find about that.
 >
 > Would you tell me ,
 > Where can I get MySql Clustering HOW-TO Docs?
 >
 >
 >
 >


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySql on Linux Clustering..?

I want to run MySql on Linux Clustering Sever.
But I can't find about that.

Would you tell me ,
Where can I get MySql Clustering HOW-TO Docs?




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Installing mysql on Linux

[sup-mysql]

I am not really sure where it gets installed...  nor that wether it is
all installed on a single location. Try searching for it..
find / -name mysql

Good Luck

Ramon
On Sat, 11 May 2002, Hoa Doan wrote:

> 
> Hello,
> 
> I'm trying to install mysql on RedHat Linux 7.0.  I've downloaded the rpm.  
> And I've install it using the command rpm -i "rpm name".  Now my question 
> is.  What directory is the program located in?
> 
> Any help is greatly appreciated.
> 
> Hoa
> 
> 
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Installing mysql on Linux

[Joseph Bueno]

Hoa Doan wrote :
> 
> Hello,
> 
> I'm trying to install mysql on RedHat Linux 7.0.  I've downloaded the rpm.
> And I've install it using the command rpm -i "rpm name".  Now my question
> is.  What directory is the program located in?
> 
> Any help is greatly appreciated.
> 
> Hoa
> 
> _
> Chat with friends online, try MSN Messenger: http://messenger.msn.com
> 

Hi,

You can try:
rpm -q -l MySQL
it will tell you where all files coming in MySQL package are located. 

(Hint: mysql binaries are in standard places: /usr/bin and /usr/sbin)

Regards
--
Joseph Bueno
NetClub/Trader.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Installing mysql on Linux

[Hoa Doan]

Hello,

I'm trying to install mysql on RedHat Linux 7.0.  I've downloaded the rpm.  
And I've install it using the command rpm -i "rpm name".  Now my question 
is.  What directory is the program located in?

Any help is greatly appreciated.

Hoa


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: install mysql++ on linux

[Sinisa Milivojevic]

adel essafi writes:
> hi
> i have downloaded mysql++ on linux.
> i didn't find these files
> automake
> autoconfig
> so , i couldn't install  mysql++.
> help plz
> 
> 

On linux, you can skip first two steps and start from configure ...

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   <___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

install mysql++ on linux

[adel essafi]

hi
i have downloaded mysql++ on linux.
i didn't find these files
automake
autoconfig
so , i couldn't install  mysql++.
help plz


___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Problem while installing DBD for mysql on linux.....

[Shailesh Parmar]

its a permission issue.. do 
>grant ALL on *.* to root@localhost .. 

-Original Message-
From: Pramod Chowdavarapu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:54 AM
To: [EMAIL PROTECTED]
Subject: Problem while installing DBD for mysql on linux.


Hi All,
I am trying to install DBD for mysql on linux machinein the process
when i did
"make test" i  am getting the  below error messages...
Could any one kindly help me in getting out of this??

Please refer the procedure to install Perl DBD module from source  thru the
below link...

http://search.cpan.org/doc/JWIED/DBD-mysql-2.1011/lib/DBD/mysql/INSTALL.pod

Pls check the Manual installation in the above linki am following the
same procedure!!!

Error messages
-
[root@dial-mib-pc] /usr/local/DBD-mysql-2.1011# make test
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/
usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests $verbose);
$verbose=0; runtests @ARGV;' t/*.t
t/00baseok
t/10dsnlist.DBI->connect(test) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using password:
NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
dubious
Test returned status 10 (wstat 2560, 0xa00)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/Test/Harness.pm line 288.
make: *** [test_dynamic] Error 10

Thanks,
Pramod.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Problem while installing DBD for mysql on linux.....

[Pramod Chowdavarapu]

Hi All,
I am trying to install DBD for mysql on linux machinein the process
when i did
"make test" i  am getting the  below error messages...
Could any one kindly help me in getting out of this??

Please refer the procedure to install Perl DBD module from source  thru the
below link...

http://search.cpan.org/doc/JWIED/DBD-mysql-2.1011/lib/DBD/mysql/INSTALL.pod

Pls check the Manual installation in the above linki am following the
same procedure!!!

Error messages
-
[root@dial-mib-pc] /usr/local/DBD-mysql-2.1011# make test
PERL_DL_NONLAZY=1
/usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/
usr/lib/perl5/5.00503 -e 'use Test::Harness qw(&runtests $verbose);
$verbose=0; runtests @ARGV;' t/*.t
t/00baseok
t/10dsnlist.DBI->connect(test) failed: Access denied for user:
'root@localhost' (Using password: NO) at t/10dsnlist.t line 45
Cannot connect: Access denied for user: 'root@localhost' (Using password:
NO)
Either your server is not up and running or you have no
permissions for acessing the DSN DBI:mysql:test.
This test requires a running server and write permissions.
Please make sure your server is running and you have
permissions, then retry.
dubious
Test returned status 10 (wstat 2560, 0xa00)
Undefined subroutine &Test::Harness::WCOREDUMP called at
/usr/lib/perl5/5.00503/Test/Harness.pm line 288.
make: *** [test_dynamic] Error 10

Thanks,
Pramod.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Connect Mysql on Linux from Windows

[Egor Egorov]

Dodol,
Monday, March 25, 2002, 3:50:25 AM, you wrote:

D> I am new member here, and I would like to ask about connection at
D> Mysql. I have MySQL on linux server and I want to connect that MySQL
D> engine from windows, how can I connect to that mysql
D> now I've been install Mysql-ODBC and MySQLFront on windows, but there
D> is still an error connection message

D> the message of MysqlFront is like this
D> "1130. Host 'ipwindows' is not allowed to connectto this MySQL server"

D> wish u all to give some solution to solve my problem
D> many thanks and highly appreciate for yr all support

'Host 'ipwindows' is not allowed to connect to this MySQL server'
means that there are no row in table 'user' that matches host
'ipwindows'. Try to connect from another host and set privileges up to
connect from this host. You can read more at:
http://www.mysql.com/doc/A/c/Access_denied.html

D> Best regards,
D> Afif





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Connect Mysql on Linux from Windows

[Dodol]

Dear Miliser

I am new member here, and I would like to ask about connection at
Mysql. I have MySQL on linux server and I want to connect that MySQL
engine from windows, how can I connect to that mysql
now I've been install Mysql-ODBC and MySQLFront on windows, but there
is still an error connection message

the message of MysqlFront is like this
"1130. Host 'ipwindows' is not allowed to connectto this MySQL server"

wish u all to give some solution to solve my problem
many thanks and highly appreciate for yr all support

Best regards,
Afif
mailto:[EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql on Linux

[Doug Thompson]

Today I migrated my system to RH7.1.  I had been running mysql on Mandrake 7.2 but I 
wanted to use the newer versions 
which require kernel 2.4.x.

I experienced exactly the same problems as you with the RPM of mysql which came with 
the RH distro.  I looked at 
everything and then some that had been pointed out in this thread and was having 
equally poor results.  No amount of 
fiddling caused the symptoms to change in the slightest.

I solved the problem by downloading the 3.23.49a RPM from mysql.com and installing 
that.  First time I tried the new 
version, it worked exactly like it is supposed to.  I was both surprised and pleased 
with this outcome.  Fixes for 
such nasty problems aren't supposed to be so easy. 8-)

I'm not going to try to guess what the exact problem is.  I'm just letting you know 
how I resolved it.

Hope you have as much good luck,
Doug

 
The 
On Wed, 06 Mar 2002 10:07:12 -0800, Steven Roussey wrote:

>> Starting mysqld daemon with databases from /var/lib/mysql
>> 020305 17:46:10 mysqld ended
>
>This is written by safe_mysqld. It seems that mysqld was never started
>successfully. I've had this issue before. Every time it was a
>permissions issue.
>
>> > > When I execute mysqld -u root -p 
>> > > I am presented with the default variables.
>
>Which are?
>
>Also, what is in /var/lib/mysql?
>
>Sincerely,
>Steven Roussey
>http://Network54.com/?pp=e
>
>
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql on Linux

[Luc Foisy]

when you run mysqld -u root -p  and it gives you the list of
default variables. 
You can get this same message by typing mydqld --help, which might indicate
some error in the command line arguments.
This file also shows you configurations supplied on the command line as well
as configurations found in files such as my.cnf (this may help you). It wont
tell you where the value came from, but it will show them.
the few lines after the following line might show something of importance:
The default values (after parsing the command line arguments) are:

It also shows which command line options are allowed. -u or --user are
valid, -p however is not listed in those options


-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 3:13 PM
To: 'Intrex'
Cc: 'Mysql'
Subject: RE: mysql on Linux


> When I execute mysqld -u root -p 
> I am presented with the default variables. 

Which are? How about showing what mysqld --user=root displays?

Also, you see linux-bin.* files? That indicates that mysqld was running
at some point (maybe nine times). Can you get the directory listings
with 

ls -l 

?

Sincerely,
Steven Roussey
http://Network54.com/?pp=e





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql on Linux

[Steven Roussey]

> When I execute mysqld -u root -p 
> I am presented with the default variables. 

Which are? How about showing what mysqld --user=root displays?

Also, you see linux-bin.* files? That indicates that mysqld was running
at some point (maybe nine times). Can you get the directory listings
with 

ls -l 

?

Sincerely,
Steven Roussey
http://Network54.com/?pp=e





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[Intrex]

The /var/lib/mysql  contains the following files:
linux-bin.001
linux-bin.002
linux-bin.003
linux-bin.004
linux-bin.005
linux-bin.006
linux-bin.007
linux-bin.008
linux-bin.009
linux-bin.index
linux-bin.err

the directory mysql
the directory test

directory mysql contains
columns_priv.MYD
columns_priv.MYI
columns_priv.frm
db.MYD
db.MYI
db.frm
func.MYD
func.MYI
fun.frm
host.MYD
host.MYI
host.frm
tables_priv.MYD
tables_priv.MYI
tables_frm
user.MYD
user.MYI
user.frm

Directory test contains nothing

When I remove all the files and recreate the directory using
mysql_install_db  then follow the directions for installing the privileges I
get the same files, and the same errors.

I am unable to use mysqladm create  since the mysql daemon is
not running.  It is my understanding that the database it is looking for is
the permission files located in the /var/lib/mysql directories.

Mark

Mark


- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "'Intrex'" <[EMAIL PROTECTED]>
Cc: "Mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, March 06, 2002 1:07 PM
Subject: RE: mysql on Linux


> > Starting mysqld daemon with databases from /var/lib/mysql
> > 020305 17:46:10 mysqld ended
>
> This is written by safe_mysqld. It seems that mysqld was never started
> successfully. I've had this issue before. Every time it was a
> permissions issue.
>
> > > > When I execute mysqld -u root -p 
> > > > I am presented with the default variables.
>
> Which are?
>
> Also, what is in /var/lib/mysql?
>
> Sincerely,
> Steven Roussey
> http://Network54.com/?pp=e
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql on Linux

[Steven Roussey]

> Starting mysqld daemon with databases from /var/lib/mysql
> 020305 17:46:10 mysqld ended

This is written by safe_mysqld. It seems that mysqld was never started
successfully. I've had this issue before. Every time it was a
permissions issue.

> > > When I execute mysqld -u root -p 
> > > I am presented with the default variables.

Which are?

Also, what is in /var/lib/mysql?

Sincerely,
Steven Roussey
http://Network54.com/?pp=e




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql on Linux

[Luc Foisy]

try running safe_mysqld without any options
I wouldn't know why you would need to specify a user name to start the
daemon

-Original Message-
From: Intrex [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 5:55 AM
To: [EMAIL PROTECTED]; 'Mysql'
Subject: Re: mysql on Linux


I know in at least 2 e-mails I did indeed mention that I executed
safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root,
I had the same text returned which again said the following.

Starting mysqld daemon with databases from /var/lib/mysql
020305 17:46:10 mysqld ended

I presume that means that mysqld "ended"  Basically the mysql started then
abruptly stopped.  Again the error in the ONLY error log "linux.err" said
the exact same text that was displayed on my screen, making that no help.

There is no mysql.sock on my system because the server is not running,
anyone have any REAL ideas?  The documentation is of NO help whatsoever and
I am getting very frustrated with it.

Trying mysqp -u root -p was a desperate attempt to try it another
way.  As I have done numerous different ways.  I don't know how many
different ways I can try to get mysqld daemon running.

Mark


- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "'Mysql'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 8:14 PM
Subject: Re: mysql on Linux


> > When I execute mysqld -u root -p 
> > I am presented with the default variables.
>
> The manual says to use safe_mysqld to properly start mysqld.  Also,
> --user=root is clearer for that option. And, what are you doing with -p
>  in starting the daemon? This is not an option, it is an
> error.
>
> http://www.mysql.com/doc/s/a/safe_mysqld.html
>
> Sincerely,
> Steven Roussey
> http://Network54.com/?pp=e
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[Intrex]

I know in at least 2 e-mails I did indeed mention that I executed
safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root,
I had the same text returned which again said the following.

Starting mysqld daemon with databases from /var/lib/mysql
020305 17:46:10 mysqld ended

I presume that means that mysqld "ended"  Basically the mysql started then
abruptly stopped.  Again the error in the ONLY error log "linux.err" said
the exact same text that was displayed on my screen, making that no help.

There is no mysql.sock on my system because the server is not running,
anyone have any REAL ideas?  The documentation is of NO help whatsoever and
I am getting very frustrated with it.

Trying mysqp -u root -p was a desperate attempt to try it another
way.  As I have done numerous different ways.  I don't know how many
different ways I can try to get mysqld daemon running.

Mark


- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "'Mysql'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 8:14 PM
Subject: Re: mysql on Linux


> > When I execute mysqld -u root -p 
> > I am presented with the default variables.
>
> The manual says to use safe_mysqld to properly start mysqld.  Also,
> --user=root is clearer for that option. And, what are you doing with -p
>  in starting the daemon? This is not an option, it is an
> error.
>
> http://www.mysql.com/doc/s/a/safe_mysqld.html
>
> Sincerely,
> Steven Roussey
> http://Network54.com/?pp=e
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[Steven Roussey]

> When I execute mysqld -u root -p 
> I am presented with the default variables.

The manual says to use safe_mysqld to properly start mysqld.  Also,
--user=root is clearer for that option. And, what are you doing with -p
 in starting the daemon? This is not an option, it is an
error.

http://www.mysql.com/doc/s/a/safe_mysqld.html

Sincerely,
Steven Roussey
http://Network54.com/?pp=e 




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[Intrex]

I do have a mysql user, and have used the commands to assigne rights for the
mysql user per the instructions.  I have no hostname.err, only linux.err
which displays the exact same errors I typed out.

Mark


- Original Message -
From: "James Montebello" <[EMAIL PROTECTED]>
To: "Intrex" <[EMAIL PROTECTED]>
Cc: "Scott Helms" <[EMAIL PROTECTED]>; "'mysql'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 10:59 AM
Subject: Re: mysql on Linux


> On Tue, 5 Mar 2002, Intrex wrote:
>
> > Ok.
> >
> > SuSE 7.3
> > Digital HiNote VP745
> > mysql   Ver 11.17 Distrib 3.23.49a  for pc-linux-gnu
> >
> > Prior to completely reinstalling my SuSE system, I was running mysql
3.23.47
> > for SuSE
> >
> > I have installed the .tar.gz and followed those instructions
> > I have installed the RPM's using the -i, and also installed the RPM's
using
> > Yast1 package installer.
> >
> > Each time I have reformatted my system and re-installed in order to
insure I
> > did not have stray variables hanging around from the previous
installation.
> >
> > When I execute mysqld -u root -p 
> > I am presented with the default variables.
> >
> > When I execute safe_mysqld the following message is given
> > Starting mysqld daemon with databases from /var/lib/mysql
> > 020305 07:36:44 mysql ended
>
> What does the error log say at this point?  It probably has a lot
> more detail on exactly what caused it to end.  This log is probably in
> /var/lib/mysql/hostname.err (this is the default behavior).  Possible
> problems are there is no mysql user, or the data directory or the mysql
> table isn't owned by the mysql user.  This will be spelled out clearly
> in the error log.
>
> james montebello
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[James Montebello]

On Tue, 5 Mar 2002, Intrex wrote:

> Ok.
> 
> SuSE 7.3
> Digital HiNote VP745
> mysql   Ver 11.17 Distrib 3.23.49a  for pc-linux-gnu
> 
> Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47
> for SuSE
> 
> I have installed the .tar.gz and followed those instructions
> I have installed the RPM's using the -i, and also installed the RPM's using
> Yast1 package installer.
> 
> Each time I have reformatted my system and re-installed in order to insure I
> did not have stray variables hanging around from the previous installation.
> 
> When I execute mysqld -u root -p 
> I am presented with the default variables.
> 
> When I execute safe_mysqld the following message is given
> Starting mysqld daemon with databases from /var/lib/mysql
> 020305 07:36:44 mysql ended

What does the error log say at this point?  It probably has a lot
more detail on exactly what caused it to end.  This log is probably in
/var/lib/mysql/hostname.err (this is the default behavior).  Possible
problems are there is no mysql user, or the data directory or the mysql
table isn't owned by the mysql user.  This will be spelled out clearly
in the error log.  

james montebello


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[Intrex]

Ok.

SuSE 7.3
Digital HiNote VP745
mysql   Ver 11.17 Distrib 3.23.49a  for pc-linux-gnu

Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47
for SuSE

I have installed the .tar.gz and followed those instructions
I have installed the RPM's using the -i, and also installed the RPM's using
Yast1 package installer.

Each time I have reformatted my system and re-installed in order to insure I
did not have stray variables hanging around from the previous installation.

When I execute mysqld -u root -p 
I am presented with the default variables.

When I execute safe_mysqld the following message is given
Starting mysqld daemon with databases from /var/lib/mysql
020305 07:36:44 mysql ended

I have insured that the mysql_install_db has indeed placed the permission
databases in that directory, and that the variables listed in the my.cnf are
indeed correct.

After starting the safe_mysqld and trying to run mysqladmin create
  I get the message:

mysqladmin:connect to server at 'localhost' failed
error: 'Can't connect to MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket:
'/var/lib/mysql/mysql.sock' exists!

Running locate mysql.sock returns no such file, which would be correct since
the mysqld daemon never started.

has anyone had this particular problem.  I can assure you I have followed
the instructions in the documentation I have been repetedly poited to
numerous times.  What I am also sure, is that the documentation is also more
than likely 'assuming' something that is NOT in the docs.

Any ideas what I am missing?

I do not know what I am missing here, that is causing the

- Original Message -
From: "Scott Helms" <[EMAIL PROTECTED]>
To: "'mysql'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 6:54 PM
Subject: Re: mysql on Linux


> Mark,
>
> This probably won't get you the response you wanted.  How about
letting
> us know where you have gotten to and where things seem to be breaking.  A
> generalized request for "what do I do" often recieves little or no help.
> Some basic system information would also be much appreciated; what distro
> are you using, what type of hardware PPC, Intel, etc.
>
>
> Scott
> - Original Message -
> From: "Intrex" <[EMAIL PROTECTED]>
> To: "Jorge del Conde" <[EMAIL PROTECTED]>; "'Manish Mehta'"
> <[EMAIL PROTECTED]>; "'mysql'" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 05, 2002 6:23 PM
> Subject: Re: mysql on Linux
>
>
> > Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ
100
> > TIMES is NO help.  I have read this file, I have used the appropriate
> > .tar.gz, I have reinstalled, I have used the most current RPM's
> >
> > How about contributing something USEFUL, like a REAL answer, that anyone
> can
> > follow.  No cryptic mumbo jumbo, no PhD CRAPOLA.
> >
> > I mean REALLY.
> >
> > Mark
> >
> > - Original Message -
> > From: "Jorge del Conde" <[EMAIL PROTECTED]>
> > To: "'Manish Mehta'" <[EMAIL PROTECTED]>; "'mysql'"
> > <[EMAIL PROTECTED]>
> > Sent: Tuesday, October 09, 2001 1:48 AM
> > Subject: RE: mysql on Linux
> >
> >
> > > Hi,
> > >
> > > Download the binary distribution that suits your system and read the
> > > "INSTALL-BINARY" file.
> > >
> > > Also, make sure the online documentation at
> > > http://www.mysql.com/documentation/index.html
> > >
> > > Regards,
> > > Jorge
> > >
> > > For technical support contracts, visit https://order.mysql.com/
> > >__  ___ ___   __
> > >   /  |/  /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
> > >  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
> > > /_/  /_/\_, /___/\___\_\___/   Mexico City, Mexico
> > ><___/   www.mysql.com
> > >
> > >
> > >
> > > > -Original Message-
> > > > From: Manish Mehta [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, October 09, 2001 12:34 AM
> > > > To: mysql
> > > > Subject: mysql on Linux
> > > >
> > > >
> > > > Hello
> > > >
> > > > I want to install mysql on Linux.
> > > > What are the basic step followed at the time of installation.
> > > >
> > > > pl. gave any suitable idea.
> > > >
> > > > 

Re: mysql on Linux

[Scott Helms]

Mark,

This probably won't get you the response you wanted.  How about letting
us know where you have gotten to and where things seem to be breaking.  A
generalized request for "what do I do" often recieves little or no help.
Some basic system information would also be much appreciated; what distro
are you using, what type of hardware PPC, Intel, etc.


Scott
- Original Message -
From: "Intrex" <[EMAIL PROTECTED]>
To: "Jorge del Conde" <[EMAIL PROTECTED]>; "'Manish Mehta'"
<[EMAIL PROTECTED]>; "'mysql'" <[EMAIL PROTECTED]>
Sent: Tuesday, March 05, 2002 6:23 PM
Subject: Re: mysql on Linux


> Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100
> TIMES is NO help.  I have read this file, I have used the appropriate
> .tar.gz, I have reinstalled, I have used the most current RPM's
>
> How about contributing something USEFUL, like a REAL answer, that anyone
can
> follow.  No cryptic mumbo jumbo, no PhD CRAPOLA.
>
> I mean REALLY.
>
> Mark
>
> - Original Message -
> From: "Jorge del Conde" <[EMAIL PROTECTED]>
> To: "'Manish Mehta'" <[EMAIL PROTECTED]>; "'mysql'"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, October 09, 2001 1:48 AM
> Subject: RE: mysql on Linux
>
>
> > Hi,
> >
> > Download the binary distribution that suits your system and read the
> > "INSTALL-BINARY" file.
> >
> > Also, make sure the online documentation at
> > http://www.mysql.com/documentation/index.html
> >
> > Regards,
> > Jorge
> >
> > For technical support contracts, visit https://order.mysql.com/
> >__  ___ ___   __
> >   /  |/  /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
> >  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
> > /_/  /_/\_, /___/\___\_\___/   Mexico City, Mexico
> ><___/   www.mysql.com
> >
> >
> >
> > > -Original Message-
> > > From: Manish Mehta [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, October 09, 2001 12:34 AM
> > > To: mysql
> > > Subject: mysql on Linux
> > >
> > >
> > > Hello
> > >
> > > I want to install mysql on Linux.
> > > What are the basic step followed at the time of installation.
> > >
> > > pl. gave any suitable idea.
> > >
> > > Manish Mehta
> > > E-mail: [EMAIL PROTECTED]
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[Christopher Thompson]

No need to get all snarky.  People are confused because there's a whole 
section in the manual that covers the installation, step-by-step, with no 
cryptic mumbo jumbo.  This is at 
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Linux-RPM 
and basically tells you to download the RPM and then install it using rpm -i.

Alternatively, if you have a .tar.gz file, you can follow the install 
directions given therein.

We _CANNOT_ help you further without you telling us what part of the install 
you are having problems with.  The step-by-step instructions are available as 
people have pointed out.  So what are you asking for?

On Tuesday 05 March 2002 4:23 pm, Intrex wrote:
> Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100
> TIMES is NO help.  I have read this file, I have used the appropriate
> .tar.gz, I have reinstalled, I have used the most current RPM's
>
> How about contributing something USEFUL, like a REAL answer, that anyone
> can follow.  No cryptic mumbo jumbo, no PhD CRAPOLA.
>
> I mean REALLY.
>
> Mark
>
> - Original Message -
> From: "Jorge del Conde" <[EMAIL PROTECTED]>
> To: "'Manish Mehta'" <[EMAIL PROTECTED]>; "'mysql'"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, October 09, 2001 1:48 AM
> Subject: RE: mysql on Linux
>
> > Hi,
> >
> > Download the binary distribution that suits your system and read the
> > "INSTALL-BINARY" file.
> >
> > Also, make sure the online documentation at
> > http://www.mysql.com/documentation/index.html
> >
> > Regards,
> > Jorge
> >
> > For technical support contracts, visit https://order.mysql.com/
> >__  ___ ___   __
> >   /  |/  /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
> >  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
> > /_/  /_/\_, /___/\___\_\___/   Mexico City, Mexico
> ><___/   www.mysql.com
> >
> > > -Original Message-
> > > From: Manish Mehta [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, October 09, 2001 12:34 AM
> > > To: mysql
> > > Subject: mysql on Linux
> > >
> > >
> > > Hello
> > >
> > > I want to install mysql on Linux.
> > > What are the basic step followed at the time of installation.
> > >
> > > pl. gave any suitable idea.
> > >
> > > Manish Mehta
> > > E-mail: [EMAIL PROTECTED]
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
>
> <[EMAIL PROTECTED]>
>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql on Linux

[Intrex]

Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100
TIMES is NO help.  I have read this file, I have used the appropriate
.tar.gz, I have reinstalled, I have used the most current RPM's

How about contributing something USEFUL, like a REAL answer, that anyone can
follow.  No cryptic mumbo jumbo, no PhD CRAPOLA.

I mean REALLY.

Mark

- Original Message -
From: "Jorge del Conde" <[EMAIL PROTECTED]>
To: "'Manish Mehta'" <[EMAIL PROTECTED]>; "'mysql'"
<[EMAIL PROTECTED]>
Sent: Tuesday, October 09, 2001 1:48 AM
Subject: RE: mysql on Linux


> Hi,
>
> Download the binary distribution that suits your system and read the
> "INSTALL-BINARY" file.
>
> Also, make sure the online documentation at
> http://www.mysql.com/documentation/index.html
>
> Regards,
> Jorge
>
> For technical support contracts, visit https://order.mysql.com/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
>  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
> /_/  /_/\_, /___/\___\_\___/   Mexico City, Mexico
><___/   www.mysql.com
>
>
>
> > -Original Message-
> > From: Manish Mehta [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 09, 2001 12:34 AM
> > To: mysql
> > Subject: mysql on Linux
> >
> >
> > Hello
> >
> > I want to install mysql on Linux.
> > What are the basic step followed at the time of installation.
> >
> > pl. gave any suitable idea.
> >
> > Manish Mehta
> > E-mail: [EMAIL PROTECTED]
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: mysql on Linux

[Jorge del Conde]

Hi,

Download the binary distribution that suits your system and read the
"INSTALL-BINARY" file.

Also, make sure the online documentation at
http://www.mysql.com/documentation/index.html

Regards,
Jorge

For technical support contracts, visit https://order.mysql.com/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Jorge del Conde <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Mexico City, Mexico
   <___/   www.mysql.com



> -Original Message-
> From: Manish Mehta [mailto:[EMAIL PROTECTED]] 
> Sent: Tuesday, October 09, 2001 12:34 AM
> To: mysql
> Subject: mysql on Linux
> 
> 
> Hello 
> 
> I want to install mysql on Linux.
> What are the basic step followed at the time of installation.
> 
> pl. gave any suitable idea. 
> 
> Manish Mehta
> E-mail: [EMAIL PROTECTED]


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL on Linux, Athlon MP stability?

[Femme Taken - Tweakers.net]

We have been using a dual Athlon MP 1600+ (1,4GHz) MySQL box since 
december. Stability is rock solid and the performance is consirably 
higher than our previous dual PIII-1000 server (>40% clock speed 
difference).

Configuration: Tyan Thunder K7 motherboard, 2GB RAM, Adaptec 3200S 
SCSI-RAID, 3x Seagate Cheetah X15, 4U rackmount. Slackware Linux with 
2.4.17 kernel, MySQL 3.23.47. We also have a dual Athlon MP 1,2GHz 
webserver based on the Tyan Tiger MP.

Good CPU cooling is very important, especially when building a 2U dual 
Athlon server. Big heatsinks with big 6cm fans will limit the airflow 
because the fan is too close to the top of the case. Use ECC Registered 
memory and a high quality power supply. You will need at least 300W for 
a light webserver configuration and >400W for a heavy duty db server 
with SCSI RAID.




>Hello!
>I'm in the process of upgrading my Linux-server (currently a dual P2-400MHz), and 
>have been thinking
>about getting a system with dual Athlons (maybe 2x Athlon MP 1800+).
>Does anyone have any experience (good or bad) with a dual Athlon system with Linux 
>running MySQL
>3.23.x, and maybe Apache under HEAVY load?

>Since the Athlon MP's haven't been around for very long, I'm a bit concerned about 
>the stability
>under heavy load on the 2.4 kernel...

>So please, if you have a success- or disaster-story I'd like to know! :)
>I'm also very interested in what mainboard you are using for the Athlons, and what 
>Linux-kernel
>version you're running...

>Thanks in advance!
>/Tobias Lind





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL on Linux, Athlon MP stability?

[Christopher Thompson]

On Wednesday 13 February 2002 12:10 pm, Trond Eivind Glomsrød wrote:
>
> Our kernel people love them - Athlon goodness, no VIA chipset. Good
> performance, good stability.

Note that the Via kt266a (_not_ SMP chipset) is quite good these days.

If I was building a dual-processor machine, there's no doubt I'd go for an 
Athlon system at the moment.  For a quad-processor machine, I'd look much 
more closely at the P3 Xeon chip (the P4 Xeon has no 4-processor motherboards 
afaik).

ObMySQL:  Make sure you are CPU-limited before considering SMP machines.  If 
you are hard drive limited, you aren't likely to see any advantage going for 
more CPUs.  SELECT MySQL PostGreSQL, UPDATE, INSERT, terrorism, world trade 
centre, replication, etc.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL on Linux, Athlon MP stability?

[Matthew Walker]

Well, I don't have anything yet, but I've got a server in the mail
coming to me that is a dual Athlon MP 1900+. I'll be getting it either
today, or tomorrow with any luck, and I'll let you know how things go.

Gonna be running SuSE 7.3, PHP, MySQL, Apache, BIND9 and various other
packages on it. Oh, and SETI@Home, to burn in the processors. ;)

Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs


-Original Message-
From: Tobias Lind - Telia Internet [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, February 13, 2002 9:32 AM
To: [EMAIL PROTECTED]
Subject: MySQL on Linux, Athlon MP stability?

Hello!
I'm in the process of upgrading my Linux-server (currently a dual
P2-400MHz), and have been thinking
about getting a system with dual Athlons (maybe 2x Athlon MP 1800+).
Does anyone have any experience (good or bad) with a dual Athlon system
with Linux running MySQL
3.23.x, and maybe Apache under HEAVY load?

Since the Athlon MP's haven't been around for very long, I'm a bit
concerned about the stability
under heavy load on the 2.4 kernel...

So please, if you have a success- or disaster-story I'd like to know! :)
I'm also very interested in what mainboard you are using for the
Athlons, and what Linux-kernel
version you're running...

Thanks in advance!
/Tobias Lind



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002
 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL on Linux, Athlon MP stability?

[Trond Eivind Glomsrød]

"Tobias Lind - Telia Internet" <[EMAIL PROTECTED]> writes:

> Hello!  I'm in the process of upgrading my Linux-server (currently a
> dual P2-400MHz), and have been thinking about getting a system with
> dual Athlons (maybe 2x Athlon MP 1800+).  Does anyone have any
> experience (good or bad) with a dual Athlon system with Linux running
> MySQL 3.23.x, and maybe Apache under HEAVY load?

Our kernel people love them - Athlon goodness, no VIA chipset. Good
performance, good stability.

> Since the Athlon MP's haven't been around for very long, I'm a bit
> concerned about the stability under heavy load on the 2.4 kernel...

Ve've supported it since RHL 7.1 (which was released before the Athlon
MP, if memory serves :).

> So please, if you have a success- or disaster-story I'd like to know!
> :) I'm also very interested in what mainboard you are using for the
> Athlons, and what Linux-kernel version you're running...

Red Hat Linux, various release and test versions (kernel and
surrounding OS).

-- 
Trond Eivind Glomsrød
Red Hat, Inc.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php