interval in
seconds).
- Geoffrey Sneddon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
PB
Much thanks, that's saved me… this time. :)
All the best,
Geoffrey Sneddon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ch be appreciated, as SQL like this really isn't
what I'm good at :)
- Geoffrey Sneddon
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, why was it
necessary to remove and recreate the link? Couldn't you just reset
whatever changed?
It completely changed /tmp. It made /tmp a folder in it's own right,
owned by geoffrey (me, admin) and staff.
I've had it change the perms before, but never physically de
On 21 Apr 2006, at 17:18, Geoffrey Sneddon wrote:
After the JS2E 5.0 Release 4 update on Mac OS 10.4.6 on the 19th,
MySQL 4.1.18 64-bit hasn't started. It begins to start up, before
ending with "ERROR!". Any possible reasons/solutions?
Managed to fix it: /tmp was broken.
After the JS2E 5.0 Release 4 update on Mac OS 10.4.6 on the 19th,
MySQL 4.1.18 64-bit hasn't started. It begins to start up, before
ending with "ERROR!". Any possible reasons/solutions?
- Geoffrey Sneddon
--
MySQL General Mailing List
For list archives: http://lists.mys
I posted a few days ago, but didn't get any responses. I'm hopeful someone
has seen this, and can offer advice.
We recently converted some tables from MyISAM to InnoDB because the need had
arisen for transactional support.
Things have been fine until recently, when the .frm files for these
We have been using MyISAM tables with MySQL merrily for about 18 months.
Recently we upgraded to MySQL 4.1, and even more recently, we converted some
of our MyISAM tables (which needed transactional support) to InnoDB.
After some configuration issues - the worst of which was the need to use a
s
Michael Stassen wrote:
>
> You would increase your chances of getting a useful answer if you would
> take
> the time to reformat your query to be easily readable, as I have done for
> you below.
>
> > SELECT Product.Product,
> >AssignedToAgent.AgentName AS AssignedTo,
> >sum(Inqu
lly qualify all column
> names in queries; if so, you should follow your shop standard ;-) More
> likely, you are probably using some sort of query generating tool in which
> case you probably don't have a choice in the matter.
>
> Rhino
>
>
>
> - Original Messag
I have an interesting problem that I cannot find any clues to in the MySQL
documentation. The following query works in 3.2.3, but does not work in
4.1.7:
SELECT `Product`.`Product`, `AssignedToAgent`.`AgentName` AS `AssignedTo`,
sum(`Inquiries`) AS `Inquiries` FROM `Inquiry` INNER JOIN `Produc
Dan, Heikki,
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 07, 2004 11:39 AM
Subject: Re: Memory Leak using InnoDB ?
> Geoffrey, Dan,
>
> - Original Message -
> From: "Dan N
Hi,
I'm running MySQL 4.0.17 with RH Linux 8 on Xeon 3.0/1GB RAM.
One application has to access the database (1 connection to the DB is open
on startup and left open). However this application performs a lot of
queries on the DB.
Main InnoDB table : 50.000 Rows
Other InnoDB tables (about 8) : Fr
ith the snapshot corresponding to the current
log file and offset:
shell> mysqladmin -uroot shutdown"
Regards.
Geoffrey
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
As far as I understand, setting innodb_flush_log_at_trx_commit to 0
could lead to several problems (data loss ?, ...).
Can you tell me more about it ?
Regards.
Geoffrey Dufour
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Absoulutely.
Since PHP is server-side you can write javascript dynamically on the fly
which are then executed client-side.
Here's a simple example:
var today = '';
> -Original Message-
> From: Steve Davies [mailto:[EMAIL PROTECTED]]
> Sent: Friday,
You might find this helpful - I did.
http://www.phpbuilder.com/columns/florian19991014.php3
>
> > Has anyone done any work with getting images into and out of a MYSQL
> > database? I have used mysql for some time, but never
> stored an image
> in a
> > blob field.
-
Bear in mind that I've never attempted a multilingual website,
but the first thought that I had when I read your post was to
have a table name extension that gets appended based on the
user's language choice/locale/whatever:
$langext = "_en";// english
// $langext = "_de"; // german
// $lan
PHP loop, but it works fine for now.
Thanks though - I'm sure I'll use your suggestion somewhere in the app I'm
working on.
Geoff
> -Original Message-
> From: Loren McDonald [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, January 25, 2003 1:41 PM
> To: Hoffman, Ge
I have an SQL query that LEFT JOINs four different tables to a main table,
based on several foreign keys.
It's returning only stories in a section that have photos,
but I need it to return all the stories in a section whether
it has a photo or not.
I think the problem is in the
WHERE evtphoto
number of bytes in a row? the max number of rows? what?
>
> It says that Access only supports 2025.
>
> 2025 what? rows in a table? bytes in a row?
>
> Thanks
>
> --
> ---
>
> Geoffrey Greene
I couldn't think of a better term for what I want to do...
I am building a CMS for news stories. Often news stories are related to each
other, or need to be grouped by content. I need a simple way to manage
storyId relationships - in both directions.
Thinking about the business logic to implemen
I've had great luck with both:
http://linuxwebhost.com and
http://onsmart.net
WS> From: Will Standley [mailto:[EMAIL PROTECTED]]
WS> Sent: Friday, January 17, 2003 7:45 AM
WS> Subject: --- Best ISP for MySQL & PHP ???
WS> I'm looking for an ISP to host a couple of MySQL db's...
WS> Will be usin
you are correct - subselects are NOT allowed until version 4
until then:
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 ON t1.id = t2.id
OR
SELECT t1.*
FROM table1 t1
LEFT JOIN t2 USING (id)
> -Original Message-
> From: Doug Beyer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, Janua
Use the mysqlc.exe client instead of mysql.exe
-- Geoff Morris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 7:28 AM
To: [EMAIL PROTECTED]
Subject: Error 1148 The error used Command is not allowed with this
MySQL -Version
Hello
heers,
Geoffrey
__
Geoffrey Soh, Software Architect
Ufinity - http://www.ufinity.com
Leading Enterprise Access Management Software!
9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210
Tel : +65 830-0341
Fax : +65 737
stions :
1. Does anyone know the behaviour of BDB recovery for such cases i.e. table
crashes, log sequence errors etc?
2. What happens to BDB tables on shutdown/startup i.e. is the transaction
log flushed etc?
Any comments welcome! Thanks.
Cheers,
Ge
thread_id=30
>
>
> Successfully dumped variables, if you ran with --log, take a look at the
> details of what thread 30 did to cause the crash. In some cases of really
> bad corruption, the values shown above may be invalid
>
> T
Next thing would be to work on another table, but this one is about 100+ GB
so it might take a while :)
Any comments?
Cheers,
Geoffrey
__
Geoffrey Soh, Software Architect
Ufinity - http://www.ufinity.com
Leading Enterprise Access Managem
the response.
Cheers,
Geoffrey
__
Geoffrey Soh, Software Architect
Ufinity - http://www.ufinity.com
Leading Enterprise Access Management Software!
9 Scotts Road, Pacific Plaza, #06-01, Singapore 228210
Tel : +65 830-0341
Fax : +65 737-0213
hunks and raid_chunksize set to e.g. 50 and
256?
Anyone out there tweaked these settings before and what was the outcome?
Thanks.
Cheers,
Geoffrey
__
Geoffrey Soh, Software Architect
Ufinity - http://www.ufinity.com
Leading Enterprise Access Man
resync the slave,
but the above error makes me concerned.
Any help appreciated. Thanks!
Cheers,
Geoffrey
__
Geoffrey Soh, Software Architect
Ufinity - http://www.ufinity.com
Leading Enterprise Access Management Software!
9 Scotts Road
ter is running a live 24x7
service hence cannot stop the master without affecting uptime)?
3. Related to (1), what's the best way to do recovery on BDB tables using
the MySQL binary logs + BDB table snapshot + BDB logs? I've read the manual
but could not find such info :)
Thank
Hi all,
I am a new user of mysql DB.
I am working with WN NT 4.
I already downloaded the mysql binary package for window.
I installed it.
But, now I don't know where to begin. How to start the DB.
Please, I would like to have some ways to begin.
Thanks,
Geo
34 matches
Mail list logo
