mysql on linux tutorials written by me for community

2010-12-18 Thread shahryar ghazi
More MySQL tutorials: opensource-db-tools - A set of open source tools for MySQL http://www.geeksww.com/tutorials/database_management_systems/mysql/tools/opensourcedbtools__a_set_of_open_source_tools_for_mysql.php How to install MySQL Gearman UDF on Ubuntu/Debian

Re: Automate Install/Configuration of MySQL on Linux

2010-07-29 Thread 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

Re: Automate Install/Configuration of MySQL on Linux

2010-07-28 Thread Rob Wultsch
On Tue, Jul 27, 2010 at 1:56 PM, Todd E Thomas 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

Automate Install/Configuration of MySQL on Linux

2010-07-27 Thread 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.

Re: Mysql on linux - choosing the right filesystem

2007-02-25 Thread 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

Mysql on linux - choosing the right filesystem

2007-02-24 Thread 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

mysql-4.1.14 + linux kernel 2.6.15.1 = compile error

2006-01-21 Thread renito73
Hello list I have just upgraded my system and was reinstalling all the programs, but got problems with a few ones, including mysql 4.1.14. When compiling I get the following error, I think it may be possible because changes in the kernel headers but am not sure because it was compiling fine in

install mysql on linux AMD64 processor

2005-12-30 Thread 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

How to start mysql on linux?

2005-11-22 Thread Jerry Swanson
I have sudo access to Linux box. How to start mysql 4.0.14. TH

Re: How to start mysql on linux?

2005-11-22 Thread 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 :-) http://dev.mysql.com/doc/refman/4.1/en/server-side-scripts.html -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design

Re: Max Connections of MySQL on Linux

2005-06-27 Thread 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

Newbie mysql windows-linux prob

2005-06-27 Thread Prashanth H. Baragur
mysql-5.0.7-beta-win32 in windows XP. However the same client(hostname alone changed) is able to communicate and create database when i run the mysql server on linux machine. Am using MySQL-devel-5.0.7-0.i386.rpm in linux. Another question: I use the following command to compile the client

Max Connections of MySQL on Linux

2005-06-26 Thread 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

Doubt on MySQL for Linux...

2005-06-24 Thread Ashok Kumar
Hi friends, I'm now started to using the Redhat-Linux. Now i want to start MySQL on Linux. I'm not having much idea about Linux. I'm new to this. For Linux which MySQL installation i've to choose from the site. there are lot of binary distributions, i don't which one is compatible for my OS

Re: Doubt on MySQL for Linux...

2005-06-24 Thread Danny Stolle
Ashok Kumar wrote: Hi friends, I'm now started to using the Redhat-Linux. Now i want to start MySQL on Linux. I'm not having much idea about Linux. I'm new to this. For Linux which MySQL installation i've to choose from the site. there are lot of binary distributions, i don't which one

Access to MySQL from Linux command line

2005-05-23 Thread Andrew Dixon - MSO.net
Hi All. Does anyone know of any tools to convert a MS Access file to MySQL from the Linux command line? Thanks. Andrew

Re: Access to MySQL from Linux command line

2005-05-23 Thread Andrew Dixon - MSO.net
Hi Adam. I need to get all the data. Andrew Adam wrote: Drew, That's vague. Specifically what do you want from the Access database (e.g. schema, data, etc.)? A-

Re: Access to MySQL from Linux command line

2005-05-23 Thread Chris Faulkner
Export as CSV. MySQL command line client. Run a script with LOAD DATA INFILE. Chris On 5/23/05, Andrew Dixon - MSO.net [EMAIL PROTECTED] wrote: Hi Adam. I need to get all the data. Andrew Adam wrote: Drew, That's vague. Specifically what do you want from the Access

msAccess to Mysql on Linux

2005-02-26 Thread 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='#'

Re: access to mysql in linux

2005-02-23 Thread Gleb Paharenko
Hello. It is a frequently asked question. Search in the list. For example see thread: http://lists.mysql.com/mysql/160391 Sebastian Luque [EMAIL PROTECTED] wrote: Dear List members, Having relatively recently moved to GNU/Debian Linux from Windows, I'd like to move my MS

access to mysql in linux

2005-02-21 Thread Sebastian Luque
Dear List members, Having relatively recently moved to GNU/Debian Linux from Windows, I'd like to move my MS Access databases to MySQL. I'm using the latest unstable MySQL version and am all setup with user, passwords, and privileges, so can create and modify databases in MySQL. Searching for

Re: New to MySQL on Linux

2005-02-12 Thread 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

New to MySQL on Linux

2005-02-11 Thread 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

Re: New to MySQL on Linux

2005-02-11 Thread 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

Re: New to MySQL on Linux

2005-02-11 Thread Hassan Schroeder
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

RE: New to MySQL on Linux

2005-02-11 Thread Dean, Michael L USAATC
: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

Re: New to MySQL on Linux

2005-02-11 Thread 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

Re: New to MySQL on Linux

2005-02-11 Thread 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

Re: Setup question on mysql under Linux

2005-01-19 Thread Eric Bergen
Have you tried using mysqld_safe --user=mysql 'mysql' being the name of the user you want mysqld to run as. -Eric On Tue, 18 Jan 2005 20:33:38 -0800, Russ [EMAIL PROTECTED] wrote: I'm having trouble getting myslqd to run as a user other than root when it is started by mysqld_safe. I folowed

Setup question on mysql under Linux

2005-01-18 Thread Russ
I'm having trouble getting myslqd to run as a user other than root when it is started by mysqld_safe. I folowed the steps in the manual but mysqld continues to run as root, mysqld_safe runs as the changed user. I check my.conf and the user statement is in the mysqld section as outlined. If I

Re: Update on installing mysql on linux

2004-07-26 Thread 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,

Re: Update on installing mysql on linux

2004-07-22 Thread 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

Re: cannot install mysql on linux using RPM's

2004-07-21 Thread 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

Update on installing mysql on linux

2004-07-21 Thread 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?

cannot install mysql on linux using RPM's

2004-07-20 Thread 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)

2004-04-28 Thread 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

Restore problem between MySQL on Win32 and MySQL on Linux?

2004-04-23 Thread 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

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

2004-04-23 Thread 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

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

2004-04-23 Thread g . lams
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

Re: MySQL on Linux

2004-04-09 Thread 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

Re: MySQL on Linux

2004-04-09 Thread 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

Re: MySQL on Linux

2004-04-08 Thread Benjamin Arai
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

Re: MySQL on Linux

2004-04-07 Thread Peter J Milanese
[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

Re: MySQL on Linux

2004-04-07 Thread 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

MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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,

Re: MySQL on Linux

2004-04-06 Thread 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,

Re: MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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

Re: MySQL on Linux

2004-04-06 Thread 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

RE: MySQL on Linux

2004-04-06 Thread DChristensen
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

RE: Installing MySQL on Linux, HELP!

2004-01-15 Thread 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

RE: Installing MySQL on Linux, HELP!

2004-01-15 Thread 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

RE: Installing MySQL on Linux, HELP!

2004-01-15 Thread 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

RE: Installing MySQL on Linux, HELP!

2004-01-15 Thread 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

Installing MySQL on Linux, HELP!

2004-01-14 Thread Eve Atley
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

Re: French characters ok with mysql in Windows, nok with mysql in Linux

2004-01-06 Thread David Bordas
From: Willy Dockx [EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:23 PM Subject: RE: French characters ok with mysql in Windows, nok with mysql in Linux Hello, etc/sysconfig/i18n contains: LANG=en_US.UTF-8 SUPPORTED=nl_BE.UTF-8:nl_BE:nl:en_US.UTF-8:en_US:en SYSFONT=latarcyrheb-sun16

RE: French characters ok with mysql in Windows, nok with mysql in Linux

2004-01-06 Thread Willy Dockx
januari 2004 8:39 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] Sent: Monday, January 05, 2004 7:23 PM Subject: RE: French characters ok with mysql in Windows, nok with mysql in Linux Hello

French characters ok with mysql in Windows, nok with mysql in Linux

2004-01-05 Thread Willy Dockx
Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution of this problem is really important for me. Can anybody help? I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this

Re: French characters ok with mysql in Windows, nok with mysql in Linux

2004-01-05 Thread David Bordas
From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem end of 2003, but probably, the champagne has troubled the answers. The solution

RE: French characters ok with mysql in Windows, nok with mysql in Linux

2004-01-05 Thread Willy Dockx
PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004 3:00 PM Subject: French characters ok with mysql in Windows, nok with mysql in Linux Hello, I already posted this problem

RE: French characters ok with mysql in Windows, nok with mysql in Linux

2004-01-05 Thread Willy Dockx
characters ok with mysql in Windows, nok with mysql in Linux Have you looked at character set options in MySQL config files? You can see the differences between the servers executing the query: show variables like '%character_set%'; Bye Oriol - Original Message - From: Willy Dockx [EMAIL

RE: French characters ok with mysql in Windows, nok with mysql in Linux

2004-01-05 Thread Willy Dockx
Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:18 To: Willy Dockx Cc: [EMAIL PROTECTED] Subject: Re: French characters ok with mysql in Windows, nok with mysql in Linux From: Willy Dockx [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 05, 2004

French characters ok with mysql in Windows, nok with mysql in Linux

2003-12-31 Thread Willy Dockx
Hello, I have made a website using jboss, Hibernate, mysql 4.0.16 and mysql-connector-java-3.0.9. In development this is installed on Windows2000 and everything works fine, also when the user inputs characters like é, à, è, … In production this is installed on Linux (RedHat 8). There

Japanese display problem with mysql on Linux

2003-10-07 Thread 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

Problems with MySQL on Linux (Linux Newbie)

2003-09-23 Thread 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

Re: Problems with MySQL on Linux (Linux Newbie)

2003-09-23 Thread 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

setting maximum threads for MySQL under Linux

2003-02-04 Thread Martin Waite
Hi, Is there any better way of setting the thread/process limit on Linux than by hacking the safe_mysqld script ? Have I missed a configuration variable somewhere that will tell MySQL to attempt to raise the process limit ? I would have thought MySQL would figure it out based on the

req. for help for installing mysql under linux

2002-12-31 Thread sireesha vudatha
Hi all, I am a newbie(student) to mysql in linux environment. I was trying to install the mysql-3.23.51-pc-linux-gnu-i686.tar.gz on my linux - mandrake 8.2 from sourceforge.net. When I type in ./configure, it says, there is no need to configure for binary..., then the mysqld starts

mysql-4.0.5a+linux+FLUSH QUERY CACHE = crash

2002-12-05 Thread Andrew Sitnikov
Hello mysql, after FLUSH QUERY CACHE in error.log 021127 17:25:17 mysqld started 021127 17:25:19 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it

Re: mysql-4.0.5a+linux+FLUSH QUERY CACHE = crash

2002-12-05 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Thu, 5 Dec 2002, Andrew Sitnikov wrote: after FLUSH QUERY CACHE key_buffer_size=402649088 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=115 max_connections=200 threads_connected=6 It is possible that mysqld

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

2002-11-26 Thread Cem Yagli
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

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

2002-11-26 Thread Egor Egorov
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

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

2002-11-25 Thread Cem Yagli
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

starting Mysql on linux

2002-11-10 Thread Stick Dragon
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

Re: starting Mysql on linux

2002-11-10 Thread Adolfo Bello
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

Re: starting Mysql on linux

2002-11-10 Thread 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

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

2002-10-19 Thread 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

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

2002-10-18 Thread 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

Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread 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

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

2002-10-18 Thread 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

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

2002-10-18 Thread 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

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

2002-10-18 Thread 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

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

2002-10-18 Thread Will Merrell
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

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

2002-10-18 Thread Ed Carp
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

MYSQL/GNU-Linux CLasses by User Group in NYC

2002-08-04 Thread Ruben I Safir
Revised Class Schedule Free Software Institute REVISED Class Schedule for August: Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1 bunlde $550 - Students talking GNU/Linux 1 are require to purchase a computer used for the rest of the corse work Complete program package -

Fwd: MYSQL/GNU-Linux CLasses by User Group in NYC [ruben@www2]

2002-08-04 Thread Ruben I Safir
SQL MYSQL On 2002.08.04 14:46 Ruben I Safir wrote: Revised Class Schedule Free Software Institute REVISED Class Schedule for August: Classes $300 individually perl 1 and 2 bundle $550 GNU/Linux 1 Unix 1 bunlde $550 - Students talking GNU/Linux 1 are require to purchase a computer used for the

RE: MySql on Linux Clustering..?

2002-08-02 Thread Kerry Ancheta
, 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

Re: MySql on Linux Clustering..?

2002-08-02 Thread Mike Hall
? --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

RE: MySql on Linux Clustering..?

2002-08-02 Thread Kerry Ancheta
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 turn off query logging in mysql, redhat linux

2002-05-15 Thread Tom Blumer
Hello I am trying to turn off the query log in mysql on redhat linux. It generates huge log files (in /var/lib/mysql/hostname.log) that I dont need, and impacts performance. safe_mysqld was run with --log, and it seems like I want to turn that off but I cant find any script or config file

Re: how to turn off query logging in mysql, redhat linux

2002-05-15 Thread (Borus.Kung)
Blumer [EMAIL PROTECTED] ¦¬¥óªÌ: [EMAIL PROTECTED] ¶Ç°e¤é´Á: 2002¦~5¤ë16¤é AM 11:02 ¥D¦®: how to turn off query logging in mysql, redhat linux Hello I am trying to turn off the query log in mysql on redhat linux. It generates huge log files (in /var/lib/mysql/hostname.log) that I dont need

Installing mysql on Linux

2002-05-11 Thread 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

Re: Installing mysql on Linux

2002-05-11 Thread 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

Re: Installing mysql on Linux

2002-05-11 Thread 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

  1   2   3   >