Nick,
Wednesday, April 10, 2002, 7:27:20 PM, you wrote:
NP> I'm using Mysql 4.0.1 with query caching:
NP> set-variable = query_cache_limit=10M
NP> set-variable = query_cache_size=10M
NP> set-variable = query_cache_startup_type=1
NP> The Command:
NP> mysqldump -q -K -t --tab='.' \
NP> --fields-optionally-enclosed-by='"' \
NP> --fields-terminated-by=',' sched oweek
NP> The first execution of the command writes the expected
NP> data to oweek.txt.
NP> Any subsequent executions do not. This is because of query caching.
NP> I can run --> mysql -e "reset query cache" <-- which will enable
NP> the next call to mysqldump to write data.
NP> I believe that mysqldump should write data whether query caching
NP> is enabled/disabled or not-flushed/flushed.
Looks quite interesting, but can you please try to run that on MySQL
official binary release? As it seems that you have compiled MySQL from
source, and it's tricky to do that correctly.
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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 PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
