Re: Problem with data import from text file (part two)

I have also read the manual section on this {as I should have done] to try and understand it and how to enable reading a local file - the discussion section seems confusing and confused. I tried following what others have done and modified the ini file with set-variable=local-infile=0 and with

RE: mysql LOAD DATA INFILE

It's just a standard text file; here is a piece of it: 70321;451 70050;451 70322;451 70323;451 70051;451 67026;451 70053;451 67420;451 67419;451 70451;451 70452;451 67820;451 72080;451 72081;451 72082;451 72083;451 20148;452 39761;452 20147;452 20112;452 Just lines like this: a little over

MySql Replication through a tunnel.

Hello All, How will i setup Mysql Replication btween two redhat 7.3/9.0 boxes. I want the replication to happen through a Secure tunnel between these two. I am following the steps that is given on the offcial Mysql website. Just wants to know if there is any easy howto to set this up using a

FROM_DAYS doesn't take timestamp?

Hi, I'm using v 3.23.46-nt and the C API. The manual says under 'Changes in release 3.20.17' that: Change FROM_DAYS() and WEEKDAY() to also take a full TIMESTAMP or DATETIME as argument. Before they only took a number of type MMDD or YYMMDD. I'm confused since this doesn't seem to be the

RE: mysql LOAD DATA INFILE

That is messy, but you are right. I have FTP access and such - that's why I was wondering that with the new version of MySQL out, is this a change in MySQL? Or can the people who do have command line access re-compile it or something to give me permission to do what I need to do? Thanks,

Subject: Re: Problem with data import from text file (part two) Thanks

Thanks for the advice - and your patience in giving it to me. The recommended changes in the ini file worked (but only along with removing the word local from the load data local infile instruction) [since I have a localhost Apache server as testing environment] thanks again to those more

Re: myisamchk Illegal Instruction

Paul Mahon [EMAIL PROTECTED] wrote: Hello, I recently managed to corrupt a table pretty badly. I read the sections in the documentation about recovering after a crash. None of the methods worked. All give output similar to the following: % bin/myisamchk -t ~/tmp -f -o BROKE/EventsBROKE -

Re: Running two Servers?

Hi Why would you need two servers running when you could just have separate databases?? Is there a reason why these two cannot share?? Mike - Original Message - From: Ola Ogunneye [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: August 7, 2003 8:46 AM Subject: Running two Servers?

Re: mysql installation problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 6 Aug 2003, Anil Garg wrote: I am trying to install myql on redhat. Red Hat Linux? mysql package used: mysql-3.23.52-unknown-freebsdelf4.6-i386.tar.gz This is the wrong package - this one is for FreeBSD! Please use the Linux

Re: MySql Control Center

In Windows MySQLCC open a query window; select query menu; query window options; query options tab; set SQL_BIG_SELECTS=1. http://www.mysql.com/doc/en/SET_OPTION.html Quote: SQL_BIG_SELECTS = 0 | 1 If set to 0, MySQL will abort if a SELECT is attempted that probably will take a very long time.

win200 - lost root privilege - cannot shutdown - need help

I am working on a Windows 2000 server. The version 4.0.13 was installed at the end of June because we are looking at using MySQL. Me and the other guy are novice with MySQL. I read the different emails about access and granting and password and flushing privilege from other people who couldn't

Re: replication problem

So does anyone else have any ideas what is going on here? Shall I report this as a bug? On Wed, Aug 06, 2003 at 02:19:21PM +0100, Andy Smith wrote: Hi folks, trying to set up replication and I'm getting this problem which I can't see how to fix despite reading of the manual and google. I

MySql Control Center

Hi, I am new to using the Control Center-0.9.2-beta. My problem is that I cannot seem to display more than 1000 rows in my result set when I know that there is 1534 rows. I know that it is a setting somewhere, but is it in MySql or in the Control Center somewhere. I am running this on a

RE: select count(*) Problem in PowerBuilder Thru MySQL ODBC 3.51

Yes, found the problem, you are right. Thanks. But this is something caused by powerbuilder, in my code I never put any space between count(*), but when it goes to odbc, an space is added. Any idea how to solve this? -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent:

arbitrary ordering

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I have a few tables something like create table SURVEY ( SID int primary key not null auto_increment, SNAME varchar(20), QUESTION_ORDER varchar(20) ) ; create table SURVEY_QUESTION ( QID int primary key not null

Dirk Kunischewski/UK/IBM is out of the office.

I will be out of the office starting October 11, 2002 and will not return until November 4, 2010. Please contact Gerry McNamee ([EMAIL PROTECTED]) or Aurelien Thouard ([EMAIL PROTECTED]) since I left IBM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Updating table based upon matching field in second table

On Fri, 2003-08-08 at 21:14, Matthew McNicol wrote: I have a database of books that was originally created as a flat file. Each record has a number of fields, including the authors name. I'm trying to convert the database to something a little more efficient. I've created a new table

Re: Remote access for mysql what variable is needed to be set

Jatin, I am running mysql 4 on linux server. I want to have a remote access on it. what are the setting that i need to do this. You need to log into your MySQL server and grant access to your databases from wherever you want to grant access, like: mysql GRANT ALL ON *.* TO 'remoteuser'@'%'

database per user

hi, it's possible in mysql set the db folder into home user? example: user fred, home is /home/fred i want store db data in /home/fred/db. it's possible? i've tested in /home/fred/.my.cnf this: datadir=/$HOME/db but don't function i expose the /etc/my.cnf and /home/fred/.my.cnf for more

Date Calculation

Hi List I have two datetime fields on my database. I nedd to return the difference in minutes between them. I tried date_sub, extract(hour_minute from ...) and it does't work Any help will be very apreciated. Thanks Oswaldo Castro -- MySQL General Mailing List For list archives:

MySQL Crash when using default-character-set tis620 (Thai sort order)

Description: When i using default-character-set tis620 (Thai sort order) mysql server has been crash and then I test to use latin1 can work fine but can't sort order in thai language. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:apples Organization:

Re: IP Addresses MySQL Listens On

Jim McAtee wrote: Quick question or two regarding the IP addresses MySQL listens on: Does MySQL automatically listen on all IP addresses bound to the machine on which it runs? (MySQL 3.23.xx on Windows 2000). I've got a multi-homed server with dual NICs. To date I've always connected from

IP Addresses MySQL Listens On

Quick question or two regarding the IP addresses MySQL listens on: Does MySQL automatically listen on all IP addresses bound to the machine on which it runs? (MySQL 3.23.xx on Windows 2000). I've got a multi-homed server with dual NICs. To date I've always connected from other servers on an IP

Re: Can't connect to local MySQL question

Bill Hernandez wrote: I followed the install instructions at http://entropy.ch , and was able to get mySql php installed on my G4 - (OSX 10.2.6) last night. I downloaded Navicat and setup a password for the mysql user. I created a connection called myDatabase_connection to a database called

read_const error 127 - then MySQL dies

Hi all, The following keeps happening and I can't pinpoint a query that is causing it. It did not happen in 3.23.x, but started upon upgrading to 4.0.14. The operating system/hardware information is as follows: RedHat 8.0 - kernel 2.4.18SMP 4x Xeon Processors 4x 80GB SCSI drives (hardware

Re: Lowering the ft_min_word_len

On Tue, 2003-08-05 at 10:57, Paul DuBois wrote: At 10:30 -0700 8/5/03, Justin Hopper wrote: Hello, I have a table with a FULLTEXT index on a column of type 'text'. Searches on this table using MATCH() AGAINST() work fine for most words. However, I needed to match against a 3 letter word.