You can also use HeidiSQL, another free tool to visually manage and export
structure/data etc (and a whole host of other stuff) I use it to manage
windows and linux hosted databases.
George
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: 08 April
Nate,
The absence of details on the db and table structure prevent testing.
However, if you 'View Source' you'll see thet the form isn't being sent to
any response page, so there's nothing to handle the query and show the
results.
'form action=?form=yes method=post'
Hope this helps
George in
Hi,
I'm having intermittent problems with a big query where I grab about 30
fields from 4 tables.
I've snipped my query:
Select ... Status_Msg from Extracts, Transacts, Publisher, Status where (
Transacts.ID=33237 and
Extracts.Pub_ID=Publisher.ID and
Transacts.Status=Status.ID and
I'm no Linux expert (barely even a novice) but, from my Windows experience I
think that most applications will from time to time do this sort of thing.
What is important is how long it does it for!
If its a brief surge, its just trying to use the resources to complete the
task quickly. If it
[mailto:[EMAIL PROTECTED]
Sent: 29 May 2003 1:01 pm
To: [EMAIL PROTECTED]
Subject: Re: Quick fixe needed for 'Local Data Infile' problem on Win
NT/2000
George Pitcher [EMAIL PROTECTED] wrote:
I'm back on this list after a long break (from the list, not MySQL).
I'm starting to put together
Not sure if this is the problem, but in your INSERT statement, right at the
end you have this:
' sStatus ')
So you aren't treating this as a variable but as a string. Could this be the
bug?
Cheers
George in Oxford
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
would be welcome.
George
===
George Pitcher
HERON Technical Manager
Ingenta plc
23-38 Hythe Bridge Street, Oxford, OX1 2ET
T +44 (0)1865 799137 direct
T +44 (0)1865 799000 switchboard
F +44 (0)1865 799134
E [EMAIL PROTECTED]
www.ingenta.com
Ingenta: Empowering the exchange of academic
Hi,
Iam back on this list after being diverted by job change - moving house etc.
I've just set up one of my machines with Mandrake 9.0 and went for the
included MySQL install (3.23).
When I try to do anything I get an error saying that the 'mysql.sock' could
not be found.
I remember that this
To: George Pitcher; [EMAIL PROTECTED]
Subject: RE: Getting started - mysql.sock error
When I try to do anything I get an error saying that the
'mysql.sock' could
not be found.
Actually, you probably got a more detailed error message than
this. Try posting the entire error message - I
Egor,
Run
ps ax | grep mysqld
to see if mysqld is already running.
This returns '11276 pts/1S 0:00 grep mysql'
I have checked and cannot find mysql.sock anywhere.
Cheers
George
-
Before posting, please
]
To: George Pitcher [EMAIL PROTECTED]
Sent: Friday, July 12, 2002 7:43 PM
Subject: RE: using a '*.seq' file
Hmm, i'm not that much into Oracle but I know that between most Database
Systems small differences are there in the SQL syntax. What I would advice
you to do is just try to run the .seq file
I've been handed a 'data.seq' file containing a really useful database.
This is currently hosted on my future employer's site using Oracle. I wish
to look up some of the data there and pull it into my Filemaker database.
I'm using Filemaker for historical reasons and plan to move to MySQL in a
Yes:
ALTER TABLE `tablename` ADD `columnname` datatype
George
- Original Message -
From: Yair Zohar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 07, 2002 11:46 AM
Subject: An existing table
Hello,
Is there a way to add a column to an existing table in a mysql
Check that your fields are indexed.
This usually fixes it.
George
- Original Message -
From: Elsad YUSIFLI [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 10, 2002 3:10 PM
Subject: 45 seconds
i have a table and 51000 records in it.
it has got an index on HOST_NAME field.
Just a guess, but how about an ampersand?
Connection c =
DriverManager.getConnection(jdbc:mysql://localhost/dbName?user=usernamepas
sword=password);
George
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 5:11 AM
Subject: JDBC connection to
Can't you use the num_rows funtion to provide the count?
George
- Original Message -
From: mos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 6:11 AM
Subject: Re: How to Count(*) with LIMIT
I have a Where clause like:
select count(*) from table where
Sorry, taken out of context please ignore my first response.
George
- Original Message -
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; mos [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 9:46 AM
Subject: Re: How to Count(*) with LIMIT
Can't you use the num_rows funtion
://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 PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
=
George Pitcher
Technical
Whoa,
I've had this message 3 times now. Is there a problem somewhere?
George
- Original Message -
From: Ben Edwards [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 3:38 PM
Subject: where exists sql problem
having problems working out sql where exists syntax.
Thompson [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, March 13, 2002 5:59 PM
Subject: Re: Conflicting results using PHP/Mysql
I would guess it's because only three records match the ANDed tests in the
WHERE clause (last 3 lines
Thanks to Kevin, who yesterday emailed me with a solution to my JOIN
problem.
Thanks to all who helped me see the wood for the trees.
George
- Original Message -
From: Doug Thompson [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday
Hi all,
Posted this yesterday and got no response. Trying again today.
I'm having a small problem with a biggish query.
The query:
$Itemlistquery= select [a whole load of fields from 3 tables] ending with
;
$Itemlistquery.= transactions.Pdownload ;
$Itemlistquery.= from
Hi all,
I'm having a small problem with a biggish query.
The query:
$Itemlistquery= select [a whole load of fields from 3 tables] ending with
;
$Itemlistquery.= transactions.Pdownload ;
$Itemlistquery.= from bib_extract,scanrates,transactions where ;
$Itemlistquery.= (transactions.CourseID =
Also, make sure that you 'flush privileges' after storing your user details
in MySQL.
George
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 11, 2002 9:46 AM
Subject: Mysql error .
carlos,
Saturday, March 09, 2002, 7:58:57 PM, you
Hi all,
I asked this question on the PHP-DB list but everyone was asleep (no
response).
= = = = = = =
I have a site where dates are being displayed and also entered by users. I
don't want to offend them by asking them to use the -mm-dd format or to
split the
Just a thought. 'Label' might be a reserved name on win as it is/was used to
describe the name of a volume (drive).
But then again, maybe not.
George
- Original Message -
From: mweb [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, December 05, 2001 10:45 AM
Hi all,
I wish to migrate some Filemaker 5 databases over to MySQL on NT.
Some of the databases have hundreds of fields, so it would be great if I
could export in a format that I can just import without having to pre-set
all the fields.
Any experience/suggestions?
George Pitcher in Edinburgh
Similar for me. Except that I can do all the usual SQL stuff as root but if
I try and access via PHP I get the '/tmp/mysql.sock' missing message.
Is a complete re-install of MySQL the only solution or is there something
else that can be done to solve this problem, which, from scanning archives,
- Original Message -
From: [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]
Sent: Saturday, August 25, 2001 1:41 PM
Subject: Re: install problems AGAIN
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you
/mysql-3.23.37/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory '/usr/src/mysql-3.23.37'
make: *** [all-recursive] Error 2
Any suggestions
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL
that.
We are currently evaluating MySQL to see if there are any advantages in
moving.
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.heron.ac.uk
.
In order to tell whether these have been installed properly, what sould I be
able to see afterwards? IE which folders should be where and what should be
in them?
Sorry to be so basic.
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTECTED
Sorry, one more thing occurred to me. Should I install these in any
particularorder?
George
- Original Message -
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 24, 2001 7:37 AM
Subject: installing mysql - what should go where [linuxppc]
Hi all
Hi all,
Yes, its me again. I've re-installed the MySQL-3.23.27-1 packages in this
order:
DB Engine (included shared files as it then told me that the -shared- pkg
was already installed)
client (must be installed before devel)
devel
Didn't install bench (should I?)
I still can't seem to find
Hi all,
I'm getting closer and closer to having MySQL/PHP/Apache set up on my
LinuxPPC box.
Now, I haven't been sitting twiddling my thumbs while I was waiting. Instead
I was building a database on MySQL on NT.
I would like to move this to Linux asap. There are 6 tables with between 8
and 40
a client to do this for me (if so where do I get it and how
do I install over the daemon?) or is there another package which I should
install to replace the one which is running (how do I stop it without any
control?)
Sorry my first posting is such a bummer.
Regards
George Pitcher
Technical Manager
Assuming you are on windoze, try www.mysqlfront.de. I use it on my NT
laptop.
GP
- Original Message -
From: j.urban [EMAIL PROTECTED]
To: Neil Tompkins [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 3:08 PM
Subject: Re: mySQL Interface Programs
Check out urSQL
as
/var/lib/mysql
If all goes well then you should just be able to go
shell mysql
and off you go : )
This worked fine for me on red hat 7.1
cheers,
Paul
-Original Message-
From: George Pitcher [mailto:[EMAIL PROTECTED]]
Sent: 23 August 2001 14:52
To: [EMAIL PROTECTED
- Original Message -
From: [EMAIL PROTECTED]
To: George Pitcher [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 4:03 PM
Subject: Re: where should the mysql folder be?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
OK folks - I found it - tucked away in the /home/ folder.
GP
- Original Message -
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 23, 2001 3:59 PM
Subject: Re: where should the mysql folder be?
- Original Message -
From: [EMAIL PROTECTED
40 matches
Mail list logo