mysql on linux tutorials written by me for community
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 Linuxhttp://www.geeksww.com/tutorials/operating_systems/linux/tools/how_to_install_mysql_gearman_udf_on_ubuntudebian_linux.php Installing MySQL Client tools, binaries, and library on Ubuntuhttp://www.geeksww.com/tutorials/libraries/freetds/installation/installing_mysql_client_tools_binaries_and_library_on_ubuntu_linux.php -- Shahryar Ghazi IT Professional -- Geeks Worldwide (www.geeksww.com)
Re: Automate Install/Configuration of MySQL on Linux
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 todd_...@ssiresults.com 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
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 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
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
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
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 nest 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 lexpé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 derreur puisque les informations quil 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]
mysql-4.1.14 + linux kernel 2.6.15.1 = compile error
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 2.6.11.11 and now have problems with 2.6.15.1 The output is this: --- if g++ -DDEFAULT_BASEDIR=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I. -I. -I.. -I../include -I../include -I.-O3 -DDBUG_OFF-fno-implicit-templates -fno-exceptions -fno-rtti -MT my_new.o -MD -MP -MF .deps/my_new.Tpo -c -o my_new.o my_new.cc; \ then mv -f .deps/my_new.Tpo .deps/my_new.Po; else rm -f .deps/my_new.Tpo; exit 1; fi In file included from /usr/include/asm/atomic.h:6, from ../include/my_global.h:280, from mysys_priv.h:17, from my_new.cc:22: /usr/include/asm/processor.h: In function `void set_in_cr4(long unsigned int)': /usr/include/asm/processor.h:237: error: `read_cr4' undeclared (first use this function) /usr/include/asm/processor.h:237: error: (Each undeclared identifier is reported only once for each function it appears in.) /usr/include/asm/processor.h:239: error: `write_cr4' undeclared (first use this function) /usr/include/asm/processor.h: In function `void clear_in_cr4(long unsigned int) ': /usr/include/asm/processor.h:248: error: `write_cr4' undeclared (first use this function) make[2]: *** [my_new.o] Error 1 make[2]: Leaving directory `/tmp/mysql-4.1.14/mysys' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/tmp/mysql-4.1.14' make: *** [all] Error 2 -- In particular the problem is that the following symbols are undeclared set_in_cr4, read_cr4, write_cr4, clear_in_cr4 My include directory links are so For kernel 2.6.11.11 /usr/src/linux - /usr/src/linux-2.6.11.11 For kernel 2.6.15.1 /usr/src/linux - /usr/src/linux-2.6.15.1 For the includes /usr/include/linux - /usr/src/linux/include/linux /usr/include/asm - /usr/src/linux/include/asm-i386 /usr/include/asm-generic - /usr/src/linux/include/asm-generic to compile with different kernel versions just set the appropiate /usr/src/linux link to 2.6.11.11 or 2.6.15.1 and reboot with that kernel to ensure not only the kernel headers but the running kernel are the same before compile. With kernel 2.6.11.11 compiles fine, but when trying 2.6.15.1 simply spits errors and aborts. Does anybody have the same kernel version and problem? and if so, were you able to solve the problem? I insist that the problem could be some modifications in the latest kernel headers and that mysql uses probably the previous version... I don't know too much about it but is a simple idea... Any comment, sugestion or idea? Regards, Miguel -- 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
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: code/input/activities to reproduce the problem (multiple lines) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:root Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) 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: machine, os, target, libraries (multiple lines) 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]
How to start mysql on linux?
I have sudo access to Linux box. How to start mysql 4.0.14. TH
Re: How to start mysql on linux?
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 === (+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: Max Connections of MySQL on Linux
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]
Newbie mysql windows-linux prob
Hi, Am a newbie to mysql. I am trying to deploy mysql database server on a windows machine and update this database from a remote linux machine(client) periodically. The connection to mysql server in windows is failing when i run the client program at mysql_real_connect (). Am using 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 application. gcc connect1.c -o mycli -I /usr/include/mysql/ -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm Is it possible to port these libraries to ECOS RTOS so that the above client app(mycli) can run on a embedded device(IXP425 board) ? Any comments are highly appreciable. Thanks prashanth
Max Connections of MySQL on Linux
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]
Doubt on MySQL for Linux...
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. Linux and H/W specification of my system is as follows. 1. Redhat Linux 9 2. Intel PIII And i also want to know abt how to install and configure MySQL for using that in 'C'. Pls guide me in this. Thanks and Regards, Ashok Kumar.P.S. Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Doubt on MySQL for Linux...
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 is compatible for my OS. Linux and H/W specification of my system is as follows. 1. Redhat Linux 9 2. Intel PIII And i also want to know abt how to install and configure MySQL for using that in 'C'. Pls guide me in this. Thanks and Regards, Ashok Kumar.P.S. Yahoo! Sports Rekindle the Rivalries. Sign up for Fantasy Football http://football.fantasysports.yahoo.com Ashok, I suggest that you carefully read the documentation on http://dev.mysql.com/doc/mysql/en/index.html Here you can find the installation program and tutorials to help you get through MySql If you are new to Linux, then perhaps reading some stuff about linux first. Good luck and enjoy :^) Best Regards, Danny Stolle Netherlands EmoeSoft (http://www.emoesoft.nl) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access to MySQL from Linux command line
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
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
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 database (e.g. schema, data, etc.)? A- -- 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
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: access to mysql in linux
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 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 tools to migrate my MS Access databases, I've come across mdbtools, with which I can see and export the tables to csv, but the process of getting them into MySQL is tedious and cumbersome. The script mdb-schema in mdbtools can export the tables to other DBMS formats, excluding MySQL unfortunately. Can somebody please suggest other, more convenient, tools (free preferably) to make this transition? Best wishes, -- 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]
access to mysql in linux
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 tools to migrate my MS Access databases, I've come across mdbtools, with which I can see and export the tables to csv, but the process of getting them into MySQL is tedious and cumbersome. The script mdb-schema in mdbtools can export the tables to other DBMS formats, excluding MySQL unfortunately. Can somebody please suggest other, more convenient, tools (free preferably) to make this transition? Best wishes, -- Sebastian Luque -- 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
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]
New to MySQL on Linux
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
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]
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]
RE: New to MySQL on Linux
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
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
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: Setup question on mysql under Linux
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 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 manually start mysqld directly it runs as the changed user. so its something in mysqld thats changing it but I cannot find out what. I have a little programming knowledge but I'm no master. Can anyone point me in the right direction? Thanks in advance!!! -- Russ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Eric Bergen [EMAIL PROTECTED] http://www.bleated.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Setup question on mysql under Linux
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 manually start mysqld directly it runs as the changed user. so its something in mysqld thats changing it but I cannot find out what. I have a little programming knowledge but I'm no master. Can anyone point me in the right direction? Thanks in advance!!! -- Russ -- 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
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
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]
Re: cannot install mysql on linux using RPM's
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]
Update on installing mysql on linux
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
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)
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]
Restore problem between MySQL on Win32 and MySQL on Linux?
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: Restore problem between MySQL on Win32 and MySQL on Linux?
[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?
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: MySQL on Linux
%% 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
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
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
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
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]
MySQL on Linux
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: MySQL on Linux
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
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
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
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
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 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
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
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
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
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
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: Installing MySQL on Linux, HELP!
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]
RE: Installing MySQL on Linux, HELP!
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!
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!
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
Installing MySQL on Linux, HELP!
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]
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, 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 Is that ok? I can't remenber what was my conf, but google is you friend ... http://groups.google.fr/groups?hl=frie=UTF-8oe=UTF-8q=french+redhat+i18nsa=Ntab=wgmeta= http://groups.google.fr/groups?hl=frlr=ie=UTF-8oe=UTF-8q=accent+redhat+i18n Did you try to connect directly to MySQL through a standard MySQL client and make an insert with é à ù ... and see if the select is ok after the insert ? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Don't know, i'm not using java ... Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, I changed etc/sysconfig/i18n to: LANG=fr_FR SUPPORTED=fr_FR:fr SYSFONT=lat0-sun16 SYSFONTACM=iso15 and everything works perfectly. Thank you very much for your help. Greetings, Willy Dockx -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED] Sent: dinsdag 6 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, 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 Is that ok? I can't remenber what was my conf, but google is you friend ... http://groups.google.fr/groups?hl=frie=UTF-8oe=UTF-8q=french+redhat+i18n; sa=Ntab=wgmeta= http://groups.google.fr/groups?hl=frlr=ie=UTF-8oe=UTF-8q=accent+redhat+i 18n Did you try to connect directly to MySQL through a standard MySQL client and make an insert with é à ù ... and see if the select is ok after the insert ? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Don't know, i'm not using java ... Bye David -- 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]
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 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 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 also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. Ive tried to put useUnicode=truecharacterEncoding=UTF-8 in the driver connection url, but this doesnt help. Can anyone help me on this problem? Greetings, Willy Dockx -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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 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 also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: French characters ok with mysql in Windows, nok with mysql in Linux
Hello, Thank you for your quick response. I start with an empty database. So the data isn't exported. Then users enter data in a web-page. It is this data that can contain French characters and that is added by the java servlet to the database. I will look at the file /etc/sysconfig/i18n this evening (I can not get on the Linux system at this moment). I'm not a linux-expert. I didn't change anything in that file until now. Greetings, Willy Dockx -Original 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 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 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 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 also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- 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: French characters ok with mysql in Windows, nok with mysql in Linux
Both are the same: Character-set : latin1 Character-sets : a long list Convert_Character_set : Is that like it should be? Greetings, Willy Dockx -Original Message- From: Oriol [mailto:[EMAIL PROTECTED] Sent: maandag 5 januari 2004 15:55 To: Willy Dockx Subject: Re: French 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 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 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 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 also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Greetings, Willy Dockx -- 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: 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 Is that ok? What concerns the 'driver connection url' : should I leave 'useUnicode=truecharacterEncoding=UTF-8' in it? Greetings, Willy Dockx -Original 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 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 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 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 also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. I've tried to put 'useUnicode=truecharacterEncoding=UTF-8' in the driver connection url, but this doesn't help. Can anyone help me on this problem? Hi, I'm storing french characters with MySQL under Linux RedHat. Hox did you export your data to Linux ? Did you look to the file /etc/sysconfig/i18n ? The default file is quite buggy under RedHat 8. Bye David -- 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]
French characters ok with mysql in Windows, nok with mysql in Linux
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 also everything works fine, except for the strange characters é, à, è. I suppose the reason is that RedHat uses UTF-8 as encoding. Ive tried to put useUnicode=truecharacterEncoding=UTF-8 in the driver connection url, but this doesnt help. Can anyone help me on this problem? Greetings, Willy Dockx
Japanese display problem with mysql on Linux
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]
Problems with MySQL on Linux (Linux Newbie)
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: Problems with MySQL on Linux (Linux Newbie)
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 (host_name.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]
setting maximum threads for MySQL under Linux
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 max_connections value. == Martin - 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
req. for help for installing mysql under linux
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 and closes off immediately... My hostname.err contains the following message... Since, I don't know anything about crashing and signals in linux, can anyone tell me what might have gone wrong with the installation process... after looking at the following or any pointers for installing mysql... (Also, I tried to install mysql-3.23.47-pc-linux-gnu-i686.tar.gz, but it also was having the same problem...) 021231 16:33:50 mysqld started 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 was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=8388600 record_buffer=131072 sort_buffer=2097144 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 225791 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffda88, stack_bottom=0x1cd1fa80, thread_stack=65536, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x1be1fb70 is invalid pointer thd-thread_id=65537 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 65537 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash 021231 16:33:51 mysqld ended Thanks in advance.. Sireesha _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemailxAPID=42PS=47575PI=7324DI=7474SU= http://www.hotmail.msn.com/cgi-bin/getmsgHL=1216hotmailtaglines_addphotos_3mf - 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-4.0.5a+linux+FLUSH QUERY CACHE = crash
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 was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. 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 could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211610 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8a7e870 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfd1f2a8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80de403 0x80de1ab 0x80dcbd9 0x807dc27 0x807bdb3 0x807cad5 0x8077d4b 0x8077795 0x8077007 0x82657cc 0x829ad6a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Res olved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x66daadf0 is invalid pointer thd-thread_id=431408 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 431408 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 021205 00:49:35 mysqld restarted Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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-4.0.5a+linux+FLUSH QUERY CACHE = crash
-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 could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211610 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8a7e870 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfd1f2a8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80de403 0x80de1ab 0x80dcbd9 0x807dc27 0x807bdb3 0x807cad5 0x8077d4b 0x8077795 0x8077007 0x82657cc 0x829ad6a New value of fp=(nil) failed sanity check, terminating stack trace! Unfortunately this info is not very helpful - we would need some more background info and a repeatable test case to be able to resolve this :( The command above is part or our test suites and passed fine during the build phase. Can you reliably reproduce this? If yes, please describe in more detail, how. Thanks! LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE97yxMSVDhKrJykfIRAmGcAJ4wrh3hm5m1KnUcllsyfLuKEGofdwCfcX2K UaBYB6ofrEzb7h9p4W3sCHY= =cQlM -END PGP SIGNATURE- - 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
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
re: Have a problem when I try to connect MySQL( on Linux) thru win32
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
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
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
Re: starting Mysql on linux
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
Re: starting Mysql on linux
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: Connecting to MySQL on Linux from a Windows machine. -- Resolved !!
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.
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
Connecting to MySQL on Linux from a Windows machine.
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.
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
RE: Connecting to MySQL on Linux from a Windows machine.
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.
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.
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.
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
MYSQL/GNU-Linux CLasses by User Group in NYC
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 - perl1, perl2, gnu/linux 1, unix 1, gnu/linux 2, unix 2 Database Programming 1, Introdution to Networking 1 $4000 Perl2 - Object Orientation in Perl · Basic CGI Programming · Database usage and SQL · Building Database Web Applications with DBI · Basic MYSQL administration and SQL · Templating Web Design and Rapid Development with Perl · Introduction to mod_perl · Writing Basic Apache Tuesday at ASHA: 7:00PM - 11:00PM August 6th August 13th August 20th August 27th September 3rd Unix 1 - Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Wednesday at Rozensweig and Maffia 7PM-11:00 August 7th August 14th August 21st Augisyt 28th September 4th Linux 2 - Apache Installation: Download Source Code untar make make install Configure Apache Apache root httpd.conf initiation startup script httpd processes htdocs directory mysql installation Download source untar make install set initial permissions set up initiation file System monitoring tripwire system log monitoring top kill renice/nice last who w netstat route cron/crontab Port scanning/network security nmap inetd.conf tcp wrappersm- hosts.allow hosts.deny simple package forwarding, firewall, ipchains/NAT sshd,encrypted channels, VPN Thusdays - Brooklyn NYLXS Headquarters - 7PM-11:00PM August 8th August 15th August 21st August 28th September 5th Unix 2 - shell scripting, C programming, Desktop X Tuesdays NYLXS Headquarters - Brooklyn August 6th August 13th August 20th August 27th September 3rd -- Total program for reference: Sylibus: Introduction to GNU/Linux Installation Boot Media, Kernels Hard Drives Partitions fdisk, type 82, type 83 swap partition mkswap, swapon, partition types, partition tables, /boot /home /usr /var file systems, ext2, reiser, ext3, mke2fs inodes, MBR Introduction to the Shell kernle -getty - login -shell /etc/passwd adduser /etc/group Introduction to VI, vim, vi commands: command mode i =insert o =open a =append dd=delete g=goto yy =yank p=paste jklim edit mode type and character into screen esc to go back to command mode execute mode :w write :q quit /search search :wq! at all costs 1,$s/old/new/g == substitution globaly Basic Shell comands ls - directory listing cp - copy mv - move ls ru* - globing cat - cancatonate ps -auxw - see processes pstree - see process tree top - system report Directory tree files, ownership, group permissions Setting up X XF86Setup Knowing your video card Knowing your monitor sysinit - /etc/rc.d/init.d - turning services off and on network setup ipaddress host name domain gateway dns adding users - different on different systems /etc/passwd /etc/shadow ifconfig - see network connections modules - modprobe, demode, lsmod, kernel compile Introduction to unix Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Introduction to Programming with Perl Advanced Unix2 shell scripting, C programming, Desktop X. Introduction to Apache: GNU/Linux 2 Install of mod perl, install of Apache, Install of embperl, and mason, basic apache configuration with files and virtual servers, etc Advanced Web Programming with Perl embperl, modperl, the apache request cycle, cgi's, html, forms, cookies and sessions Database Programming 1 MYSQL installation, Creating tables, performance evalutions, SQL seelcts, Inserts, user permissions, Perl DBI, C API. Introdution to Networking 1 REVIEW tcp/id, introduce mail, sendmail, bind, DNS, DHCP, SAMBA, NFS, SSH, ROUTE -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership Development in Free Software http://www.nyfairuse.org - The foundation of Democracy http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/mp3/dr.mp3 - Imagine my surprise when I saw you... http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-5752 - 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:
Fwd: MYSQL/GNU-Linux CLasses by User Group in NYC [ruben@www2]
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 rest of the corse work Complete program package - perl1, perl2, gnu/linux 1, unix 1, gnu/linux 2, unix 2 Database Programming 1, Introdution to Networking 1 $4000 Perl2 - Object Orientation in Perl · Basic CGI Programming · Database usage and SQL · Building Database Web Applications with DBI · Basic MYSQL administration and SQL · Templating Web Design and Rapid Development with Perl · Introduction to mod_perl · Writing Basic Apache Tuesday at ASHA: 7:00PM - 11:00PM August 6th August 13th August 20th August 27th September 3rd Unix 1 - Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Wednesday at Rozensweig and Maffia 7PM-11:00 August 7th August 14th August 21st Augisyt 28th September 4th Linux 2 - Apache Installation: Download Source Code untar make make install Configure Apache Apache root httpd.conf initiation startup script httpd processes htdocs directory mysql installation Download source untar make install set initial permissions set up initiation file System monitoring tripwire system log monitoring top kill renice/nice last who w netstat route cron/crontab Port scanning/network security nmap inetd.conf tcp wrappersm- hosts.allow hosts.deny simple package forwarding, firewall, ipchains/NAT sshd,encrypted channels, VPN Thusdays - Brooklyn NYLXS Headquarters - 7PM-11:00PM August 8th August 15th August 21st August 28th September 5th Unix 2 - shell scripting, C programming, Desktop X Tuesdays NYLXS Headquarters - Brooklyn August 6th August 13th August 20th August 27th September 3rd -- Total program for reference: Sylibus: Introduction to GNU/Linux Installation Boot Media, Kernels Hard Drives Partitions fdisk, type 82, type 83 swap partition mkswap, swapon, partition types, partition tables, /boot /home /usr /var file systems, ext2, reiser, ext3, mke2fs inodes, MBR Introduction to the Shell kernle -getty - login -shell /etc/passwd adduser /etc/group Introduction to VI, vim, vi commands: command mode i =insert o =open a =append dd=delete g=goto yy =yank p=paste jklim edit mode type and character into screen esc to go back to command mode execute mode :w write :q quit /search search :wq! at all costs 1,$s/old/new/g == substitution globaly Basic Shell comands ls - directory listing cp - copy mv - move ls ru* - globing cat - cancatonate ps -auxw - see processes pstree - see process tree top - system report Directory tree files, ownership, group permissions Setting up X XF86Setup Knowing your video card Knowing your monitor sysinit - /etc/rc.d/init.d - turning services off and on network setup ipaddress host name domain gateway dns adding users - different on different systems /etc/passwd /etc/shadow ifconfig - see network connections modules - modprobe, demode, lsmod, kernel compile Introduction to unix Unix Tool, find, locate, man, grep, AWK, sort, df, ls, gcc, make cp, ln, mv Permissions, tcp networking,route. Introduction to Programming with Perl Advanced Unix2 shell scripting, C programming, Desktop X. Introduction to Apache: GNU/Linux 2 Install of mod perl, install of Apache, Install of embperl, and mason, basic apache configuration with files and virtual servers, etc Advanced Web Programming with Perl embperl, modperl, the apache request cycle, cgi's, html, forms, cookies and sessions Database Programming 1 MYSQL installation, Creating tables, performance evalutions, SQL seelcts, Inserts, user permissions, Perl DBI, C API. Introdution to Networking 1 REVIEW tcp/id, introduce mail, sendmail, bind, DNS, DHCP, SAMBA, NFS, SSH, ROUTE -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership Development in Free Software http://www.nyfairuse.org - The foundation of Democracy http://www2.mrbrklyn.com/resources - Unpublished Archive or stories and articles from around the net http://www2.mrbrklyn.com/mp3/dr.mp3 - Imagine my surprise when I saw you... http://www2.mrbrklyn.com/downtown.html - See the New Downtown Brooklyn 1-718-382-5752 -- __ Brooklyn Linux Solutions __ http://www.mrbrklyn.com - Consulting http://www.nylxs.com/radio - Free Software Radio Show and Archives http://www.brooklynonline.com - For the love of Brooklyn http://www.nylxs.com - Leadership
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 -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..?
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..?
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
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, 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 where the --log was specified, perhaps it was compiled in? I only have a binary distribution of mysql. Is there some way to override the --log? I have looked at section 4.9 of the mysql manual and /etc/my.cnf (see below) and these scripts /etc/rc.d/rc[0-6].d/K12mysqld /etc/rc.d/init.d/mysqld /usr/share/mysql/mysql.server Does anyone know which of these scripts is really the one that starts safe_mysql? (note that the err-log setting in my.cnf refers to an error log (empty on my machine) not the query log that I am trying to get rid of. -thanks Tom $ ps -ax |grep mysql 6010 ?S 0:00 /bin/sh /usr/bin/safe_mysqld --log 6036 ?S 0:45 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib # uname -a Linux {mydomain.com} 2.4.9-13 #1 Tue Oct 30 20:11:04 EST 2001 i686 unknown # mysqladmin --version mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 # cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid _ 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: how to turn off query logging in mysql, redhat linux
it was started when machine was started check /etc/rc.d and in mysql manual 2.1.1 if u don't need it now, just stop the server and start it like ./bin/safe_mysqld but u have to modify rc.d anyway for next time your server start dont log anymore. Borus - Original Message - ±H¥óªÌ: Tom 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, 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 where the --log was specified, perhaps it was compiled in? I only have a binary distribution of mysql. Is there some way to override the --log? I have looked at section 4.9 of the mysql manual and /etc/my.cnf (see below) and these scripts /etc/rc.d/rc[0-6].d/K12mysqld /etc/rc.d/init.d/mysqld /usr/share/mysql/mysql.server Does anyone know which of these scripts is really the one that starts safe_mysql? (note that the err-log setting in my.cnf refers to an error log (empty on my machine) not the query log that I am trying to get rid of. -thanks Tom $ ps -ax |grep mysql 6010 ?S 0:00 /bin/sh /usr/bin/safe_mysqld --log 6036 ?S 0:45 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib # uname -a Linux {mydomain.com} 2.4.9-13 #1 Tue Oct 30 20:11:04 EST 2001 i686 unknown # mysqladmin --version mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 # cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid _ 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
Installing mysql on Linux
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: Installing mysql on Linux
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
Re: Installing mysql on Linux
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