4.0.18-standard-log
I have a very basic one to many relationship, accounts and transactions.
There is only one account per users, but of course, there can be x
transactions. These are once a month charges for billing.
I need to be able to select all accounts where next_charge_date <= NOW()
That
Hi,
I've a large table with lots of floats (or doubles) that i want to query
using C API. By default, in C, the rows are returned as a type of char **,
therefore floating numbers are returned as ascii strings. Is it possible
to fetch somehow directly these numbers in their original binary
represe
Mine runs with warnings, not errors. it works just fine. However, this
is on CentOS 4.3. I've yet to get MySQL Query Browser to work under
CentOS 4.3, but that's a project for tonight.
Note however that MySQL Administrator and MySQL Query Browser are two
different things.
Oh, yes, I'm awa
Phil Robbins wrote:
I've read the notice AND tried to unsubscribe TWICE. I still get the
mail.
Did you get an unsubscription confirmation email? I'm not sure if the
mysql list sends one of these or not. If it does, you have to do what it
says in the confirmation before you are unsubscribed.
At 11:55 am +1200 26/5/06, Phil Robbins wrote:
>I've read the notice AND tried to unsubscribe TWICE. I still get the mail.
http://lists.mysql.com/troubleshoot.php
HTH,
James Harvard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mys
I've read the notice AND tried to unsubscribe TWICE. I still get the mail.
++
Phil Robbins
Auckland
New Zealand
++
_
Need more speed? Get Xtra Broadband @
http://jetstream.xtra.co.nz/chm/0,,202853
Gerald,
Thank you that worked. now I'm receiving this error:
dev:/tmp # /usr/local/mysql/bin/mysqldump -u root -p -h 192.168.45.7 --force
--all-databases > all.sql
Enter password:
/usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table
`help_category` (File
'/usr/local/src/mysql_curre
sheeri kritzer wrote:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Bgs wrote:
>
> No ideas?
>
> I tried playi
Paul Nowosielski wrote:
On Thursday 25 May 2006 12:09, you wrote:
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7
On Thursday 25 May 2006 12:09, you wrote:
> Paul Nowosielski wrote:
> >Dear all,
> >
> >I've been testing our backup and recovery strategies here at work.
> >When dumping all the databases I'm using this command:
> >
> >mysqldump --all-databases --force -u root -p -h 192.168.45.7 > all.sql
> >
>
Brian,
It depends on how you determine submission date. If you take it from
the header in the email client which receives the entry, it depends on
how your email client determines the date. You could bypass all this
variability by always inserting entries in the order in which they
arrive. But
Thanks Sheeri, but now I'm a bit more confused. Does that mean that the
scenario that I listed below does not work even if I use UTC_TIMESAMP?
That's what I still don't get, if someone on the east coast submits their
test, and the web code on my server (which is on the west coast) is what
actually
Paul Nowosielski wrote:
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 > all.sql
When this command is run I receive these error messages:
mysqldum
Dear all,
I've been testing our backup and recovery strategies here at work.
When dumping all the databases I'm using this command:
mysqldump --all-databases --force -u root -p -h 192.168.45.7 > all.sql
When this command is run I receive these error messages:
mysqldump: mysqldump: Couldn't exec
Hi Jay!
Writes make up about 17% of the queries, and we average 4000 queries/sec.
Querycache hit ratio is about 45% (QC seems to be a topic worth spending
some time for... 45% does not look so good).
We already tested replication, changing the database logic in the scripts to
use the slaves until
Dan Trainor wrote:
I'm curious as to what you guys use for benchmarking nowadays. I'd like
to benchmark preformance of an InnoDB database on a fancy new server,
compared to an old degraded one.
Hi Dan!
I use SysBench for most things, also MyBench for a few things (from
Jeremy Zawodny) as we
Greetings List,
I need some help understanding what is happening with the following
scenario I am going to explain. Please feel free to say RTFM and
point me to a link that can clear this up for me. I have searched
Google with all sorts of different keywords and haven't been able to
figure out
Moritz Möller wrote:
Hi Dan,
there are about 2GB free, so the net size would still be 32 GB.
The queries are really optimized, >99.9% of all queries can be satisfied
without table scans.
Well, I guess I have to give NDB a chance, I hope it will help. The only
alternative I come to is to cluste
If I remember correctly from the certification guide, MySQL opens a
file handle for each table opened. When you have a MyISAM table,
that's one file handle each for the structure, data and index files.
So if you have a query that uses only one table, it can spawn up to 3
file handles.and it's
What exactly is the performance problem you are seeing?
Have you checked to make sure all your memory is being utilized? ie,
not just grabbed by MySQL, but actually in use?
-Sheeri
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Moritz Möller wrote:
> Hi Dan,
>
> there are about 2GB free,
Brian,
MySQL's timestamp function is based on the *server*'s timestamp, not
the client's.
-Sheeri
On 5/24/06, Brian Menke <[EMAIL PROTECTED]> wrote:
Wow, if I read that right, it means someone on the East coast submits
answers to a test, it's somehow adjusted to be the same as someone who
subm
Why not? You can run a script that has 1 command, to source another
SQL file, and then your script will not die because of errors. What
else is going on under the scenes here, to make it so you "can't" do
it?
source'ing the script is NOT forcing. When you use mysql < file.sql,
if there's an er
What does
mysql-workbench --sync
give you?
-Sheeri
On 5/25/06, Gregory Machin <[EMAIL PROTECTED]> wrote:
I get the following when I try and lauch mysql-workbench .
[EMAIL PROTECTED] ~]$ mysql-workbench
The program 'mysql-workbench-bin' received an X Window System error.
This probably reflects
You should just be doing
mysqlhotcopy ...connect-options... --regexp /~^db_name$/
or
mysqlhotcopy ...connect-options... --regexp /~^db_name$/ /path/to/new/dir
On 5/25/06, MF <[EMAIL PROTECTED]> wrote:
Hi, how to write pattern for backup all datases except one?
I try this, but not work as exp
Hi, how to write pattern for backup all datases except one?
I try this, but not work as expecting.
mysqlhotcopy ...connect-options... --regexp /~^db_name$/./.*/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
Thank you Duncan.
I get the following when I try and lauch mysql-workbench .
[EMAIL PROTECTED] ~]$ mysql-workbench
The program 'mysql-workbench-bin' received an X Window System error.
This probably reflects a bug in the program.
The error was 'BadMatch (invalid parameter attributes)'.
(Details: serial 749 error_co
Nope... pure myisam...
sheeri kritzer wrote:
yeah, I'd be willing to guess that you're mostly innodb. LOAD DATA
FROM MASTER only works for MYISAM.
http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html
-Sheeri
On 5/24/06, Dan Trainor <[EMAIL PROTECTED]> wrote:
Bgs wrote:
>
> No
On Thursday 25 May 2006 12:02, balaraju mandala wrote:
> Hello All,
>
> I need some explanations about these files.
>
> 1. ibdata1
> 2. ib_logfile0
> 3. localhost-bin.index
> 4. localhost-relay-bin.01
> 5. master.info
> 6. relay-log.info
http://dev.mysql.com/doc/refman/5.0/en/innodb-configurat
Hello All,
I need some explanations about these files.
1. ibdata1
2. ib_logfile0
3. localhost-bin.index
4. localhost-relay-bin.01
5. master.info
6. relay-log.info
is these are standard names. I mean these file names are reserved for mysql?
and can be found, where mysql installed.
regards,
30 matches
Mail list logo
