AZZOPARDI Konrad wrote:
Hello people,
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems to be there
Konrad,
AZZOPARDI Konrad schrieb:
Hello people,
I do not know if this the right listI am migrating a very basic application from an older mysql version 4.1.9-standard to a new mysql version 5.0.45 {RedHat default package}. I have migrated DB data from one to the other and all data seems
ali asghar torabi parizy wrote:
hello.
i want to connect to mysql from c++ .
i examine any version or platform.
i use mysql5 and 4 in suse10 with gcc.then examine mingw and mysql5 and 4
and 3 for severeal times but i can't solve this problem.when i want to compile
examples of mysql++
From: Aron Bereket [mailto:[EMAIL PROTECTED]
Hi there,
I have recently installed mysql and php on my mechine
and both work fine. But when i wrote an HTML/Php to
access my databse I got the following error message:
Fatal error: Call to undefined function:
mysql_pconnect() in
Thanx for the quick reply peter.
That of one of the things I did when I had the
problem. It was not enabled. But when I enable it it
gave me mysql.so doesn't exits. I checked it on the
path there is not mysql.so.
cheers,
Bereket
--- Peter Lovatt [EMAIL PROTECTED] wrote:
check your php.ini to
Dear Mike,
Thanx for the quick reply. I did what you specified on
your rely.
There is --with-mysql argument but is not set it is
just '--with-mysql'
does it mean I have to recompile it again?
cheers,
Bereket
--- Mike Johnson [EMAIL PROTECTED] wrote:
From: Aron Bereket [mailto:[EMAIL
Did you stop and restart the server while you had the client up? This will break the
client's connection and force it to try and re-establish it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 12:33 25/9/2003 +0900, Ganbold wrote:
Hi,
I installed mysql-4.0.15 in Windows 2000 Advanced server. Mysql-max-nt is
working fine, except some problems.
Sometimes when I try to use access web pages through php pages, mysql says
Connection to server lost or
Can't connect to mysql server or
Thanks Miguel.
I increased net_read_timeout and net_write_timout up to 300 sec, but
problem still exists.
My queries are executing only in few seconds, but sometimes mysql shows
Can't connect to server, or Connection lost etc.
I used mysql-4.0.14 server and client, but problem was same and I
At 23:47 +0800 2/13/03, [EMAIL PROTECTED] wrote:
Hello Sir,
I have problem connecting to mysql in dos-prompt..
Error is : can't connect to mysql on localhost 10061)..
What does it mean?
I also try another method to solve this problem by typing
mysqld-nt --install
error prompts saying that the
Ellen,
Error is : can't connect to mysql on localhost 10061)..
I also try another method to solve this problem by typing
mysqld-nt --install
error prompts saying that the service already exists.
The current server installed is : c:\Apache\mysql\bin\mysqld-nt.exe
Start
On Wed, 20 Nov 2002, Francesco wrote:
Hello,
I tried to execute the following query:
SELECT studenti.*
FROM studenti,valutazioni LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE valutazioni.sid IS NULL;
Hi!
I think you don't have to specify valutazioni in the FROM subclause (is
Syntax errors. Try:
SELECT studenti.*
FROM studenti LEFT JOIN valutazioni ON studenti.sid=valutazioni.sid
WHERE ISNULL( valutazioni.sid )
Ignatius
- Original Message -
From: Francesco [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
dane,
Friday, August 09, 2002, 10:53:30 PM, you wrote:
dr My phpBB forums, say if i make a post, then it goes to the post, but
dr nothings there, so i have to go to index.php for it to show (and it will log
dr me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it
dr would
did you also install the databases that are part of the mysql installation?
-Ll
on 8/11/02 5:59 AM, Anish Mathew, typed:
my sqlserver is not running
when i issue the command mysql
the response i got was cant connect to local mysql
server through socket /var/lib/mysql.sock (111)
Also, see what errors you are getting in mysql hostname.err file
Regards,
Bhavin.
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, August 11, 2002 3:30 AM
Subject: Re: Mysql Problem Query
did you also install the databases that are part
Philip Molter [EMAIL PROTECTED] writes:
On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
: The mysqld.log file says:
:
: 020717 13:05:05 mysqld started
: 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 020717 13:05:05 mysqld
En réponse à Philip Molter [EMAIL PROTECTED]:
Hi
I am sure that tehre is a bug in RH 7.3
I've said it several times in this mailing list, but nobody wants to belive me!
It's true that this information is difficult to find, but I've learned it on
the documentation of www.mysql.org, the one with
The mysqld.log file says:
020717 13:05:05 mysqld started
020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05 mysqld ended
But I do see the host.frm file:
-rw-rw1 root root 8958 Jul 17 13:04
:44 PM
Subject: Re: MySQL: Problem Installing on RH 7.3
The mysqld.log file says:
020717 13:05:05 mysqld started
020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05 mysqld ended
But I do see the host.frm file:
-rw-rw1 root
; [EMAIL PROTECTED]
Subject: Re: MySQL: Problem Installing on RH 7.3
The mysqld.log file says:
020717 13:05:05 mysqld started
020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020717 13:05:05 mysqld ended
But I do see the host.frm file:
-rw-rw
First, nice username :)
Anyhow, use the /etc/init.d/mysqld script as root to start/stop mysql,
not the safe_mysqld binary. The init.d script really calls the
safe_mysqld binary, but ti also makes a couple sanity checks like
ensuring that the initial database files exist and are owned by the
You can see them because you are root, and you own them.
Mysql can't see them because it is mysql.
chown -R mysql /var/lib/mysql
Richard Fox wrote:
The mysqld.log file says:
020717 13:05:05 mysqld started
020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
'./mysql/host.frm'
On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
: The mysqld.log file says:
:
: 020717 13:05:05 mysqld started
: 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 020717 13:05:05 mysqld ended
:
: But I do see the host.frm file:
:
:
I guess your harddisk ran out of space. Delete some stuffwithout
restarting the database.
Relihan, Daniel wrote:
Hi,
All of a sudden it seems that my MYSQL is incapable of being written to. I
can still read from it, but cannot write to it. When I looked at the
processes, all the processes
Dig around for a log file or an error file. Whenever it won't start it tells
you why (or gives you a hint) in the error file. tail it and post if you
still need help.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Richard Fox [mailto:[EMAIL
On Wed, Jul 17, 2002 at 04:40:50PM -0400, Richard Fox wrote:
:
: The MySQL daemon does not run. I installed the binary RPM's from the RH cd,
: MySQL 3.23.49. I run mysql_install_db, outputs some text and appears to
: execute correctly. The I run safe_mysqld , and I get:
:
: [root@thor rfox]#
What happend when you ran scripts/mysql_install_db ?
Also when you run the databases with --skip-grant-tables as soon as you
grant a user acess and flush privileges it will then use the grant tables (I
think)..
Simon
-Original Message-
From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]]
Simona,
Monday, June 10, 2002, 4:31:33 PM, you wrote:
SDA Hi! I am new to mysql and this is my problem.
SDA The daemon runs well but I can start it only with --skip-grant-tables
SDA option, otherwise nothing will work.
SDA I set the password for the root user but when I exit the Mysql monitor
Now it works!!!
My problem was that I didn't know that if I set up passwords for users I had
to tell it to the web pages where I connect to the database (postgres
doesn't work like that).
I know this is stupid, but I began my message with I am new to mysql :-)
Anyway thank you for your replies.
On 3 May 2002 05:06:12 -
Jagadeesh Suryadevara [EMAIL PROTECTED] wrote:
When i check in the folder where it is loaded MySQL there are some
applications
with names MySQLManager,WinMysqladmin in bin directory.
When click on these applications it showing some screens but we
are unable
Jagadeesh,
Friday, May 03, 2002, 8:06:12 AM, you wrote:
JS We want to use MYSQl as a back end for one of our projects.
JS We download following 4 zip to install MySQL.
JS mysql-4.0.0a-alpha-win-src.zip
JS mysql-4.0.0a-alpha-win.zip
JS mysql-4.0.1a-alpha-win-src.zip
JS mysql-4.0.1a-alpha-win.zip
when as root I give command
/usr/bin/safe_mysqld
It gives me following messages:
Starting mysqld daemon with databases from
/var/lib/mysql and on the next line it says
mysqld ended.
What does /var/lib/mysql/`hostname`.err say?
Hi,
I also noticed one thing , will the entry in the file
/etc/hosts make a diffrenece.
In Red Hat it is
127.0.0.1 localhost
But in Slack it is
127.0.0.1 prasad( which is my name)
Regards,
Prasad
--- Prasad Paranjape [EMAIL PROTECTED] wrote:
Hello gurus,
I have Slackware 8.0 and RHL7.1
On Thu, Oct 25, 2001 at 08:27:00AM -0700, Bill Adams wrote:
At http://www.mysql.com/doc/ do a search for multiple processors. There's
a refence to http://www.mysql.com/Downloads/Patches/linux-fork.patch that
might help.
And don't forget to make sure you have good/needed indexes.
(e.g
Today after my server got a real traffic hit for the first time since I
installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed.
Here's how
it happened: watching the top load levels, I saw it slow creep
up about to
3, then rockets quickly to 30s, 40s, and on!! MySQL was at this
Hi Ryan!
Today after my server got a real traffic hit for the first time since I
installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
it happened: watching the top load levels, I saw it slow creep up about to
3, then rockets quickly to 30s, 40s, and on!! MySQL was at
jim barchuk wrote:
Hi Ryan!
Today after my server got a real traffic hit for the first time since I
installed PhpAdsNew (a MySQL/PHP Ad software), MySQL was crashed. Here's how
it happened: watching the top load levels, I saw it slow creep up about to
3, then rockets quickly to 30s,
Changing your IP address shouldn't affect your MySQL access in that way. I
would say you have done something else to cause those errors. You can look
at skip grants in the manual. From what you have written, your web pages
are accessing the DB as root. That spells D A N G E R. You should
Wouldn't that depend on if the MySQL db is on the same server as the web
servers and the scripts that connect to them. It could also depend on if
the scripts use the -h option when making a connection and if this is the
ip address (as in number) or is a resolvable name. If it is all local,
I thought using the result identifier returned by mysql_query in
mysql_fetch_array was perfectly legal.
mysql_query() doesn't always return a valid result identifier if an error
occurs (echo mysql_error()) or if no rows are returned.
When I run test.php I get this:
Warning: Supplied argument is not a valid MySQL result resource in common.php on
line 27
0
Here are lines 25-27:
25: $sql = select urate, arate, inhits from sitestats where id = $id;
26: $r = mysql_query($sql);
27: $row = mysql_fetch_array($r);
I
PROTECTED]
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Subject:Re: Mysql Problem
Send reply to: [EMAIL PROTECTED]
On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote:
I am facing great problems beacuse of Mysql server
On Fri, May 11, 2001 at 07:48:04PM +0530, [EMAIL PROTECTED] wrote:
I am facing great problems beacuse of Mysql server which is not able
to take load.
My apache is working fine even when the load average shoots of to
130 but my mysql server goes sleep when the load of apache shoots
above
I have done the following :-
Login through telnet and become root.
accessed :
mysql -h server name -u username -p
Password : password
and tried to create database with :
mysql create database cart;
ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE 'CART'
You say root..
you need to login into MySQL with rights to create databases. Your being
root under linux has got nothing to do with root under mysql.
Mani. M
and tried to create database with :
mysql create database cart;
ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE
'CART'
Are you sure about that number? 1,000 queries per second is pretty high.
Assuming that 10k per second is correct, that translates to 36,000,000
queries per hour. That is quite a lot. BTW, what DB were you using before
and was its inability to handle your load a factor in your decision to
switch?
If you are truly getting 10k queries per second, that would imply to me a roughly
comparable number of webserver connections (maybe within a factor of 2). If this is
the case, I'd be amazed that it would work at all when hosted on a single box with
"only" 256M of ram. I believe your problem
Okay just checking a few basic things, have you indexed your table properly?
There is a manual section about performance, also make sure to play around
with the mysql configuration file (global one in /etc/my.cnf)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MYSQL Problem
Date: Mon,
Hi there,
We have a very popular greetings card site at http://gcards.com We
recently switched to MYSQL as our backend database..
But recently we noticed that MYSQL cannot handle high load under
normal installation. In our system we get more than 10,000
insert/update/delete/select queries
50 matches
Mail list logo