I'm attempting to write one SQL statement to retrieve data in a
particular way, and don't seem to be able to do it despite dozens of
attempts (indeed maybe it cannot be done), but wondered if anyone could
suggest anything, such as a function I may have missed that can do it,
or that it simply
Kevin H. Phillips wrote:
Yes, I installed by RPM. I have now found the error file as you
mentioned. The output for the last few days is:
030621 06:49:27 mysqld started
030621 6:49:28 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting
Im needing help in installing the fuse server and stuff
email me please if u can help
Hello everyone,
I am new to using MySQL and have installed a copy on my laptop which is
running Windows 2000. I am having an issue with setting up the root user
account. When I ran MySQL for the first time I was prompted to give a
generic user id and password. I did that, but when I run this
At 12:41 -0400 6/25/03, Luc Foisy wrote:
Yes, I turned those runlevels on already and now it works.
The problem is that it was a practically default install, that is
the way the runlevels were set out of the box
3.23.56 was this way after install
mysql 0:off 1:off 2:on3:off
I have odd characters in my database that appeared after updating from a
previous database. Most often the characters appear as simple squares where
spaces should be. I've been trying to make a query that will find where all
these characters appear in my table. The SQL looks like this:
SELECT *
Hello, all.
As of Friday the 20th, I'm running MySQL 3.23.56-1.72 on Red Hat 7.2, at
which time a consultant overwrote the existing MySQL-3.23.49a /
MySQL-Max-3.23.53a installation.
The server won't start up, and the mysqld.log file reports:
030624 17:24:25 mysqld started
Hi,
Since i don't know what is played for Sussex in two separate spells --
what's a spell ? (sorry) -- i assume it's a different period of time,
but don't know how to calculate it.
Ignoring the spell, i did this:
SELECT A.Playerid, A.Teamid, sum(if (A.Substitute=1,0,1))
not_a_substitute, sum(if
Message du 23/06/03 23:23
De : leking1 [EMAIL PROTECTED]
A : jessjaffre [EMAIL PROTECTED]
Copie à :
Objet : TR: Fw:Fwd: tr:fw:apparemment ça marche!
-- Entête Initiale ---
De: tiniwoopmarie [EMAIL PROTECTED]
A : leking1 [EMAIL PROTECTED]
Copie :
Date :
On 25-Jun-2003 Brent Genereux wrote:
I have odd characters in my database that appeared after updating from a
snip
I've copied the character into a text editor that can display the
hexidecimal value of the characters. The square character is different
than
a space, but for some reason
Hello All
I'm desperate. Since two days my Server crashed several times.
This is what happens :
The Webserver ist not responding any more. If i'm lucky i can still log
in.
System load ist 90+(!!!) rapidly increasing.
Top shows a LOT of mysql processes all eating CPU like hell. There are
also
a
[snip the problem code, comments eliminated for clarity]
if (mysql_num_rows($dbnpanxx) 0){
$npanxxcnt = 0;
while($urownpanxx = mysql_fetch_object($dbnpanxx)){
fputs($npanxxfile, $urownpanxx-o_npanxx);
fputs($npanxxfile, $urownpanxx-t_npanxx);
[snip]
Please excuse the cross-post again, but this is still dealing with how
PHP and MySQL together handle memory allocation.
[/snip]
One final note...it came to pass this morning that we looked closely at
many issues concerning this. Once of the things discovered was some
bad RAM in the
I must add, to be honest, and everything is clear :)
I did not install 3.23.52 on Red Hat 9.0, so it may in fact be that way for all
versions of mysql on RH9
Sorry about that.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 1:04 PM
To: Luc
Hi
If you log into MySQL on the command line and enter
mysqlSHOW PROCESSLIST ;
this should show you what is running. You may find a runaway query.
also check the temp disk space while the system is stalling - large joins
can use huge amounts of disk space. If MySql runs out of disk space it
Hi
I'm trying to create an application linked with libmysqld.a to create an embedded
server. Can my application act as a client to connect to a remote server ?
To be more precise, I would like to use
mysql_real_connect(db, remoteserver.xxx.com, mysql, 0, 0, 0, 0, 0).
When I do this, it
I have two server running Appache + PHP + MySQL.
Server #1 is production and server#2 is development.
I would like to keep MySQL DB on server#2 up to date. That is any
changes happening on server#1 I would like to be reflected on server#2.
Does anyone know how to do this?
Thank you in
At 11:51 -0700 6/25/03, Satheesh Ganapathi Subramanian wrote:
Hi
I'm trying to create an application linked with libmysqld.a to
create an embedded server. Can my application act as a client to
connect to a remote server ?
To be more precise, I would like to use
mysql_real_connect(db,
I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running
mysql_install_db, I switch to the directory where mysql.sock is located
and enter safe_mysqld . Here's a copy of the shell output:
# safe_mysqld
[1] 7549
# Starting mysqld daemon with databases from /var/lib/mysql
030626
What does the error log say?
David Shealy wrote:
I'm a newbie to MySQL. I'm trying to run it on Red Hat 9. After running
mysql_install_db, I switch to the directory where mysql.sock is located
and enter safe_mysqld . Here's a copy of the shell output:
# safe_mysqld
[1] 7549
# Starting mysqld
You could use replication of the occasional MySQLDump. Replication will
make your development server a slave to your production server, causing
every query done on the master to be reproduced on the slave.
See http://www.mysql.com/doc/en/Replication.html for more info.
Mysqldump will create a
I have searched the archives and the docs - and I cannot seem to find or
adapt an answer to this particular problem, hopefully someone out there
either knows how or can say simply that it cannot be done.
I have two tables that have the exact same schema, orders and old_orders:
order_id
I don't know where the error log is. I used the -l option with
safe-mysqld and this is what I got:
/usr/libexec/mysqld, Version: 3.23.56-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id CommandArgument
On Wed, 2003-06-25 at 15:40, gerald_clark
On June 25, 2003 09:59, PAUL MENARD wrote:
...
I've been considering upgrading my data , MySQL
3.23.42 to 4.013 or even going to 4.1. I've read on
the MySQL upgrade documents that some client might be
affected when upgrading to 4.1. It does specifically
mention Perl which I use to
Would there be any reason why I couldn't have MySQL running on the same box
as SQL Server 2000?
Thanks,
Steve
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
--
MySQL General
Using the C API for MySQL I am trying to convert a piece of ProC code
so that I can use it in MySQL and I am having a bit of a problem. The
function prototype lloks like the following:
int write_blob(db_thread_t* dbh, OCIBlobLocator* blob_in, unsigned
char* data, uint32_t data_len)
I am not
Hi,
I am creating a small web based program for users to access the
data in the datbases. New databases will be added in later. I want to
create a user to access these databases with certain rights, not all
rights. Will I have to grant this user right to each database as I add
them in or
On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote:
I want to be able to take a database running on a primary server and
duplicate/mirror it on a secondary server. I want to be able to update
the secondary server on a selectable interval (every 15 mins, every
hour, etc). What
The output of the greps follows. Could it be the mysqlclient that is
causing the trouble?
Kevin
[EMAIL PROTECTED] root]# rpm -qa | grep My
MySQL-python-debuginfo-0.9.1-7
Mysql-DBI-perl-bin-1.1825-1
MySQL-shared-3.23.53a-1
qt-MySQL-3.1.1-6
MySQL-python-0.9.1-7
MyODBC-2.50.39-11
At 18:02 -0400 6/25/03, michael young wrote:
Hi,
I am creating a small web based program for users to access
the data in the datbases. New databases will be added in later. I
want to create a user to access these databases with certain rights,
not all rights. Will I have to grant this
Sounds like your windows install process is not complete, check
http://www.mysql.com/doc/en/Windows_installation.html for more info.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Russ Guillemot [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 4:15 PM
To:
In a Pro C source file, a programmer uses the 'EXEC SQL ...' phrase to
execute sql statements against the Oracle data base. Is the something
comparable to this is the MySQL C API that I can use instead of
manually building sql statements for insert, select, delete, drop, etc.?
Sean Mac
hi there i was wondering if there is anyway to setup static variables in mysql , ie to
setup predefined paths in mysql . so all i can do is go select variablname as path etc
.. ??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I didn't mean for just this instance and this specific AES option (heck, I
don't even use AES at all ;-), I'm just saying that anywhere within the
mySQL .h files that has an option that someone may wish to edit in a
practical scenario, should be changeable via the my.cnf file instead/in
addition
What I've done is insert a bogus record at ID 999, then the next one will be
1000 and upwards. You can then delete the 999 record if you wish. mySQL will
NOT fill in the 1-999 spots automatically.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June
My MySQL database just stopped. I had 47 users running on it who just
stopped being able to access the database.
The .err file in the MySQL data directory has,
Version: '4.0.11-gamma-standard-log' socket: '/tmp/mysql.sock' port: 3306
030611 10:45:45 mysql_ha_read: Got error 124 when reading
mySQL should stop supporting SCO after their ridiculous allegations.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Jun 25, 2003 at 05:08:27PM -0700, Daevid Vincent wrote:
mySQL should stop supporting SCO after their ridiculous allegations.
How does MySQL support SCO?
Or are you talking about MySQL abandoning their customers who are
using SCO for one reason or another?
Jeremy
--
Jeremy D. Zawodny
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql show grants for testroot;
Hi
I agree the SCO action sucks but Open source software should be just that -
open to all, let the courts decide, if it ever gets that far!.
Peter
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 01:18
To: Daevid Vincent
Cc: [EMAIL PROTECTED]
Hi Mike,
Just a guess. Is perhaps one of the 4 records you mention a NULL record
(meaning no entry) ?
Why I am asking is because in this case you may want to use INNER JOIN or even
LEFT JOIN which should return also the NULL entry (incomplete datarecords).
That would make it
Select count(*)
Nils:
(B
(BNot exactly... :)
(B
(BI know for sure that there are 4 matching records - when I do:
(B(Select count(*) from orders where member_id='2') union (select count(*)
(Bfrom old_orders where member_id='2')
(B
(BI get:
(B
(B+--+
(B| count(*) |
(B+--+
(B|1 |
Hi Singh,
I thought that it would be the privilege database. Nice to hear things are
sorted. ;-)
Perhaps you should use the time to explore how the privilege datbase is
working ;-). It certainly was a interesting experience for me. There are some
good articles at www.devshed.com / something
Thanks Mike for the response,
I didnt even think for a moment that CREATE... SELECT, INSERT ...SELECT etc.
wouldnt be a subselect command (also it is a nested query).
I dont know why I didnt think about that. Mike you mentioned a very good
point. Maybe I was thinking to focused to see the
Hi Vitcoria,
Thank you for the response. No more questions about this, all systems clear
now ;-).
Thank you so much.
Nils Valentin
Tokyo/Japan
2003 6 25 21:18Victoria Reznichenko :
Nils Valentin [EMAIL PROTECTED] wrote:
WOW Victoria,
thats a good explanation. That makes many things
Hi Bruce;
I havent read Pauls book, but I will try to make an sample, also to confirm
for myself what I stated before.
I will come back to it once more. I am not sure if I should create a now post
for this or continue this threat as it s kind of attached to it.
Thank you for your reply.
Best
This is what perror says about error 134
Error code 134: Unknown error 134
134 = Record was already deleted (or record file crashed)
Hpe that makes any sense to you.
Best regards
Nils Valentin
Tokyo/Japan
2003 6 26 09:04Ian Collins :
My MySQL database just stopped. I had 47 users running
Hi Paul,
2003 6 26 09:55Paul DuBois :
At 9:19 +0900 6/26/03, Nils Valentin wrote:
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
Hi Bruce, tlr7425 and MySQl List,
2003 6 26 10:25Nils Valentin :
Hi Bruce;
I havent read Pauls book, but I will try to make an sample, also to confirm
for myself what I stated before.
I will come back to it once more. I am not sure if I should create a now
post for this or continue this
On 25-Jun-2003 Mike Morton wrote:
I have searched the archives and the docs - and I cannot seem to find or
adapt an answer to this particular problem, hopefully someone out there
either knows how or can say simply that it cannot be done.
I have two tables that have the exact same schema,
hi there , i finally worked out union joines are supported in 4.0 i thought it was 4.1
, anyway what are possible examples of its uses ?
say i'm trying to join two tables the second table has 10 rows returned with the key
of the first table i would like to only get one record from the first
I want to insert a value into a (one) field of all records in a table.
I tried:
INSERT INTO models (makeID) Values (1)
But that adds a new record, with the value filled in. I don't want a
new record, I want that value inserted into all the records of table
'models' 'makeID' field.
Thanks
Hi Ted,
I believe you are looking for UPDATE . (no WHERE clause).
Warning: This will update ALL fields within a column.
INSERT... will insert a single datarecord, while UPDATE... will change a value
of a single field usually, but without WHERE clause it will update ALL fields
in a
I grown my db to 4 tables 8). I'm going to ask this plainly in hopes
that my syntax in ok:
I know how to SELECT * from 2 related tables and get all the records
listed in the resultset.
(Either using INNER JOIN or WHERE.) Now... and I have been looking
some books!
How do get a resultset of
101 - 154 of 154 matches
Mail list logo