Re: (off topic) why PATH

2012-01-04 Thread Jan Steinman
From: Reindl Harald h.rei...@thelounge.net however: both chroot and virtualization has nothing to do with this whole topic, really nothing But that shouldn't keep someone from going off on an anti-Mac rant, no? :-) The OP was on a Mac, and it really doesn't help to tell them they have the

Re: (off topic) why PATH

2012-01-04 Thread Reindl Harald
Am 05.01.2012 00:52, schrieb Jan Steinman: From: Reindl Harald h.rei...@thelounge.net however: both chroot and virtualization has nothing to do with this whole topic, really nothing But that shouldn't keep someone from going off on an anti-Mac rant, no? :-) The OP was on a Mac, and it

Re: (off topic) why PATH

2012-01-01 Thread Hal�sz S�ndor
2011/12/29 19:35 +0100, Reindl Harald for the hadnful things on my linux-machines where such non-default locations are existing i usually set symlinks unter /usr/local/bin/ to the binarys, so they are seperated and from the user point of view in the PATh and all wroks fine The weakness of PATH

Re: (off topic) why PATH

2012-01-01 Thread Reindl Harald
in the PATh and all wroks fine The weakness of PATH: it is all right in the original Unix case, many, many little programs in few directories. Quite a few programs come with MySQL; therefore, it pays to put the MySQL directory in PATH--but Lynx, and many text-processors, comes with one program

Re: (off topic) why PATH

2012-01-01 Thread Claudio Nanni
my 0,02 I think I used standard path only the first installation of MySQL in 2002, after that I always I had my custom way of installing it which lead me to be able to have *any* number of instances of any independent version. After some years I saw Giuseppe Maxia's Sandbox which is a nice

Re: (off topic) why PATH

2012-01-01 Thread Reindl Harald
Am 01.01.2012 16:52, schrieb Claudio Nanni: I think today is really out of date prove this! today you need to tune and twist the system at your needs to get the best out of it so what, on a modern linux you can tweak much more you wold ever be able on a Mac AND it is much faster without

Re: (off topic) why PATH

2012-01-01 Thread Johan De Meersman
Reinventing chroots, then? Welcome to 2012, when everything has been done before :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: (off topic) why PATH

2012-01-01 Thread Claudio Nanni
yeah... I also don't understand why all these guys are bothering with virtualization just use chroot welcome to stone age if you think that everything has been done before ;) 2012/1/1 Johan De Meersman vegiv...@tuxera.be: Reinventing chroots, then? Welcome to 2012, when everything has

Re: (off topic) why PATH

2012-01-01 Thread Reindl Harald
chroot has it's place but if you don't understand this days what virtualization is used for hopefully your job has nothing to do with IT Am 01.01.2012 22:12, schrieb Claudio Nanni: yeah... I also don't understand why all these guys are bothering with virtualization just use chroot

Re: (off topic) why PATH

2012-01-01 Thread Claudio Nanni
I am a bread baker, you can relax. we are definitely going off-topic. Cheers Claudio PS: it was a joke but with a solid base: http://kae.li/iiigr 2012/1/1 Reindl Harald h.rei...@thelounge.net: chroot has it's place but if you don't understand this days what virtualization is used for

Re: (off topic) why PATH

2012-01-01 Thread Reindl Harald
Am 01.01.2012 21:18, schrieb Johan De Meersman: Reinventing chroots, then? Welcome to 2012, when everything has been done before :-) what has the phrase chroot exactly to do with this topic? signature.asc Description: OpenPGP digital signature

Re: (off topic) why PATH

2012-01-01 Thread Reindl Harald
these are totally different things get a look at a VMware HA-cluster and after that tell us again that chroot has anything common however: both chroot and virtualization has nothing to do with this whole topic, really nothing Am 01.01.2012 22:33, schrieb Claudio Nanni: I am a bread baker, you

Global world-wide announcement: H2 Database (java) is coming down... your path ....

2010-01-09 Thread Al_Dev
Global world-wide announcement: H2 Database (java) is coming down... your path All the database developers jump into H2 database ... Great databases like PostgreSQL, MySQL, FireBird are getting better everyday... But take a look at the upcoming H2 which is written completely in Java

Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Hey there I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 Master + Slave Replication server, with InnoDB tables only, over a new hardware. Unfortunately, this is the first time I play a role as MySQL DBA,

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi Luis, On Jan 2, 2008 8:53 AM, Luis Motta Campos [EMAIL PROTECTED] wrote: Hey there I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 Master + Slave Replication server, with InnoDB tables only, over a

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and using replication. It looks like you have planned well for all but using replication. That's interesting. What kind of activities (besides configuration,

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi, On Jan 2, 2008 10:04 AM, Luis Motta Campos [EMAIL PROTECTED] wrote: Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and using replication. It looks like you have planned well for all but using

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Baron Schwartz wrote: On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and using replication. It looks like you have planned well for all but using

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi Luis, On Jan 2, 2008 11:12 AM, Luis Motta Campos [EMAIL PROTECTED] wrote: Baron Schwartz wrote: On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: Baron Schwartz wrote: What are the biggest changes you anticipate? I'd say they will be the version upgrade, converting to InnoDB, and

Re: Database Migration Path / Activity List?

2008-01-02 Thread Moon's Father
I know now how to reply to all mail list On Jan 2, 2008 9:53 PM, Luis Motta Campos [EMAIL PROTECTED] wrote: Hey there I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 Master + Slave Replication

RE: mysql-server-5.1.19 path variable error set on compile

2007-06-18 Thread Geoffroy Cogniaux
Hi, Set this variable at command line or in your my.cnf. Geoffroy. -Message d'origine- De : David Southwell [mailto:[EMAIL PROTECTED] Envoyé : dimanche 17 juin 2007 17:33 À : mysql@lists.mysql.com Objet : mysql-server-5.1.19 path variable error set on compile # uname -a 6.1-RELEASE

mysql-server-5.1.19 path variable error set on compile

2007-06-17 Thread David Southwell
# uname -a 6.1-RELEASE FreeBSD 6.1-RELEASE #0: Sun May 7 04:15:57 UTC 2006 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/SMP amd64 # Just upgraded mysql to include: # pkg_info |grep mysql mysql-client-5.1.19 Multithreaded SQL database (client) mysql-server-5.1.19 Multithreaded SQL database

Path information to a database

2007-05-11 Thread Brian E Boothe
--Drawings --Labels I need to store all this relavent Path Information into a MySQL database, so i can Link it all into the database instead of using fileshares , has anyone done this before?? on Paths and Storeing into a database anyone have

Re: Path information to a database

2007-05-11 Thread Mike Lockhart
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian, There are several ways you could store this information, either complete paths, or relative paths, something along these lines: Tables: - --- Projcts: ++ | PROJ_ID | PATH

Path information into database

2007-05-11 Thread Brian E Boothe
so how would i get the Actual file path to the folder into the database, i know ill have to use a file selector in asp / php but i wanna select the folder not the Files, it would be really great if u could help me with these issues, i'm not asking u to Code anything for me , just links

Re: Path information into database

2007-05-11 Thread JamesDR
Brian E Boothe wrote: so how would i get the Actual file path to the folder into the database, i know ill have to use a file selector in asp / php but i wanna select the folder not the Files, it would be really great if u could help me with these issues, i'm not asking u to Code anything

path Stored in MySQL

2006-12-15 Thread Brian E Boothe
Can someone help me with getting a path stored in MySQL, Links ? Snips would be great thanks a lot -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.20/588 - Release Date: 12/15/2006

howto show query process path? (indexes related)

2006-01-06 Thread Patrizio Bassi
Hi, for a database project i need to know how indexes impact on query usage. the explain command gives me only infos if index is used or not...and some other infos. i need to know the file access plan. i mean: access the index - find the value - access the file page something like a strace

directory path storage

2005-10-11 Thread Brian Boothe
Can someone pelase explain to me how to store the pathname and the filename in a MySQL database , I need it to loop thru a Folder and grab all pathnames and filesnames within that folder and store it in a MySQL database,, thanks

Re: LOAD DATA INFILE - what is the path to file?

2005-06-08 Thread Michael Stassen
Chris wrote: Thank you for your detailed response. You're welcome. It seems my problem is trying to define the path to my data file and this is where I seem to be missing something. No, the problem is permissions. As I explained previously, a relative path (one without a leading

Re: LOAD DATA INFILE - what is the path to file?

2005-06-06 Thread Chris
Thank you for your detailed response. It seems my problem is trying to define the path to my data file and this is where I seem to be missing something. Permissions on all directories in the path are by default set to 755 except for the director at the top of the directories in my hosting account

LOAD DATA INFILE - what is the path to file?

2005-06-05 Thread Chris
BY '' LINES TERMINATED BY '\r\n' I now want to load data using LOAD DATA INFILE from a data file located within my http_public directory. I can create a path to the file from my DOCUMENT_ROOT, however passing that path to LOAD DATA INFILE generates this error: (NOTE: I set the file permissions to 777

Re: LOAD DATA INFILE - what is the path to file?

2005-06-05 Thread mfatene
create a path to the file from my DOCUMENT_ROOT, however passing that path to LOAD DATA INFILE generates this error: (NOTE: I set the file permissions to 777) Can't get stat of '/home/path_to_my_file/datafile.txt' (Errcode: 13) Now if I just create a query like: LOAD DATA INFILE 'datafile.txt

Re: LOAD DATA INFILE - what is the path to file?

2005-06-05 Thread Michael Stassen
BY ',' ENCLOSED BY '' LINES TERMINATED BY '\r\n' I now want to load data using LOAD DATA INFILE from a data file located within my http_public directory. I can create a path to the file from my DOCUMENT_ROOT, however passing that path to LOAD DATA INFILE generates this error: (NOTE: I set the file

Re: MySQL inadvertently messing with the path in the Windows' registry?

2004-12-23 Thread Jeff Smelser
On Wednesday 22 December 2004 09:28 pm, Ney André de Mello Zunino wrote: I have just obtained that conclusive evidence. The MySQL installer is indeed messing up the type of the /Path/ value on the registry, changing it from REG_EXPAND_SZ to REG_SZ. The problem will only take place when you

Re: MySQL inadvertently messing with the path in the Windows' registry?

2004-12-23 Thread Ney André de Mello Zunino
Jeff Smelser wrote: Do the developers read these messages as well? If not, where should I report the problem? bugs.mysql.com.. Thanks. I already posted a bug report. FWIW, here is the bug tracking URL: http://bugs.mysql.com/bug.php?id=7510. Regards, -- Ney André de Mello Zunino -- MySQL General

MySQL inadvertently messing with the path in the Windows' registry?

2004-12-22 Thread Ney André de Mello Zunino
Hello. After installing the latest GA (Generally Available) version, 4.1.8, of the MySQL Server [1] on my Windows XP SP2 system, I noticed something strange with the PATH environment variable. Upon opening a command prompt window, I could not directly execute any of the usual applications

Re: MySQL inadvertently messing with the path in the Windows' registry?

2004-12-22 Thread Ney André de Mello Zunino
Ney André de Mello Zunino wrote: I will post again, if I find any conclusive evidence. I have just obtained that conclusive evidence. The MySQL installer is indeed messing up the type of the /Path/ value on the registry, changing it from REG_EXPAND_SZ to REG_SZ. The problem will only take place

Re: Best learning path to DBA?

2004-12-03 Thread Gleb Paharenko
/ unofficial network administrator with a well-rounded technical background - but, as they say, a jack of all trades (expert in nothing). If I were to pursue a DBA path, what would be a good way of going about it? School, books, etc... - Eve -- For technical support contracts, goto https

Best learning path to DBA?

2004-12-02 Thread Eve Atley
I am an web designer / php programmer / unofficial network administrator with a well-rounded technical background - but, as they say, a jack of all trades (expert in nothing). If I were to pursue a DBA path, what would be a good way of going about it? School, books, etc... - Eve -- MySQL

ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread Brian J.S. Miller
). Here is what I have tried already: 1) backing down to Mysql 3.23 2) Running 2.6 kernel (read that ISAMs aren't binary compatible across OS/platform) 3) CHECK TABLE admin_privs (says: Incorrect information in file: './path/admin_privs.frm') 4) isamchk (says: isamchk: error: 'admin_privs

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread kernel
is..that's just 1 exaple). Here is what I have tried already: 1) backing down to Mysql 3.23 2) Running 2.6 kernel (read that ISAMs aren't binary compatible across OS/platform) 3) CHECK TABLE admin_privs (says: Incorrect information in file: './path/admin_privs.frm') 4) isamchk (says: isamchk: error

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread Brian J.S. Miller
is..that's just 1 exaple). Here is what I have tried already: 1) backing down to Mysql 3.23 2) Running 2.6 kernel (read that ISAMs aren't binary compatible across OS/platform) 3) CHECK TABLE admin_privs (says: Incorrect information in file: './path/admin_privs.frm') 4) isamchk (says: isamchk

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread kernel
' (or whatever the table name is..that's just 1 exaple). Here is what I have tried already: 1) backing down to Mysql 3.23 2) Running 2.6 kernel (read that ISAMs aren't binary compatible across OS/platform) 3) CHECK TABLE admin_privs (says: Incorrect information in file: './path/admin_privs.frm') 4) isamchk

Re: ISAM corruption: Error 1033: Incorrect information in file '/path/x.frm'

2004-09-24 Thread Brian J.S. Miller
Brian J.S. Miller wrote: Walt, The tables are ISAM type. These are some seriously old tables (originally from version 3.21) and were never updated to type MyISAM. Despite frequent updates to mysqld. There is a program isamchk which is similar to myisamchk, but it returns the error ___ is

Set path variable on Windows 2000

2004-05-11 Thread MightyData
What is the correct syntax to set the path variable on Windows 2000 so I can type mysql instead of c:\mysql\bin at the command prompt? - Kirk Bowman Phone: 972-390-8600 MightyData

RE: Set path variable on Windows 2000

2004-05-11 Thread Victor Pendleton
Globally: Add c:\mysql\bin to path in the environment variables under the My computer -- properties window Session: set path=%path%;c:\mysql\bin -Original Message- From: MightyData To: MySQL Sent: 5/11/04 1:50 PM Subject: Set path variable on Windows 2000 What is the correct syntax

installed path with RPM

2004-04-02 Thread sunfei
Hi : I install mysql My-SQL-server-4.0.18-0.i386.rpm in my RedHat 7.3 with following cmd : rpm -iv My-SQL-server-4.0.18-0.i386.rpm, But I can not find the path mySQL installed . Where is it ?

path for my.cnf with dual mySQL installations

2004-02-12 Thread Jonas Lindén
Hello, I have been fiddeling with MySQL5 alpha for a little testing sessions but I kept my MySQL4 installation. The problem is that I cant set the path for my my.cnf file for MySQL5. I can use my.cnf if I put in /etc but then it conflicts with my other MySQL installation. Does anyone have a tip

Re: path for my.cnf with dual mySQL installations

2004-02-12 Thread Egor Egorov
Jonas Lind?n [EMAIL PROTECTED] wrote: Hello, I have been fiddeling with MySQL5 alpha for a little testing sessions but I kept my MySQL4 installation. The problem is that I cant set the path for my my.cnf file for MySQL5. I can use my.cnf if I put in /etc but then it conflicts with my

Re: data path

2003-06-11 Thread Victoria Reznichenko
unplug [EMAIL PROTECTED] wrote: By default, data dir is located at /var/lib/mysql. I have run mysql for serveral month with data in that path. Now, I want to move all database data to another path, say /var2/lib/mysql. What is the suitable purpose to do it? Is it only shutdown mysql

data path

2003-06-10 Thread unplug
Hi all, By default, data dir is located at /var/lib/mysql. I have run mysql for serveral month with data in that path. Now, I want to move all database data to another path, say /var2/lib/mysql. What is the suitable purpose to do it? Is it only shutdown mysql and move all data file from

Re: unworking directive --with-unix-socket-path=/

2003-03-23 Thread Andreas
Slawomir Orlowski schrieb: I could connect with new /usr/local/mysql/bin/mysql client (old one was not working) and select data from moved databases. problem is that web pages are not working any more, The old one doesn't find the socket. I did and it worked, but I do not know what to do in

Changing the library path in libsqlplus.la

2003-03-13 Thread Markus Gerwinski
Hello, when linking to libsqlplus from an own project, I found that it was looking for libmysqlclient.la in /usr/lib (instead of /usr/local/lib, where it is really installed). As it seems, this path to libmysqlclient is taken from the libsqlplus.la, where it is put down hard-coded

unworking directive --with-unix-socket-path=/

2003-03-12 Thread Slawomir Orlowski
with mysql.socket which was in old version in /var/lib/mysql now in /tmp so ./configure --prefix=/usr/local/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock make;make install etc. should produce mysql with socket in /var/lib/mysql dictionary instead of /tmp but once again I have got socket

Re: unworking directive --with-unix-socket-path=/

2003-03-12 Thread Paul DuBois
: bacause I have problem with mysql.socket which was in old version in /var/lib/mysql now in /tmp so ./configure --prefix=/usr/local/mysql \ --with-unix-socket-path=/var/lib/mysql/mysql.sock make;make install etc. should produce mysql with socket in /var/lib/mysql dictionary instead

Mac OS X and database path

2003-03-01 Thread Bernardo Zuniga
Hello, I'm a bit confused about where the database is located in Mac OS X. I was following the instructions in O'Reilly's boot using and Managing MySQL ad got to the point where I tried to do a select and output to a file. The command I ran was as follows: SELECT * INTO OUTFILE 'books.dat'

Re: Mac OS X and database path

2003-03-01 Thread Paul DuBois
At 19:46 -0500 3/1/03, Bernardo Zuniga wrote: Hello, I'm a bit confused about where the database is located in Mac OS X. I was following the instructions in O'Reilly's boot using and Managing MySQL ad got to the point where I tried to do a select and output to a file. The command I ran was as

Re: Mac OS X and database path

2003-03-01 Thread Bernardo Zuniga
Thank you Paul, That helped to clear things up. My guess was that the book was wrong and the path was different for OS X. The command worked fine, but apparently the files were never created for some reason. I will try this again. thanks for your help, Bernardo On Saturday, March 1, 2003

Re: Mac OS X and database path

2003-03-01 Thread Paul DuBois
At 21:38 -0500 3/1/03, Bernardo Zuniga wrote: Thank you Paul, That helped to clear things up. My guess was that the book was wrong and the path was different for OS X. The command worked fine, but apparently the files were never created for some reason. I will try this again. Well, the book

Re: Mac OS X and database path

2003-03-01 Thread Bernardo Zuniga
There were no errors and it listed a number of rows affected and a time. tried the command again and it said that the file already existed. The problem was the directory path that I was looking in. I couldn't see it in the GUI but in the terminal a find pointed me to the file. I wasn't able

Re: Configure prob with FreeBSD/Linuxthreads -- path to linuxthreads includes?

2003-02-02 Thread Eric Frazier
Hi, One other problem came up, the configure script looks for LinuxThreads in /usr/include where of course FreeBSD stores them in /usr/local/include/linuxthreads so the flag that gets set for linuxthreads doesn't, at least not in my version of mysql 4.09 Thanks, Eric (250) 655 - 9513 (PST

Re: Database in path to foreign key references

2002-10-25 Thread Heikki Tuuri
Christian, - Original Message - From: Christian Lizell [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, October 24, 2002 6:18 PM Subject: Database in path to foreign key references Hello! Is there any way to get rid of the database name in the path

Database in path to foreign key references

2002-10-24 Thread Christian Lizell
Hello! Is there any way to get rid of the database name in the path to the reference of a foreign key. When using mysqldump to copy a database the name of the source database is in the path of the foreign key reference. In my case, that is not what I want. An example: mysql use

InnoDb data file path

2002-10-09 Thread Scott Pippin
I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL 4.0.4

Re: InnoDb data file path

2002-10-09 Thread walt
Scott Pippin wrote: I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL 4.0.4

Re: InnoDb data file path

2002-10-09 Thread Arjen Lentz
Hi Scott, On Thu, 2002-10-10 at 03:28, Scott Pippin wrote: I am trying to set up two data files in case the first one fills up. I tried to use the following in my.cnf but it says there is an error. If I take out the reference to the second data file everything works AIX 4.3.3 MySQL

Re: Set Path Environment

2002-09-25 Thread Leonardo Javier Belén
Try to modify the autoexec.bat if you are using Win9x or the Path User env in Winnt. Another choice in some systems is to modify DOSTART.bat or something like that in \windows. A way to keep the previous setting of the PATH env is to issue a stat like SET PATH=%PATH%;c:\mysql; ... I hope

Re: Set Path Environment

2002-09-25 Thread John R. Diehl, Jr.
Under NT and XP you set the environment variables by clicking on the My Computer icon and selecting Properties, then clicking the Environment variables on the Advanced tab. Make sure you set the PATH under the System Variables instead of User Variables if you want MySQL to be available

Re: Set Path Environment

2002-09-25 Thread Iikka Meriläinen
-Properties... as I noted in an earlier message. After thinking this a bit, it'd be very nice if the MySQL setup program offered an option to automatically add mysql\bin to the PATH environment variable (whoever is responsible of the setup, please consider this!) on Windows. Best regards, Iikka

Re: Set Path Environment

2002-09-25 Thread kayamboo
Why not you set the path in your environment variables and restart the computer Are you using win98 or NT? - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:33 AM Subject: Set Path Environment

Re: Wrong path for temp file

2002-09-25 Thread MySQL
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) From: [EMAIL PROTECTED] Date: Mon, 23 Sep 2002 11:57:19 -0800 (AKDT) News-Group: list.mysql Reply-To: [EMAIL PROTECTED] Description: While trying to run this query: SELECT users_1.* FROM users

Set Path Environment

2002-09-25 Thread William Martell
Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open

Fw: Set Path Environment

2002-09-25 Thread William Martell
This is more information regarding the Path for my machine. It shows the default PATH information and the PATH information after I perform the SET PATH command. It also shows how MySQL responds after I type MySQL at the command prompt. Thanks in Advance, William C:\path PATH=C:\WINNT

Re: Set Path Environment

2002-09-25 Thread Iikka Meriläinen
or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have

Wrong path for temp file

2002-09-23 Thread isd
Description: While trying to run this query: SELECT users_1.* FROM users AS users_1, users AS users_2 WHERE users_1.email_address = users_2.email_address AND users_1.id users_2.id ORDER BY users_1.email_address I got this error: Can't create/write to file '/root/tmp/#sql107d_bdf_2.MYI'

Re: How to overwrite the /var/lib/mysql path during installation?

2002-09-18 Thread Vlatko Surlan
didnt get any help here either so I downgraded to 3.23.xx. Compilation went fine when I turned off InnoDB. The gig is that when compiling from source there is a --prefix=/path/to/installation_dir option to configure script. I guess you allready got that this makes mysql installation script put all

RE: Start mysqld-nt from command line with SPACES in the path, how?

2002-09-18 Thread Tobias Eriksson
in the path, how? Tobias, Monday, September 16, 2002, 2:33:10 PM, you wrote: TE I am trying to start up the database, mysql, on a windows machine. TE I installed it into a dir under c:\Program Files\ComOpt\CellOpt TE AFP\database\. As you can see there are SPACEs here, if I am using TE the config

How to overwrite the /var/lib/mysql path during installation?

2002-09-17 Thread Tam,Aaron
I'm installing the mysql-max-3.23.52-pc-linux-gnu-i686 version. But I don't have the root permission, and don't have the /var/lib/ access permission. And I got the following error when I ran the ./configure commend. Do anyone know how to change the /var/lib/mysql directory to something else?

File path

2002-08-12 Thread Alexander Burbello
Hi all, How can I change the file paht c:\windows\my.ini. Is possible I have two files because I want to start two instances in same machine. I would like to change like that: - c:\windows\my.ini - c:\windows\my2.ini Regards Alexander sql, query

Re: File path

2002-08-12 Thread Iikka Meriläinen
Hello Alexander, Yes, it is possible. Start your mysqld(-max)(-nt) instances with --defaults-file=C:\windows\my.ini option and it should work. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland

Database path

2002-02-28 Thread Ernesto A. Zapata Icart
Friends: How I can change the place where they are create the database? Different place than \mysql\data\mybase thanks Ernesto - Before posting, please

Database path

2002-02-28 Thread Victoria Reznichenko
Ernesto, Thursday, February 28, 2002, 6:06:53 PM, you wrote: EAZI Friends: EAZI How I can change the place where they are create the database? EAZI Different place than \mysql\data\mybase You should change default directories by editing my.cnf: [mysqld] datadir=path_to_your_dir or you

RE: Path Variables

2002-01-11 Thread Gary . Every
What operating system are you using? The path vars etc are found in your mysqld_safe or safe_mysqld script, at least in *NIX systems -Original Message- From: Roman Eisner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 6:06 PM To: [EMAIL PROTECTED] Subject: Path Variables

Path Variables

2002-01-10 Thread Roman Eisner
Hello, I'm trying to change the path variables of an already installed mysql server. Namely, I want to change: pid_file language innodb_log_group_home_dir datadir basedir I viewed these, using the mysqladmin variables command. I'm using 4.0, and I'd like to know the easiest way to change

How do I add to PATH?

2001-11-16 Thread Jennifer Slis
This is a remedial question, but I am trying to get myisamchk to run from the database directory. All I keep hearing is put it in your path and you can run it from anywhere (as opposed to having to be in the bin directory to execute it). I have searched the web, but haven't found a simple

RE: Bad path to ibpthread.so.14.20?

2001-08-09 Thread Adam Douglas
Alright, but what if I do not have a ld.so.conf file? Do I just create one in /etc/? -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 8:26 AM To: Adam Douglas Cc: Mysql@Lists. Mysql. Com (E-mail) Subject: Re: Bad path to ibpthread.so

Re: Bad path to ibpthread.so.14.20?

2001-08-08 Thread Gerald Clark
1. Add the path to /etc/ld.so.conf 2. Run ldconfig Adam Douglas wrote: I'm installed MySQL 3.23.37 and I can't get it started. I know there has be number of posts regarding such a problem but I haven't seen a resolution to fix mine specificly. I get this error when I try and load mysqld

Bad path to ibpthread.so.14.20?

2001-08-07 Thread Adam Douglas
or directory Starting mysqld daemon with databases from /var/mysql 010807 15:42:38 mysqld ended Now I know the file is located at /usr/local/lib/pth/libpthread.so.14.20 but where is the location for me to fix this bad path? Funny thing is I had MySQL Daemon running just fine but when I did a reboot I

Re: How to change path to /etc/my.cnf (or ignore it)

2001-08-01 Thread Grigory Bakunov
either), even though the configured Makefile has PS MYSQL_TCP_PORT=3307 in it. PS But the --with-unix-socket-path=/customer/tmp/mysql.sock argument is PS respected and works. for example try to use /usr/bin/safe_mysqld --defaults-file=/etc/my2.cnf

How to change path to /etc/my.cnf (or ignore it)

2001-07-31 Thread Paul Southworth
. Additionally, if I configure --with-tcp-port=3307 that is also ignored and the server listens on 3306 (no, it's not inheriting that info from safe_mysqld or my.cnf either), even though the configured Makefile has MYSQL_TCP_PORT=3307 in it. But the --with-unix-socket-path=/customer/tmp/mysql.sock

PATH

2001-04-25 Thread Simon Chan
client programs and the server You should add the full pathname of this directory to your PATH environment variable so that your shell finds the MySQL programs properly. Question: How do I add the full path name to my PATH environment variable? The url provided was of much help. Many thanks

Re: PATH

2001-04-25 Thread Steve Brazill
I find it humorous that you're Email address is perl_programmer2001, yet you don't know how to set your PATH variable... Type echo $PATH and see if /usr/local/bin is included in it. If so, you can do what I usually do, which is to add 'symbolic links' from there to programs that I want

How to change the lib path ...

2001-03-02 Thread Didier Desmet (RSCA)
Hi guys, I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb for /var and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld, mysql_config

How to change the lib path ...

2001-03-02 Thread Didier Desmet (RSCA)
Hi guys, I just have a problem since yesterday, RedHat 7.0 make standard a partition of 256 mb for /var and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld

Re: How to change the lib path ...

2001-03-02 Thread Seung-woo Nam
and mysql database are to big for this (so it crashes). Can someone tell me how to change the /var/lib/mysql path to /home/lib/mysql. I changed every file to this path (mysqld, mysql_config, ...) but nothing append. Thx for help,

Re: How to change the lib path ...

2001-03-02 Thread Didier Desmet (RSCA)
No there is /etc/my.conf but this file is empty ? - Original Message - From: Seung-woo Nam [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 10:04 AM Subject: Re: How to change the lib path ... Hi The config file you are looking for is /etc/my.cnf, I believe

Re: nested sets vs. key path method

2001-02-13 Thread Bob Hall
.right AND E1.emp = :myworker; but now I wonder if it wouldn't be better to use the so called "key path method" where you put the whole top hierarchy info of a node into one column like: root/parent1/parent23/parent40/... and so on. Did someone make experience with one of this metho