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 t
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
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++
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 PRO
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
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 /var/
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]
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 u
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 s
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 c:\Apache\mysql\b
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
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 PROT
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
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> wo
Also, see what errors you are getting in mysql .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 datab
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 (
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
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
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:
:
: -r
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'
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
prop
8:44 AM
> To: Noamn; [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)
&
IL PROTECTED]>
Sent: Thursday, July 18, 2002 5: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 en
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
/var/lib/mysql/mysql/host.f
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]# /u
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 PR
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 proce
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.
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
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]]
Se
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-wi
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
Dear Gurus,
Yesterday I changed the ownership of /var/lib/mysql to
user mysql
chown -R mysql /var/lib/mysql
Then I started the mysql server with command
/usr/bin/safe_mysqld --skip-grant-tables
The daemon started without crashing immediately.
I then could get into mysql prompt
As per manual i
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 RHL
> 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?
--
> 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
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.
>
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
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 wa
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, if
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 crea
> 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 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.
-
AIL 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 prob
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
>
Hello,
Your column counts don't match. You call out 24 columns in in your
insert statement, but you only have 20 values.
Curtis
On Tue, 24 Apr 2001, J.Heegsma wrote:
> Dear Sir/Madam and mysql users,
>
> I have a mysql database which i can fill with phpadmin, everything is going fine,
>bu
My hint is inserted in code. This can help ,if you have connection established and
proper database selected. If you dont't know what I'm talking about, try
http://www.php.net/manual/en/function.mysql-select-db.php
there is also small example included.
Mirek Novak
Require ('connect2.php');
>
Here we go again
This is a PHP issue NOT MySQL.. more info: www.devshed.com
www.phpnewbie.com www.phpbeginner.com www.php.net
One hint.. don't forget ?> to close PHP code..
Bye,
B.
mysql, query
At 14:46 24-4-01 +0200, J.Heegsma wrote:
>Dear Sir/Madam and mysql users,
>
>I have a mysql
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'
-
"It does exactly what it says in the tin"
> ERROR 1044: ACCESS DENIED FOR USER : '[EMAIL PROTECTED]' TO DATABASE
'CART'
You'll have to get permission to create the database.
If you are the MySQL admin, lookup "grant" in order to give user "ABHI"
access. Something like:
grant all on cart.* to [
>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 s
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? H
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 que
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: Mo
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
55 matches
Mail list logo
