anyone explain what may be going on here?
How can I clear the mysqld processes, and restart mysql so that I can use
it?
Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
I now have two mysqld processes running on my server (Freebsd / apache), and
no mysql (according to a ps command).
What is the safe way to kill these two, and restart mysql?
Ian
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 24
on the msyql.org site?
Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
I have run mysqld - and it tells me it is ready for connections - what
syntax is it looking for? (is it the same as mysql ie commands and then a
';' to finish?
Ian
-
Before posting, please check:
http://www.mysql.com
'password_obscured' WITH GRANT OPTION;
myslqd tells me it's it is ready for input.
But I'm not sure what to input?
Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
- IDENTIFIED BY 'itsmeolord';
This seems strange to me, as I figured that root would have permission to do
anything (even if it were 'inappropriate'.
Any guidance would be appreciated.
Ian
-
Before posting, please check:
http
in the user table - however I did find the % mark
in the mysql.host table - two records - one for localhost and the other my
domain name, and the % mark was in the db column.
Ian
- Original Message -
From: Gelu [EMAIL PROTECTED]
To: Ian Phillips [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday
Yes - but I haven't got the picture of what you're trying to communicate.
I thought I would have to log in as root, to be able to create the user cbaa
and allow that user to access the cbaa database.
Ian
- Original Message -
From: ÅÇ´f¼Ù (Borus.Kung) [EMAIL PROTECTED]
To: Ian Phillips
' |
+---
--+
1 row in set (0.00 sec)
Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
reinventing the wheel).
3. Is what I am trying to do just plain dumb!
Many regards,
Ian Collins.
System Manager
KIWIPLAN NZ Ltd.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
a blob field from a mysql table that had
already escaped any illegal charachters, or how can I encode the blob
field myself so that the mysql statement I create is valid ???
Thanks in advance,
Ian Packard
-
Before posting, please
presume (again ??) that the above line is trying to strip out all ../
matches.
If so, then wouldn't { $_ !~ m:\.\./: } do just as well?
I changed the
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
to
my @non_raid = grep { $_ !~ m:\.\./: } @$files;
and it seemed to fix my problems.
Regards,
Ian
OK.
By the way - why is it trying to strip 2 digits in a row? I'm sure there was
a reason.
Cheers,
Ian Collins.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 3:05 PM
To: Ian Collins
Cc: Mysql (E-mail)
Subject: Re: mysqlhotcopy
presume (again ??) that the above line is trying to strip out all ../
matches.
If so, then wouldn't { $_ !~ m:\.\./: } do just as well?
I changed the
my @non_raid = grep { $_ !~ m:\d\d/: } @$files;
to
my @non_raid = grep { $_ !~ m:\.\./: } @$files;
and it seemed to fix my problems.
Regards,
Ian
OK.
By the way - why is it trying to strip 2 digits in a row? I'm sure there was
a reason.
Cheers,
Ian Collins.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 3:05 PM
To: Ian Collins
Cc: Mysql (E-mail)
Subject: Re: mysqlhotcopy
a blob field from a mysql table that had
already escaped any illegal charachters, or how can I encode the blob
field myself so that the mysql statement I create is valid ???
Thanks in advance,
Ian Packard
-
Before posting, please
able
to!) install from source code.
Can KIWIPLAN act as resellers of mysql, or would our customers purchase
mysql individually?
Cheers,
Ian Collins.
-
Before posting, please check:
http://www.mysql.com/manual.php
;
--
-- snip
By running this snippet, you will see that you need to double escape the
null to get it in the database.
But mysql_real_escape_string doesn't do this.
Is this a problem, or am I missing something.
Many regards,
Ian Collins
archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
IW.
Ian Waters
[EMAIL PROTECTED]/interesting.net/geekninja.net/geekcoop.com
PGP Public Key:
http
mysql use protodel;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'access'
Didn't find any fields in table 'document'
Didn't find any fields in table 'document_access_log'
Didn't
Here is the 2.8 package I just downloaded from one of your mirror sites.
[reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin ls mysqld
mysqld*
[reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin file mysqld
mysqld: ELF 32-bit MSB executable SPARC Version 1
experienced installers /
unix gurus really would be very much
appreciated...I'm getting very frustrated with this :(
Thanks v. much in advance,
Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
will have done this before.
Thanks in advance,
IW.
Ian Waters
[EMAIL PROTECTED]/interesting.net/geekninja.net/geekcoop.com
PGP Public Key:
http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0xFF7EE368
-
Before posting
regards,
Ian Collins.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e
and table2.id2=table3id2
left join table4 on table3.id3=table4.id3
left join table5 on table3.id4=table5.id4
left join table6 on table3.id5=table6.id5
left join table7 on table3.id6=table7.id6
HTH
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH
i've made,i'm stuck,anyone there to help me?
thanks
Have you flushed the privileges after changing the tables?
FLUSH PRIVILEGES
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
between MySQL users and local system users.
HTH
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
-
Before posting, please
of the
program).
I hadn't even used a HANDLER READ when it had crashed - just the OPEN.
I guess it's kind of understandable, and not something that happens a lot,
but it may be worth adding this caveat to the documentation (to save some
other lost soul hours of screen kicking).
Regards,
Ian
way to make that statement work? For those of you who
use PHP, is there any pressing performance reason to use or not to use
choice 'a'?
Thanks!
--
Ian Evans
Digital Hit Entertainment
http://www.digitalhit.com
-
Before posting
ON (profiles.titlesid = titles.titlesid)
LEFT JOIN soundtracks ON (profiles.titlesid = soundtracks.titlesid) WHERE
profiles.profilesid='$profileid'
--
Ian Evans
Digital Hit Entertainment
http://www.digitalhit.com
-
Before posting
surmise, off on a tangent)?
Are there any examples anywhere of how to use these?
Many regards,
Ian Collins.
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 15, 2001 11:49 AM
To: Ian Collins
Cc: [EMAIL PROTECTED]
Subject: Re: Help - Migration
not be a good idea to convert the \n to br
before insertion into the database, because these will
then appear in any textarea fields.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than
;-)
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
-
Before posting, please check:
http
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
-
Before posting, please check:
http://www.mysql.com
) you are using to store and retrieve it, it's
hard to provide a solution...
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
into a directory called
DBI-1.18
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
-
Before posting, please check
Hi,
Looks like you didn't run mysql_install_db.
NOTE: You'll have to change ownership of the database to mysql:mysql.
Regards,
Ian.
I installed MYSQL on a HPUX 11 machine and I ran the mysql-test-run
script and everything
passed, but when I start mysql up using bin/safe_mysqld or
bin
to
read the data directory.
In Windows you can probably do something involving the mouse and some
icon-thingies, or maybe a simple DIR at the command line.
(*) If you are not sure, use the command
SHOW VARIABLES
or at the command line
mysqladmin variables
and look for 'datadir'.
Ian
On Thursday 13 September 2001 15:36, Frank Fisher wrote:
Ian Barwick wrote:
In Windows you can probably do something involving the mouse and some
icon-thingies, or maybe a simple DIR at the command line.
Right-click on the MySQL database folder, selecting Properties.
Under DOS
On Thursday 13 September 2001 19:16, g g wrote:
Hi.
Is anyone aware of any tool to convert a mysql
database to an oracle database?
see:
http://www.mysql.com/news/article-57.html
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
I presume that you did run the mysql_install_db first of all??
If so, then check the ownership of the directory where the database lives.
This should be mysql:mysql. HAd the same problems till I resolved the
ownership issue.
Regards,
Ian.
-Original Message-
From: Nikolaos Rasidakis
It would be better to use joins. Something like this:
SELECT swimmers.surname_swimmer , swimmers.name_swimmer , swimmers.born ,
results.result , results.scale , competitions.date_competition
FROM results
left join disciplines on results.sif_discipline = disciplines.sif_discipline
left join
a mysql problem though. If you have any more php trouble,
it would be better to try a php mailing list.
-- Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
(highest ID) then it will not work because LAST_INSERT_ID()
will return 0.
-- Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
a pretty messy way of doing things and I would stick
with two SELECT statements.
BTW a simple COUNT(*) without a WHERE clause is optimized in MySQL.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database
,
not just the ones you select)
(...)
HTH
Ian Barwick
--
Ian Barwick - Developer [EMAIL PROTECTED]
http://www.akademie.de
Luncheon meat tables with MySQL data
-
Before posting, please check:
http://www.mysql.com
the answer (but not very clearly).
The AUTO_INCREMENT parameter is set on a per-table and not a per-row basis,
so the definition comes after the row definitions, e.g.:
CREATE TABLE mytable(
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY)
AUTO_INCREMENT=1000;
HTH
Ian Barwick
MaybeI
or SQL wildcard (*,?,% or _) then only
what's matched by the wildcard is shown.
user@host - /ascend/sql/bin/mysqlshow --status ascend_logs
Wildcard: ascend_logs
+-+
| Databases |
+-+
| ascend_logs |
+-+
-- Ian
| 0 |187 | 0 |
237901961
show variables:
Variable_name | Value
max_heap_table_size | 536869888
mysql ver 3.23.41
SunOS 5.6 Generic_105181-15 sun4u sparc SUNW,Ultra-250
--Ian
This is what I use in those situations:
select * from TABLE_NAME order by ID desc limit 1;
On Fri, Sep 07, at 01:43pm, Chris Aitken ([EMAIL PROTECTED]) wrote:
Hi all,
Just quickly,
Im managing to do this, but I can see that the method im using is not as
efficient as it could be. What
,
-- Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
That's what I thought at first as well. But my tmp_table_size is set to 64MB
and I used the --big-tables option just to be sure.
Also, show table status says the size is well below 64MB:
Name | Type | Row_format | Rows| Avg_row_length | Data_length | Max_data_length
tmp| HEAP |
There may be a better way, but right off the top of my head I'd say:
select tagnumber,days,expdate from membership
left join tags on membership.tagid = tags.tagid
where tags.tagid is not null
On Wed, Sep 05, at 06:10pm, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
Hello All,
I got a
records, how many orderids match the tagid in the same
table .. etc...
On Wed, Sep 05, at 07:26pm, Ian Moore ([EMAIL PROTECTED]) wrote:
There may be a better way, but right off the top of my head I'd say:
select tagnumber,days,expdate from membership
left join tags on membership.tagid
two.value three.value
x1 233 2342 NULL
x2 NULL 998NULL
x3 33 232 23
Clear enough?
A couple of LEFT JOINs should probably do the trick
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query
prevent another
insert being carried out before you retrieve the ID.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
On Tuesday 28 August 2001 13:55, Harald Fuchs wrote:
In article 01082813314101.11299@redgrave,
Ian Barwick [EMAIL PROTECTED] writes:
You mean using SELECT LAST_INSERT_ID() ?
and praying no other query was run at the same
time.
Try locking the table for writes just before your
.
Or how about using fetchrow_arrayref()? That would remove the duplicate hash
key problem, although you would have to extrapolate the column names yourself.
Hope your system has lots of memory to cope with that select statement on
tables of any significant size ;-)
HTH
Ian Barwick
--
Ian Barwick
- that's what databases are here for ;-). However,
you'll want to think about normalizing your database structure.
Hint: you'll need three tables.
HTH
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database
The table abbreviations end up doubled :-( but this guarantees the
application gets unique table names and avoids the hassle of aliases.
HTH
Ian Barwick
(*) Disclaimer: example code, may not be accurate, use at own risk ;-)
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH
wotsits.
In SQL (at least MySQL, database developers also believe tmtowtdt ;-) you can
use the DATE_FORMAT function, see:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
HTH
Ian Barwick
[EMAIL PROTECTED]
On Monday 20 August 2001 18:02, pc wrote:
Hi people
I am using mySQL
elegant solution to this problem in MySQL I'd love to
hear it)
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.de
To query tables in a MySQL database is more fun than eating spam
gname, item, gdate
from groups
where gdate in (select max(gdate)
from groups
group by gname)
Alas no subselects yet in MySQL (see:
http://www.mysql.com/doc/M/i/Missing_Sub-selects.html )
HTH in some way anyway
Ian Barwick
--
Ian Barwick
are only really useful when using the mysql client, where they
signify the end of a statement (alternatively you can use \g). In DBI
statements they will, more likely than not, cause errors. And as they aren't
in any way necessary, save yourself the trouble they might cause...
HTH
Ian Barwick
CONCAT(vat, '%') AS vat_pc
FROM price
You could of course keep a copy of the numeric value with an added %-sign in
a seperate text field, but I'm sure that would only complicate things further
;-)
Now if only MySQL supported VIEWs ... (*)
HTH
Ian Barwick
(*) See:
http://www.mysql.com/doc/M
/doc/M/i/Miscellaneous_functions.html
and they got the same error.
am i missing something easy here? is this a known issue? perhaps a version
thing? i am running 3.22.32.
Definitely a version thing, works fine on 3.23.37 (but doesn't on 3.22.32 - I
just tried ;-)
HTH
Ian Barwick
--
Ian
be any different on Mac OS X Server.
Cheers,
Ian Fieldhouse
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
where you want. My preference is in a
includes folder...
Thank you,
Ian Ford
Northwest Link
Web Development
-Original Message-
From: Neil Zanella [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 12:09 PM
To: Don Read
Cc: Ed Peddycoart; Mysql@Lists. Mysql. Com; Jorge Oliveira
Subject
I compiled and installed MySQL 3.22.32 on RadHat 7.0 and I am having some strange
behavior when it comes to double datatype fields. Please see the examples below. I
have the exact same version loaded on RedHat 6.2 and it works fine. What gives?
Here is the table and the data in it
mysql
I might have missed it but is there a way to get the strings related to a
enum from the database? (i.e. I have index 4 but I want the string that it
goes with)
thanks
-Ian Johnson
-
Before posting, please check:
http
command line.
Thanks for any help.
Regards,
Ian
mySQL/Java environment -
os: w2000
mySQL server: v3.23.36
mySQL client: v3.23.33
IBM JVM 1.3
Web solution: JSP/Beans
Web server: Jakarta Tomcat (from Apache project)
Web JDBC: mm.mysql-2.0.4 and Poolman
___
Hi
I have a WebObjects Application that I was using with
openbase and when I switched over to MySQL the app. could no
longer save the blob to the db. Is there some way to save a
picture in a blob in binary or should I be doing it another way.
thank
Ian
ed on an NT server and the database is on a UNIX
server. Not sure if that matters or not.
Any help would be great..
Ian
-
Craig Ian Dewick ([EMAIL PROTECTED]). http://lios.apana.org.au/~craig
Operator of Jedi (APANA Sydney member-access site) in Waterfall, Australia.
Always striving for a secure long-term future in an insecure short-term world
Have you exported a crypto system today? Do your bit to undermi
Sparc 20 running
Solaris 8 (aka SunOS 5.8) using gcc-2.95.2 as the compiler. The mysql
source version I'm trying to build is v3.23.33, and it's using Berkeley DB
v3.2.9.
Any advice would be greatly appreciated. I'm planning to use mysql
together with php to offer extra services to people using my s
Hello,
I tried to send this using the 'scripts/mysqlbug' script but sendmail
barfed
Description: configure problem finding size of char type on Sparc 20
How-To-Repeat: I was doing a fully-standard configure script run
Fix: unsure at this stage
Submitter-Id: Craig Dewick "[EMAIL
301 - 376 of 376 matches
Mail list logo