There absolutely is;
there is a configuration file belonging to MySQL named `my.cnf`. It can
exist in many places and there's a hierarchal order of precedense. The most
common of which is /etc/my.cnf.
Within this file you may specify the `datadir` option to identify location
you wish your data to
On Fri, May 13, 2011 at 9:21 AM, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location: /opt/mysql
>
> When creating a new database, a folder (with the name
On Fri, May 13, 2011 08:21, Tina Matter wrote:
> I have a MySQL question that I'm hoping someone can help answer.
>
> We have a linux machine which has MySQL 5.5.8 installed.
> It is currently installed in this location:/opt/mysql
>
> When creating a new database, a folder (with the name of the
Add:
datadir=/path/to/datadir/mysql
to your my.cnf file and restart mysql.
-Original Message-
From: Tina Matter [mailto:ti...@umich.edu]
Sent: Friday, May 13, 2011 8:22 AM
To: mysql@lists.mysql.com
Subject: URGENT: Change Default Location of where Database Files get written?
I have a My
Glyn Astill wrote:
I'd back up the data directories then try and then re-install mysql (sorry, I
know little about red hat and it's package management). It shouldn't overwrite
your data if it's already present anyway.
Great. Thought that would be the case, but without sleep, I wasn't sure. :-
Hi,
Here, threads_connected is considerable and below the preset value.
The threads_connected and threads_running are the good indicators to see how
loaded the server is. In your case it is good numbers.
So use 'iostat'/relavant utility to monitor the DB activity.
Also threads_created is mor
M` (`FLD_TICKET_NUM`),
KEY `FLD_MARK_AS_DELETED` (`FLD_MARK_AS_DELETED`),
KEY `FLD_ACC_ID` (`FLD_ACC_ID`),
KEY `FLD_BLOCK_STATE` (`FLD_BLOCK_STATE`),
KEY `FLD_FWD_FLAG` (`FLD_FWD_FLAG`),
KEY `FLD_ISSUE_CLOSED` (`FLD_ISSUE_CLOSED`),
KEY `FLD_REPLY_FLAG` (`FLD_REPLY_FLAG`),
KEY `FLD_SUBJECT` (`FL
: FLD_MSG_ID
key_len: 4
ref: tallydb.TFMM.FLD_MSG_ID
rows: 1
Extra: Using where
- Original Message -
*From:* Alex Arul <[EMAIL PROTECTED]>
*To:* Ratheesh K J <[EMAIL PROTECTED]>
*Sent:* Tuesday, January 23, 2007 11:57 AM
*Subject:*
age -
From: Alex Arul
To: Ratheesh K J
Sent: Tuesday, January 23, 2007 11:57 AM
Subject: Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently
you threads connected is 38 but your thread cache has only 8. So please do
bump it up. Also generate explain plan on both versio
Hi,
> I have the following table in mysql 5.0.20...
>
> employ
> ==
> empid
> date_time
> site
>
> I am using this table to store all the websites accessed by each
> employees. There is no primary key on that table since the same
> employee will access more than 100 sites per day. If there i
On 2006-12-19 Prem wrote:
> I am using this table to store all the websites accessed by each employees.
I hope you're aware that your country might have data privacy laws, too..
> There is no primary key on that table since the same employee will access
> more than
> 100 sites per day. If ther
Thank you very much..excellent support
- Original Message -
From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Cc: ; "Joshua J. Kugler" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2006 1
l.com
Subject: Re: Urgent please..
Ocourse i read the manual . I was unable to do so..ie the reason I
asked...I
also knew this location mysql@lists.mysql.com
- Original Message -
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To:
Cc: "Renish" <[EMAIL PROTECTED]&
Ocourse i read the manual . I was unable to do so..ie the reason I asked...I
also knew this location mysql@lists.mysql.com
- Original Message -
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To:
Cc: "Renish" <[EMAIL PROTECTED]>
Sent: Thursday, Novemb
Try http://www.php.net/manual/en/install.windows.php
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_
On Wednesday 15 November 2006 18:14, Renish wrote:
> Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on
> php.exe and nothing seems to happen.
> I have intalled
> 1) webserver-Apache2
> 2) MySql-41.1
Please read the documentation before asking questions such as these. Thanks.
Hi,
Initially i thought it solved the problem but then i realized that the
encoding done by PERL and this mysql function is different.I compated and
found that the difference is in a new line , in this function the encoded
output is all in one line and the same done via PERL via MIME::Base64 modu
Hi,
Yes that solved the problem and was fast.
I would like to know now that is there anyother way for the same in earlier
versions of mysql.
Thanks again,
--
Regards,
Abhishek jain
On 10/17/06, Ady Wicaksono <[EMAIL PROTECTED]> wrote:
http://firestuff.org/wordpress/wp-content/uploads/2006/03/ba
Hi!
> "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes:
Peter> Best group member,
Peter> My computer stopped working. And I was able to install Windows on another
Peter> partition and now I face one problem. I was running Windows with MySQL
4.1.
Peter> I have all C: working, and can acces
WEBBEE . BIZ wrote:
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
Hmm should work with PROCEDURE in
Hi all,
Can we run a query like UPDATE table_name set abc='1'; and still fetch the
value from a column from table .
I mean Can we run select And update query in one statement. If yes how.
Pl. tell me for versions 4.x and 5.x
Pl. do help me.
--
Regards
Abhishek Jain
On 4/20/06, abhishek jain <[EMA
Aftab Khan <[EMAIL PROTECTED]> wrote on 12/28/2005 02:15:33 PM:
> Can some one please tell me what I am doing wrong here I have
installed
> and configured users in the database. I am using ODBC driver to logon.
> When I use the password, it does not work but surprisingly the logon is
> allow
o: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
I saw both views and stored procedures in the dump file. What error do you
get if you process the script with the "source" command within the MySQL
CLI?
mysql -uroot -pmypa
t;myback1.sql
>
> it now restore the tables but not the views or sp’s
>
> here is the backup file
>
> thanks
> Barak
>
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 23, 2005 9:30 PM
> To: Barak Mery
> Cc: mysql@lists.m
Thanks Marko :)
-Original Message-
From: Marko Knezevic [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 24, 2005 12:29 AM
To: MySQL list
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
Dear Barak,
Save yourself year or two of your life and try using MySQL Front
Thanks again,
I will try this and read the manual again.
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:30 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: RE: urgent : PLEASE HELP - problems with back up and restore
There
MAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 23, 2005 9:07 PM
> To: Barak Mery
> Cc: mysql@lists.mysql.com
> Subject: Re: urgent : PLEASE HELP - problems with back up and restore
>
>
>
> "Barak Mery" <[EMAIL PROTECTED]> wrote on 11/
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 9:07 PM
To: Barak Mery
Cc: mysql@lists.mysql.com
Subject: Re: urgent : PLEASE HELP - problems with back up and restore
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> Hi,
>
>
"Barak Mery" <[EMAIL PROTECTED]> wrote on 11/23/2005 01:51:37 PM:
> Hi,
>
>
>
> I'm really desperate on this on.
>
> After struggling with some really weird bugs I finally finished my
project.
>
>
>
> Buut I can't perform a good backup and restore.
>
>
>
> I'm using :
>
>
Andrew stolarz wrote:
Hello All,
I am downloading and installing the "Installer package (Mac OS X v10.3)"
from the mysql site.
I am installing on a OSX 10.4 machine, at the end of the install I get an
error message saying
"The application MYODBCConfig quit unexpedically after it was reopened,
Hello.
> chown: `mysql:mysql': invalid user
Add mysql user and group (though, I thought that RPM package
automatically does this). Please, next time send you replies
to the list as well.
Ashok Kumar wrote:
> Hi Gleb,
> Thank u for ur reply. I downloaded the following
> files.
>
Hello.
Use Linux x86 RPM downloads for 4.1.13: Server, Client programs, Libraries and
header files, Dynamic client libraries. See:
http://dev.mysql.com/doc/mysql/en/which-version.html
Ashok Kumar <[EMAIL PROTECTED]> wrote:
> Dear Sir/Madam,
> I'm totally strugling on choosing
Chris Knipe wrote:
Hi,
We've just upgraded (via FreeBSD Ports) our one database from 4.1.11
to 4.1.12, and we are being hit by
http://bugs.mysql.com/bug.php?id=10674 - only on certain queries,
using rather large temp tables.
Now, from what I understand, there is a 4.1.12-1 available? Wher
Hello.
In my previous post I gave you a link to the thread where had
been described how to create the my_global.h. Have you tried that?
>Hi,
> U replied me without any contents. pls help me by giving some tips.
>
> Thanks and Regards,
>Ashok Kumar.P.S.
--
For techni
Hello.
See:
http://lists.mysql.com/mysql/180308
Ashok Kumar <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 11 lines --]
>
> Hello Friends,
> I wrote one simple pgm to connect and disconnect the database in
> TC(Windows). when compiling the program,
Dimitri,
please upgrade to a newer MySQL version.
"
Starting from MySQL 4.0.13, you can use SHOW INNODB STATUS to display a
detailed explanation of the latest InnoDB foreign key error in the server.
"
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for M
On Sun, 6 Jun 2004 15:48:37 +0200
Dimitri Bosiers <[EMAIL PROTECTED]> wrote:
> INSERT INTO
> pages(hidden,name,page_number,data,is_section_root,layout_id,group_
> id) VALUES(1,'nieuwe pagina',100,'',2,1,@LID);
>
> this fails with a "ERROR 1216: Cannot add a child row: a foreign key
>
> con
If you are getting table full error,may be your table
size is exceeding the maximum default size allowed.
check the table size and default size.
You can change the maximum size of the table using
Alter table command.
Somthing like following,but it is better so back up
the database before doing thi
Hi,
Unless he is having some weird nightmare that doesn't involve reality, then I am
pretty sure he is talking about this in the my.cnf:
innodb_data_file_path = ibdata1:400M:autoextend
A while back I remember that the autoextend was not in the sample my.cnf files. I
think this was around 4.0.1
At 23:32 +0530 4/28/04, [EMAIL PROTECTED] wrote:
Hi,
I am trying to insert the records in the database. After the insertion of
3millions records, it fails to insert the records further. Can someone help
me in this problem. How do I go and increase the capacity of the database.
Moreover if someone
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 28, 2004 2:02 PM
Subject: urgent: how to increase the database size
[snip]
> Moreover if someone can provide me the maximum size of the database which
> is possible.
>
Have you tried looking i
04/01/04 11:40 AM cc
Subject
What version of mySQL are you using, 4.0.19 (not yet released) fixes
something similar to what you have described.
--
DVP
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 31, 2004 7:49 PM
> To: [EMAIL PROTECTED]
> Subject: urgent help need
Marc Boorshtein wrote:
Hello,
I am urgently trying to restore a mysql database that was corrupted when
upgrading from OSX 10.3.2 to 10.3.3. I have tried downloading MySQL 4.0.14
and coping the original data files for the db into the appropriate "data"
directory, but the datetime fields are still
Hi!
It seems that you have installed mysql, but you did not run the
mysql_install_db, this script will create mysql "internal" databases(the
ones that carries user and config info), the script is usually in
"install_prefix/bin/mysql_install_db"
If you have no recently installed mysql, and the ser
Sanjay,
It seems you didn't run mysql_install_db script which is located in /scripts
directory. This script creates Grant tables for you when you first install mysql.
Basically the error says you missing those grant tables, you can re-run the script and
recreate them.
Hope that helps!!
Raza
"Soni, Sanjay K" <[EMAIL PROTECTED]> wrote:
> 040225 13:57:20 mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 040225 13:57:21 InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full:
hi,
I have created the COBOL coding to test those C API from
MySQL. Upon executing this COBOL program too hangup the server
but here using mysql_error() I got the error message in a
variable as
*Can't open shared memory. Request event don't create (2)*
These Error I captured after running the
hi,
I wish to provide some more information too regarding MySQL
Server hangup.
Once after I execute the C sample program, WinMySQLAdmin tool
and query commands from *mysql>* console never responds.
During this time if I try to start mysqld from another console
produce the following error mes
Hi,
I have written in intermediate, on the appropriate position in this
discussion, please go thru in full.
--- Michael Widenius <[EMAIL PROTECTED]> wrote: >
> hi!
>
> > "A" == Arunachalam <[EMAIL PROTECTED]> writes:
> A> As per my searching I have found the right C API in libmysql.lib
On Tue, 10 Feb 2004 [EMAIL PROTECTED] wrote:
> Hi,
>
> I could not find the binary for SCO Unixware (Intel based) in download
> section. I suppose mysql supports this environment too. May I know as to
> where can I find this binary. Do I need to build this myself?
There are some version on ftp.zen
TECTED]
Subject
Re: Urgent help needed - SCO Unix
Subject
Re: Urgent help needed - SCO Unix
Hi!
If memory serves me correctly, MySQL AB have stopped issuing SCO
OpenServer and SCO UnixWare binaries publicly and will only be providing
them to customers who take out commercial licences. This is probably due
to the fact that OpenServer and UnixWare cost a lot compared ot other
OSes, don
restart mysql with the skip-grants option
-Original Message-
From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 13, 2003 3:03 AM
To: [EMAIL PROTECTED]
Subject: Urgent problem
Hi
I did something very stupid: I locked myself out of the
MySQL server (all accounts, inc
> I did something very stupid: I locked myself out of the
> MySQL server (all accounts, incl administrator)...
>
> My problem: I use MySQLFront to change the allowed
> hosts and did it for all users. They were 'localhost'
> and I set them to 'localhost; EcolMod1' where the
> EcolMod1 is the na
On Fri, Nov 07, 2003 at 06:58:58PM -0500, karthikeyan wrote:
> how to rename a field name "IN" to something else..
> I could not use
>
> alter table tbl_name change IN NEW mediumtext;
>
I suppose this complains about a syntax error?
You can use any reserved word as fieldname (or tablename) by p
Does your university have a webpage indicating what advice is acceptable and
not considered plagarism?
- Original Message -
From: "Antonio Jose Rodrigues Neto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 9:54 PM
Subj
Quoting Nils Valentin <[EMAIL PROTECTED]>:
> When you said you modified the scripts, are these the scripts on the 12
> webservers (mysql clients) ?
Yes, when I mention modifying my scripts, I mean the scripts/pages on the 12
webservers
> If not, then these mysql clients (webservers) would stil
;Nils Valentin" <[EMAIL PROTECTED]>
> To: "Keith Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Friday, June 27, 2003 1:30 PM
> Subject: Re: URGENT problem with mysql processes
>
>
> Hi Keith,
>
> from your last e-mail I understand no
No, the slaves replicate fine and I can see their entries in the processlist
normally (as their hostname), not as "unauthenticated user"..
--
Keith Bussey
Wisol, Inc.
Chief Technology Manager
(514) 398-9994 ext.225
Quoting Nils Valentin <[EMAIL PROTECTED]>:
> Hi Keith,
>
> from your last e-m
Bussey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 1:30 PM
Subject: Re: URGENT problem with mysql processes
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your
Hi Keith,
from your last e-mail I understand now finally that we are talking about
replication here. Would have been a short cut to mention it in your first
e-mail.
The failed login attempts couldn't be from your slaves trying to login, but
you havent set them up on the master yet ?
Just a gu
When you said you modified the scripts, are these the scripts on the 12
webservers (mysql clients) ?
If not, then these mysql clients (webservers) would still be wanting to send
to IP addres 192.168.1.71 as configured for php or in your client.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月
Neither of these two machines send the request.
I have 12 webservers, which send the requests.
I have 5 database servers, 1 master(for updates/inserts/deletes) and 4
slaves(for selects).
Machine A below was the current Master DB server, however it is old and was
being replaced by machine B
--
Ok but that's not what I meant.
I'll try to explain better.
Machine A: IP = 192.168.1.71
Machine B: IP = 192.168.1.79
1) Scripts goto 192.168.1.71 - Everything is OK
2) Changed scripts to 192.168.1.79 - Site works at first, but processes pile up
until server is killed
3) Halt machine B
4) Gi
Hi Keith,
The wrong IP address could only avoid a client to connect to the database
server.
If you have the TCP/IP address specified in /etc/php.ini or for phpmyadmin in
config.inc.php or which ever tool you use than of course it will try to
connect to this IP address.
Best regards
Nils Val
Hi Keith,
2003年 6月 27日 金曜日 09:05、Keith Bussey さんは書きました:
> Major problem!
>
> I've installed mysql-standard 4.0.13 (from binary) a new DB server, it is
>
> - quad-xeon (500mhz each cpu)
> - 3 gig RAM
> - Linux Redhat 7.3
>
> When I start up mysql, processes looking like the following begin to pile
Michael Widenius wrote:
Hi!
"Jason" == Jason Buchanan <[EMAIL PROTECTED]> writes:
Jason> hi,
Jason> I'm having a hard time getting mysql 4 and mysql 3 to compile on IRIX 6.5...
Jason> Does anyone have a solution to this?
Jason> Below is an example of compiling mysql 4.0.13 (loo
Look at http://gcc.gnu.org/ml/gcc-bugs/2000-11/msg00293.html
(I don't know anything about this, but that page seems very relevant.)
-S
>
> From: Jason Buchanan <[EMAIL PROTECTED]>
> Date: 2003/06/04 Wed AM 08:22:29 CDT
> To: [EMAIL PROTECTED]
> Subject: URGENT: Problems compiling mysql 3 and
> It looks like you have a dynamic IP your end and the mysql
> server is looking
> for a fixed IP.
Nope, you read it wrong, both of you. MySQL is printing out YOUR IP
address, not the address of the server. It's complaining that you don't
have permission to access the data you want.
sql, query.
It looks like you have a dynamic IP your end and the mysql server is looking
for a fixed IP.
Try name based DNS form your PC.
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:manuvi@;eth.net]
Sent: 18 October 2002 09:38
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Urgent
I did the following to resolve the problem.
1. Your create command didnt work for me and I changed the add(128) on line
6 to addrs varchar(128). I suppose this was a typo since you already had a
working table.
2. Your main problem comes from the format of your input. Use /N for
ommited column
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill
wrote:
> Hi fellows,
>
> I got one text file of 9816 records (9816 lines) seprated by commas and
> enclosed by the inverted quotes and seprated by the end of lines. But
> when I
> import the file, it only gets half of recor
Hi
Two thoughts
try \r\n instead of \n
or
if you are getting warnings it may be that there is a problem with the
data - illegal characters or something?
if neither works email me offlist and I will take a look, if that helps.
HTH
Peter
---
Excel
> Its called Sun ONE from SUN.
>
> http://www.chilisoft.com/
Don't most people who use ASP want to use Visual Basic? So the
problem isn't really lack of ASP on Linux but lack of VB. Somehow I
doubt that Microsoft (at least in its current incarnation) is going
to come out with VB for Linux.
- Original Message -
From: "Chuck Payne" <[EMAIL PROTECTED]>
To: "William R. Mussatto" <[EMAIL PROTECTED]>; "Insanely Great"
<[EMAIL PROTECTED]>
Cc: "Ibrahim Al-Tawil" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday
ht. I think a
round $500.
But hey that my 2 Cents.
Chuck Payne
Magi
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 12:29 PM
To: Insanely Great
Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED]
Subject: Re: Urgent!!
On Sun, 29 Sep 2002, Ins
gt; Cc: Ibrahim Al-Tawil; [EMAIL PROTECTED]
> Subject: Re: Urgent!!
>
>
> On Sun, 29 Sep 2002, Insanely Great wrote:
>
> > Date: Sun, 29 Sep 2002 22:43:43 +0530
> > From: Insanely Great <[EMAIL PROTECTED]>
> > To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>,
William R. Mussatto wrote:
> On Sun, 29 Sep 2002, Insanely Great wrote:
>
>
>>Date: Sun, 29 Sep 2002 22:43:43 +0530
>>From: Insanely Great <[EMAIL PROTECTED]>
>>To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>>Subject: Re: Urgent!!
&g
On Sun, 29 Sep 2002, Insanely Great wrote:
> Date: Sun, 29 Sep 2002 22:43:43 +0530
> From: Insanely Great <[EMAIL PROTECTED]>
> To: Ibrahim Al-Tawil <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Urgent!!
>
> Greetings...
>
> I believe that ASP wo
Greetings...
I believe that ASP works well with MySQL thru ODBC. As of learning other
technologies it really depends what all you require.
Still MySQL works best with PERL and PHP.
Rgs
Insane
SQLyog ( http://www.webyog.com/sqlyog )
The Definative Front End for MySQL
- Original Message ---
"Sekhar.Thota" wrote:
> Hi,
>
> I have did setup for MySQL - Innodb tables. But I am not getting support for
> row level locks. Whenever I am issuing a update the innodb tables are
> locking my tables. Please help me whether I need to set any variables in
> sqld file to get the support for row le
"Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 17, 2002 5:13 PM
Subject: Re: Urgent: lost connections,
> Chris,
> Saturday, August 17, 2002, 2:04:40 AM, you wrote:
>
> CK> Lo everyone,
>
> CK> I've implemented
Chris,
Saturday, August 17, 2002, 2:04:40 AM, you wrote:
CK> Lo everyone,
CK> I've implemented replication on my MySQL Server... The master is mysql 3.23
CK> (FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32). I added
CK> the slave so that I can have a hardcopy / backup database
Hello.
On Mon, May 20, 2002 at 07:17:55PM +0400, [EMAIL PROTECTED] wrote:
> Hello:
>
> I was trying isamchk on my tables. Found one table with deleted blocks.
You know, there would be no reason to repair, except to reclaim the
disk space of the deleted rows?
> Used this option to check:
> ./is
thank you very much
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 20, 2002 8:25 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: URGENT: Update Error with MySQL++
Thi Cao writes:
> All,
>
> I can't seem to perfor
It looks like you don't have a path to that library. Once you find the
true location of libpthread.so, add that directory path to the file
/etc/ld.conf. After that is done, run:
ldconfig -v
as root and try again.
On Wed, 2002-03-20 at 09:13, Amrita Basu wrote:
> Hi, I am using Redhat 6.2 kern
Thi Cao writes:
> All,
>
> I can't seem to perform an update on my database with MySQL++. The
> execution of the query always throws an exception. Here's a snippet of what
> I did.
>
> Query query(&conn);
>
> query << "update employee set children = 3 where id = 9";
> query.execute();
>
> Th
Hi Stanley
You can get mysql to tell you what an error means by doing
perror
In your case the result is 'Record was already deleted (or record file
crashed)'.
You should be able to recover your table with myisamchk -r
james
At 15:09 04/03/2002 +, Stanley Joseph wrote:
>Hi ,
>When ever
My guess. . .
I have seen this problem with other databases . . . don't know if it is
true for MySQL as well. Try to change to your field definition to
float(5,2) as it may be counting the (.) as part of your field size.
So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x
Da
Hi Shankar,
This is your old buddy Scott S.
Try order by rather than group byThis will get you what you are looking
for
Scott Salisbury
- Original Message -
From: "SankaraNarayanan Mahadevan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 16, 2002 3:42 PM
On Tue, 29 Jan 2002, Sasha Pachev wrote:
> On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote:
> > I think we can avoid things like this by adding some extra 'not-
> > allowed-on-the-list' words, that a non-subscribe can't use, without
> > including an extra keyword in the email.
> >
>
On Wed, 30 Jan 2002, Marjolein Katsma wrote:
> Date: Wed, 30 Jan 2002 12:33:29 +0100
> From: Marjolein Katsma <[EMAIL PROTECTED]>
> To: MySQL <[EMAIL PROTECTED]>
> Subject: RE: Urgent Business Assistance.
>
>
> At 03:52 2002-01-30, Todd Williamsen wrote:
>
On Wed, 30 Jan 2002, Engr.Martin Douglas. wrote:
> Urgent Business Asistance.
>
> Engr.Martin Douglas.
Ok.. I'm about to slamdunk a few phrases into my procmail filters.
However, is there any way mere mortals on this list can get the full
headers?
(sql,mysql,database)
-
At 03:52 2002-01-30, Todd Williamsen wrote:
>If its so urgent and private then why are you spamming a mail list? I
>smell scam, or is that Spam?
It's both.
And please do not quote the *whole* spam - the loss of bandwidth (it goes to every
subscriber!) from the actual spam is already bad enoug
Hi Srinivas,
Here is some info, may meet ur requirement.
ALTER TABLE syntax :-
ALTER [IGNORE] TABLE tbl_name alter_spec [, alter_spec ...]
alter_specification:
ADD [COLUMN] create_definition [FIRST | AFTER column_name ]
orADD INDEX [index_name] (index_col_name,...)
orADD PR
On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote:
> I think we can avoid things like this by adding some extra 'not-
> allowed-on-the-list' words, that a non-subscribe can't use, without
> including an extra keyword in the email.
>
> Sasha, what do you think about this?
The point is t
G'day Michael, (I can't believe I'm _really_ replying to you:-)
> I don't agree that we should make the list subscribers only, as this
> would be a big drawback for newcomers to MySQL.
I'm a classic newcomer to mysql and have only been on the list for a week or
so. It surprised me how much s
If its so urgent and private then why are you spamming a mail list? I
smell scam, or is that Spam?
-Original Message-
From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 2:28 AM
To: [EMAIL PROTECTED]
Subject: Urgent Business Assistance.
Urgent Busi
1 - 100 of 140 matches
Mail list logo
