Hello.
> $dbQuery = results;
Have you forgotten to put '$' before the 'results'? Do you
have display_errors = On in your php.ini?
Kane Wilson <[EMAIL PROTECTED]> wrote:
>
>
> hi ,
>
> I wanted to check the following condition and if it is
> success i wanted to display a massag
Kane Wilson wrote:
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die("Couldn't get
file list");
if (!isset($result))
{echo "NULL";}
hi ,
I wanted to check the following condition and if it is
success i wanted to display a massage.I tried as
follows. but no luck. nothing displayed.
$dbQuery = results;
$result = mysql_query($dbQuery) or die("Couldn't get
file list");
if (!isset($result))
{echo "NULL";}
//if (mysql_
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, max
OSX and other appl
Try
mysql -uroot
On 2005年08月23日 12时09分25秒, tai huijia wrote:
> Greetings,
>
> I'm a new user for MYSQL and I face problem adding
> mysql database.
>
> After typing:
>
> SHOW DATABASES;
> I got this:
> +--+
> | Database |
> +--+
> | test |
> +--+
> 1 row in set (0.0
tai huijia wrote:
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
+--+
| Database |
+
Greetings,
I'm a new user for MYSQL and I face problem adding
mysql database.
After typing:
SHOW DATABASES;
I got this:
+--+
| Database |
+--+
| test |
+--+
1 row in set (0.02 sec)
which does not contain mysql and tmp as shown:
+--+
| Database |
+--+
Using OpenRowSet Transact SQL, I want to view/obtain data from MySql
using this function in "MS SQL Query Analyzer". Can I do this at all?
I have MyODBC driver and the relevant OLE DB provider to connect to
MySQL db, I can connect to MySQL db, but having problem with the last
parameter (table nam
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
Dear Sir/Madam,
I'm totally strugling on choosing the mysql
distribution for my "RedHat Linux9.0". My system
config is as follows.
1.Pentium 4 and Intel845 Chipset (Intel Original
Board)
2.gcc version - (GCC) 3.2.2 20030222 (Red Hat Linux
3.2.2-5)
I'm trying to develop the client programs.
Pl
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
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? Where is the
source? It
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,
Hello Friends,
I wrote one simple pgm to connect and disconnect the database in TC(Windows).
when compiling the program, it's giving the error, unable to open the
my_global.h and giving some more errors from the header files my_sys.h and
mysql.h. I copied all the header files from the mysql\in
Hi !
I'm having a problem.
In my 2nd database acces, na error as occured: "Cannot run server: System
could not find specific path (3)."
In first Access i did not have problem; i have accessed data base via
phpMyAdmin.
Now, i can't do that !
Why ?
Someone can help me !!!
Thanks.
Cum
Hello.
You may use _utf8 0xXX form of input, where is 0x - hexademical
representation of your japanese string (each unicode character has it's own
hexademical value). For an example see:
http://dev.mysql.com/doc/mysql/en/Charset-literal.html
>hi
>i want to do a insert query w
hi
i want to do a insert query which contains
utf 8 (japanese characters) characters in the database but surprisingly when i
done this it stores ??? and also when i retrieves it fails to give actual
picture
iam using mysql 4.1.b alpha using mysqlcc as
my editor and dos promt
looking for
Calos,
> Well i didn´t change nothing at no config file. Any suggestions?
> thanks.
If you didn´t change anything, it´s supposed to be time to you
configure the my.cnf file.
A better tunning should solve your problem.
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysq
Carlos,
I asked you to post the COMPLETE .err log. Do NOT cut anything off.
Regards,
Heikki
- Original Message -
From: "Carlos Augusto" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 24, 2004 7:38 PM
Subject: Re: Innodb corrpution. Very
Well i didn´t change nothing at no config file. Any suggestions?
thanks.
Sorry all for those lots of questions... i´m new at mysql and I need
it very much at my job.
and sorry for the english too.
On Wed, 24 Nov 2004 16:20:57 -0200, Ronan Lucio <[EMAIL PROTECTED]> wrote:
> Carlos,
>
>
>
> >
Carlos,
> 041124 14:13:18 Innodb: fatal error: cannot allocate 2147500032 bytes of
> innodb: memory with malloc! total allocated memory
> innodb: by inndodb 16975556 bytes. Operating system errno: 8
> innodb: Cannot continue operation!
> innodb: check if you should increase the swap file of ulimit
OTECTED]>
> > Newsgroups: mailing.database.myodbc
> > Sent: Monday, November 22, 2004 10:37 PM
> > Subject: Innodb corrpution. Very Urgent
> >
> > > Hello, i=B4m having a problem with a large database...
> > > at ibdata1.My ibdata1 is corrupted and i saw
Hi!
The size limit in InnoDB is 64 TB.
You have probably mixed up ibdata files or ib_logfiles. The ib_logfiles that
you are using are probably completely zero-filled. No checkpoint info in
them.
What does
mysqld-nt --console
print if you move the ib_logfiles away?
When creating new ibdata files,
MySQL 4.0.14
InnoDB (File size as it stands at present) = 6 GB
We have tried move the data folder from one hard disk
to another still the same problem. We really are in
need of help here. Is there any size limit in InnoDB?
I did ask this before, I did get some reponse thank
you. But due to th
Carlos,
- Original Message -
From: "Carlos Augusto" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, November 22, 2004 10:37 PM
Subject: Innodb corrpution. Very Urgent
Hello, i=B4m having a problem with a large database...
at ibdata1.My ibdata1 is
Hello, i´m having a problem with a large database...
at ibdata1.My ibdata1 is corrupted and i saw other postings and all of
them asks to use mysqldump, but in my case there´s a problem...
I can´t run mysqld since ibdata1 is corrupted.
Those anyone have a tip for me?
in logfile says that mysqld can
der.php
>
> Order MySQL technical support from
> https://order.mysql.com/
>
>
>
> - Original Message -
> From: "A Z" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Wednesday, November 17, 2004 1:48 AM
> Subject: mysqld-nt
technical support from https://order.mysql.com/
- Original Message -
From: "A Z" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, November 17, 2004 1:48 AM
Subject: mysqld-nt error 23. Urgent pls
MySQL 4.0.14
Need help please with the folowing:
O
Hello.
I didn't found any bug in bug database, which was similar to your's.
Also I haven't ever heard about that thing: count of open files exceeded
OS limit in Windows. So for the beginning take a look at:
http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html
And, if it won't be
MySQL 4.0.14
Need help please with the folowing:
On starting mysqld-nt using
mysqld-nt --console
we the get the follwing output
041115 10:31:59 InnoDB: Database was not shut down
normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: lo
One thing Jim didn't mention is that mysqldump is not a mysql client
command but a standalone executable. Run it from a shell prompt (DOS
prompt if you are using windows)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Jim Grill" <[EMAIL PROTECTED]> wrote on 09/09/2004 11:
>
> --
> help please
>
> please tell me how to extract a script file of a database from mysql
commandprompt.
>
> s.deepak
>
>
> This life is a hard fact; work your way through it boldly, though it may
be adamantine; no matter, the soul is stronger
>
> Swami Vivekananda
>
Are you looking for mysql
--
help please
please tell me how to extract a script file of a database from mysql commandprompt.
s.deepak
This life is a hard fact; work your way through it boldly, though it may be
adamantine; no matter, the soul is stronger
Swami Vivekananda
--
MySQL General Mailing List
For list archives: ht
iling.database.myodbc
Sent: Monday, June 07, 2004 12:56 PM
Subject: URGENT !! InnoDB Constraint problem !
> i dont have that section in my status report (ill tried it before)
> here's the report
> *** 1. row ***
> Status:
> ==
i dont have that section in my status report (ill tried it before)
here's the report
*** 1. row ***
Status:
=
040607 10:04:41 INNODB MONITOR OUTPUT
=
Per second averages calculate
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
I have a problem with my innodb database wich freaks me out ,
first a description of the involving tables :
mysql> describe pages ;
+-+--+--+-+-
++
| Field | Type | Null | Key | Default | Extra
On Tue, May 18, 2004 at 10:08:32AM -0400, Ronnie Regev wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need to be pointed in the right direction please.
> Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
> hosting environm
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: Unknown error, urgent help please
"Ronnie Regev" <[EMAIL PROTECTED]> wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need t
"Ronnie Regev" <[EMAIL PROTECTED]> wrote:
> Hi,
> Before I go on, I know nothing about mysql, but my db admin is out of town
> and I need to be pointed in the right direction please.
> Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
> hosting environment on Ensim webppli
Hi,
Before I go on, I know nothing about mysql, but my db admin is out of town
and I need to be pointed in the right direction please.
Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
hosting environment on Ensim webppliance-3.5.20-7.
When using phpMyAdmin and attempting
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.
>
H
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 can provide me the maximum size of the databa
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]
> Subje
Hi,
I am working on mysql repliction on windows 2000.
I am trying to make the slave as master when the master goes down. When I
execute the io thread shutdown on slave after master goes down, it hangs.
Even the slave server does not stop on executing the shutdown command using
mysqladmin and
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
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 corrupted. Does anyone
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
Raza
GE Financial Assurance
-Original Message-
From: Soni, Sanjay K [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 25, 2004 6:48 PM
To: [EMAIL PROTECTED]
Subject: urgent help required for mysql
040225 13:57:20 mysqld started
InnoDB: The first specified data file ./ibdata1 did not
"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:
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: wait...
040225 13:57:22 InnoDB: Log file ./ib_logfile
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
hi!
> "A" == Arunachalam <[EMAIL PROTECTED]> writes:
A> Hai MySQLians!!!
A> I have established the Successful Connection to MySQL from COBOL.
A> Now from COBOL I can able to query the MySQL and get back the
A> result sets using C APIs under MySQL 4.0.17-max both in windows
A> and Linux. No
Hai MySQLians!!!
I have established the Successful Connection to MySQL from COBOL.
Now from COBOL I can able to query the MySQL and get back the
result sets using C APIs under MySQL 4.0.17-max both in windows
and Linux. Note that my Client is in Windows platform...
Its not enough for my applicat
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
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?
TIA
Regards,
Anup Mahansaria
--
MySQL General Mailing List
For list archives: h
On Sun, 8 Feb 2004 [EMAIL PROTECTED] wrote:
> the only way I can connect to the server is typing
>
> mysql -h localhost -u root
>
make sure you don't have a line "skip-networking" in your /etc/my.cnf
cheers,
Tobias
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Can't connect URGENT!
Hmmm, I dunno.
Perhaps the term: mysql -h 'server' -u root
Should be changed to: mysql -h your_hostname -u root
As "your_hostname" is the actual FQDN of your server.
Brian Duke
SS-TCAM//87797
-Original
: Saturday, February 07, 2004 5:30 PM
To: [EMAIL PROTECTED]
Subject: Can't connect URGENT!
Hi,
I have instaled mysql 4.0.17 on a debian server, but i have a big
problem.
I can only connect to mysql at the server and only with -h localhost. If
I try
this:
mysql -h server -u root
from
On 8 Feb 2004, at 00:29, [EMAIL PROTECTED] wrote:
Hi,
I have instaled mysql 4.0.17 on a debian server, but i have a big
problem.
I can only connect to mysql at the server and only with -h localhost.
If I try
this:
mysql -h server -u root
from anywhere i receice always the same response:
Hi,
I have instaled mysql 4.0.17 on a debian server, but i have a big problem.
I can only connect to mysql at the server and only with -h localhost. If I try
this:
mysql -h server -u root
from anywhere i receice always the same response:
ERROR 2003: Can't connect to MySQL server on
FROM:Emma Ken
3/5 RIDER HAGGARD CLOSE
JO,BURG-SOUTH AFRICA
PHONE:[874]-762-864166
PHONE:(874)-762-864167
FAX :(874)-762-864168
RE: TRANSFER OF ($26,000.000.00 USD} TWENTY SIX
MILLION DOLLARS
Dear Sir,
I want to transfer ($26,000.000.00 USD) Twenty six
million United States Dollars from a Pri
- Original Message -
From: Prashant A <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 5:20 PM
Subject: [PHP] Urgent Two Queries / Problems to be Solved--Prashant
Akerkar
>
> De
Dear Mr Jeffrey Dyke
There are some queries regarding PHP 4.1.As you mentioned in php 4.1
register_globals=off. are set for security reasons.
Is it Required to have Form attribute as enctype="multipart/form-data" if i
have a File Upload on the Particular Form.
i.e
I am Facing a Problem as
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
TECTED]
phone: +49 941 / 78 88 7 - 121
fax : +49 941 / 78 88 7 - 20
cellphone: +49 174 / 41 94 97 0
--
> -Original Message-
> From: Rainer M. Krug [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 13, 2003 10:03 AM
> To: [EMAIL PROTECTED]
> Subject: Urge
Hi
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 name of my c
Hi
I did something stupid: I locked myself out of the
MySQL server...
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 name of my computer where the MySQL
server is insta
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
how to rename a field name "IN" to something else..
I could not use
alter table tbl_name change IN NEW mediumtext;
Pl. suggest how to rename particular "field name" for all the tables in
a database
thanks
M.Karthikeyan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
Hello - I've got a simple MySQL/PHP database set up with 3 tables plus a
"relationship" table (using phpMyAdmin.) The end result is for students to
be able to dynamically find out what books are required for their classes by
selecting; term ---> course ---> instructor ---> (results)
The tables l
Hello - I've got a simple MySQL/PHP database set up with 3 tables plus a
"relationship" table (using phpMyAdmin.) The end result is for students to be able to
dynamically find out what books are required for their classes by selecting; term --->
course ---> instructor ---> (results)
The table
"gibex" <[EMAIL PROTECTED]> wrote:
>
> I have 2 tables and I want a faster report like this.
>
> | counter | user_company_name |
> +-++
> | 65537 | company1 |
> | 65535 | company2 |
> | 64563 | company3 |
> | 52676 | comp
Hi
I have 2 tables and I want a faster report like this.
| counter | user_company_name |
+-++
| 65537 | company1 |
| 65535 | company2 |
| 64563 | company3 |
| 52676 | company4 |
User_table description
| Field
nt: Tuesday, July 22, 2003 9:54 PM
Subject: URGENT : Benchmark
> Help me ...
>
> Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]>
wrote:Hi All,
>
> I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would
like to make tests using Fibre Channel and iSCSI with MYS
Help me ...
Antonio Jose Rodrigues Neto <[EMAIL PROTECTED]> wrote:Hi All,
I almost finish my MSC Thesis and my thesis is iSCSI Performance. I would like to make
tests using Fibre Channel and iSCSI with MYSQL. Please I will need informations
(cookbook) how does implement tunning on MySQL - Linu
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
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 up
until it kills the server:
| 106 | unauthenticated user | 192.168.1.
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
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 (looks practically
Jason> identical
101 - 200 of 487 matches
Mail list logo