hi,
Is this the general enquiry list foe mysql
sorry to be a pain
yours
Ben (jmonkey)
:-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Try redoing from scratch but this time dont use a client
just use command line!
> yeah, i can access the database server normally with the client mysql.
> it works all right. the point is mysqladmin doesn't work.
>
> Thank u.
>
> On 9/7/05, 王静 <[EMAIL PROTECTED]> wrot
error:
$ ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax
to use near '' at line 1
could someone please shed some light on this, Maybe the answer is so obvious I
cant see it?
Thank
OMG,
Very sorry for my stupidness
I new it would be something stupid, it was cut and pasted from a website so I
dont have
to take all the blame as it should have just worked, aye...aye?
lol, thankyou very much
Ben
;-)
> Yes, you need to add a second close parenthesis at
Thankyou sheeri kritzer
You win an all expenses paid trip around David Launge :-)
hahaha
cheers
Ben
> OMG,
> Very sorry for my stupidness
> I new it would be something stupid, it was cut and pasted from a website so
> I dont have
> to take all the blame as it should h
wards.
am i missign something simple?
cheers,
.ben
-
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 &l
it should update
> trackinfo
> with the postcodes from newtrackinfo, as
> > long as the telephone numbers
> match - but i get an
> errror - it
> > complains about the 'FROM...' onwards.
> >
> > am i missign
> something
> simple?
> >
> >
/me uses mySQL-Front and PHPMyAdmin for all his Admin tasks
.b
> -Original Message-
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: 20 May 2002 15:45
> To: Todd Cary
> Cc: David Ayliffe; 'MYSQL-List (E-mail)'
> Subject: Re: Remote admin of MySQL from Win 2K
>
>
> It is asking
Can't your deployment package include all the required files? Visual Basic
does this nicely.
.b
--
ben joyce // [EMAIL PROTECTED] // +44 (0)7958 933718
Quoting Aaron <[EMAIL PROTECTED]>:
> I wrote an application that will be using MYSQL as the backend database.
> The
Dear MySQL,
Can you please tell me if there is a way of listing all child tables
which have a foreign key reference to a parent?
Therefore I can find and delete a child row, then delete the parent
without getting:
"a foreign key constraint fails"
Regards,
Ben Clewett
--
MyS
-+
| version() |
+-+
| 5.1.6-alpha-log |
+-+
But thanks, I think I can work with this and get the information I want.
Regards,
Ben.
Peter Brawley wrote:
Ben,:
Dear MySQL,
Can you please tell me if there is a way of listing all child tables
which have a foreign ke
Peter,
I see... I was thinking 'db' might have been a system table name or
something...
This works perfectly, thanks.
Ben
Peter Brawley wrote:
Ben Clewett wrote:
Unfortunately I get:
mysql> SELECT
->
c.table_schema,u.table_name,u.column_name,u.referenced_column_n
turns instantly without any delay and to all nested levels of RI.
How does MySQL do this? Is it possible to use MySQL to find out what it
thinks is the problem?
Regards,
Ben
Peter Brawley wrote:
Ben Clewett wrote:
Unfortunately I get:
mysql> SELECT
->
c.table_schema,u.tab
turns instantly without any delay and to all nested levels of RI.
How does MySQL do this? Is it possible to use MySQL to find out what it
thinks is the problem?
Regards,
Ben
Peter Brawley wrote:
Ben Clewett wrote:
Unfortunately I get:
mysql> SELECT
->
c.table_schema,u.tab
Uh, I don't have anything to add to this thread except that this was
the *exact* problem I was trying to solve and this really helped me a
lot. Thanks guys.
-BL
On 5/22/06, Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
> Hi,
>
> Greatly appreciated your kind help. Would it wor
thing else is much as default.
Can anybody help me?
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Logan, David (SST - Adelaide) wrote:
Hi Ben,
Try doing
SHOW ENGINES;
Here: (pertinent cols only)
++--+--+-++
| Engine | Support | Transactions | XA | Savepoints |
++--+--+-++
| CSV
27;ll give those a go
and see what happens...
Regards,
Ben.
Logan, David (SST - Adelaide) wrote:
Hi Ben,
I thought the InnoDB engine was included without having to set a
./configure option. On my latest build (admittedly a 5.0.18 one) InnoDB
was enabled without setting any ./configure o
interested!
Thanks for the advise,
Ben
gerald_clark wrote:
Ben Clewett wrote:
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usua
interested!
Thanks for the advise,
Ben
gerald_clark wrote:
Ben Clewett wrote:
Dear MySQL,
I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
InnoDB tables respected.
I have used the correct compilation flag (--with-innodb).
SHOW VARIABLES; lists all the usua
,
Dan Buettner wrote:
Ben, what does SHOW ENGINES show you? It should list all known storage
engines and indicate whether your MySQL install supports it or not.
Here's mine (5.0.21) for comparison; I was able to create a test table
as InnoDB and the SHOW CREATE showed it as InnoDB:
-&
Thanks for the excellent reference, this gives me a lot to go on.
My server is in bits at the moment, I'll let you know when it's up again!
Ben
Dan Buettner wrote:
Ben, looks like you've either got it disabled in my.cnf or with a
startup flag, or you've not set all th
Thanks for the tip.
Simple problem, my innodb data file was created with the default my.cnf.
When I started it with the large_table version, it used different innodb
table space size. Therefore would not start :)
Cheers,
Ben
Dan Buettner wrote:
Ben, looks like you've either g
or for worse we have always used RI, therefore have come to
expect this in our programs and administration tools. It's therefore an
absolute necessity.
May I ask if any member know whether this is planned, and if so, what
sort of time periods?
Thanks,
Ben.
--
MySQL General Mailing
Jimmy,
Thanks for the info. I'll look out for FK's in clustering and hopefully
we can do some testing at that time.
Regards,
Ben
Jimmy Guerrero wrote:
Hello,
We are aware that some user require FK's and would like to see them
supported in MySQL Cluster.
We are hopin
suggest MySQL accepts these values, at least for comparisons, a little
cleaner?
For what it's worth, and to help us C# coders...
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
QL giving the
warnings which crash MySql.Data.dll.
MySQL version 5.1.6
Just a suggestion for later versions of MySQL :)
Ben
Barry wrote:
Ben Clewett schrieb:
To whom it may concern,
I'm involved in lots of C# coding with several coders.
I have a gripe with MySQL which may be easy
developer on this list,
please remove this warning :)
Ben
Barry wrote:
Ben Clewett schrieb:
Hi Barry,
This will happen when comparing against a TIMESTAMP field.
CREATE TABLE a ( t TIMESTAMP );
SELECT * FROM a WHERE t > '0001-01-01 00:00:00';
Well my msql doesn't gi
not bad SQL.
- Because of the C# DateTime object, this happens often.
Therefore a candidate for dropping. Which will also avoid bugs in badly
written MySQL clients :)
But, I've probably said enough on the point :)
Ben
PS, another solution to our specific problem would be if the DATETIM
, this is bad SQL, time for a re-code!
I cannot replicate this. I did have a query where a time & date field
was compared to a date field which produced a warning, version 5.1.6.
(I know about warnings, they crash my programs!) So I'll have to leave
this point. I'll try and f
able 'Indian'??
I hope someone can tell me in a simple, clear way (minimum of commands, noth
ing fancy) how to do a full backup and a full restore (I don't need partials).
Thanks very much in advance.
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
something else??
Thank you,
Ben
At 16:53 2006/06/09 +0400, you wrote:
>
>
> Ben Burford wrote:
> > Hello,
> >
> > Do I need to delete the table 'Indian'??
>
> Try --add_drop-table option
> man mysqldump
>
>
> --
> MySQL Gen
warning: "Z_ASCII" redefined
In file included from azlib.h:34,
from azio.c:17:
/opt/freeware/include/zlib.h:175:1: warning: this is the location of the
previous definition
Are there any AIX experts who may have found/fixed this problem?
Any help would be wonderful!
Chris,
Previous version which did compile was 4.1.9. May be glibc was not
required for this version. Glibc is not native to AIX so I can see some
fun ahead.
Thanks, Regards,
Ben
Chris White wrote:
On Monday 24 July 2006 08:36 am, Ben Clewett wrote:
Making all in storage/archive
Lost connection to MySQL
server during query'
After which MySQL needs restarting.
I have executed the usual 'CHECK TABLE tax EXTENDED' and alike, which
results no errors.
Obviously this is quite worrying. Can any expert on InnoDB Referential
Integrity offer any clues?
Than
, the other
little-endium. So some RI reference in the InnoDB table space might be
garbage on the Pentium server.
Might this explain the crash?
Any thoughts would be very welcome!
Ben
Ben Clewett wrote:
Dear MySQL,
I am getting an unexpected crash in MySQL 5.1.6, with nothing written to
which causes complete failure of their product?
Is there anybody I can talk to about this? Anybody who has some advise
on how to stop MySQL crashing?
Or provide a small shell script to restart MySQL each time it crashes??
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives:
s WHERE components.name =
"nut"),
(SELECT components.id FROM components WHERE components.name =
"bolt");
}
But in the case of this query there are duplicates in the result. I
would like to use these duplicates to rank (I assume using ORDER BY)
the results
components.name IN("nut","bolt"))
GROUP BY listID
ORDER BY Occurrences DESC;
This ranks a set of lists based on the number of named parts the
contain in them. anyone either a) know how to rewrite this for
version < 4.1 or b) make it faster.
->Ben
On Aug
here may
be a better way to do the comparison that I am not thinking of):
SELECT id FROM t1 WHERE name LIKE ANY('%s1%', '%s2%', '%s3%', ...);
Does anyone know a way to do this?
Thanks,
->Ben
So possibly a better solution would be to create a temporary table
and then do a subquery on that table?
->Ben
On Sep 4, 2006, at 7:37 AM, Visolve DB Team wrote:
Hi
The ANY keyword, which must follow a comparison operator, means
"return TRUE if the comparison is TRUE for AN
documentation about how to control MySQL memory use.
Would some kind member help me find these?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
at
every incontinuity to try and work out if this is the reason.
Thanks for any help,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ng? I am confused...
Regards,
Ben
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote:
MySQL,
I am trying to upgrade from 4.1 to 5.1.
Your manual states I should run mysql_upgrade.
But there is no such
ng? I am confused...
Regards,
Ben
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the
Problem wrote:
On Mon, Oct 23, 2006 at 01:49:14PM +0100, Ben Clewett wrote:
MySQL,
I am trying to upgrade from 4.1 to 5.1.
Your manual states I should run mysql_upgrade.
But there is no such
the substring will only work as long as you don't have spaces in the first
and last name columns
'Billy Ray' Smith and John 'Von Hoenhiem' would cause problems
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 23, 2005 4:05 PM
To: Matt Babineau
Cc: m
table release?
If we upgraded to 5.0.1 now, is this stable for all the features in
4.1.9? So could we safely move now?
Kind regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
g to occur, why is it not 'release' now?
Sorry for my confusion,
Ben Clewett
Joerg Bruehe wrote:
Hi Ben!
Ben Clewett wrote:
[[...]]
Approximately when will 5.0.1 be available as stable release?
5.0.1 will never change, it is out (and obsolete by now).
You probably refer
Thanks for the detailed information, this is much clearer. I look
forward to 5.0.x becoming release.
Kind regards,
Ben Clewett.
Joerg Bruehe wrote:
Hi Ben, all!
Ben Clewett wrote ((re-ordered into posting sequence)):
Joerg Bruehe wrote:
Hi Ben!
Ben Clewett wrote
kill' will not cause MySQL to exit. Is there
any other know way to ask MySQL to exit cleanly?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s any other part of MySQL which uses DNS
lookups? For instance, logging of some kind?
Or any other reason a MySQL daemon would not respond to a kill?
Thank for the ideas,
Ben Clewett.
Jigal van Hemert wrote:
Ben Clewett wrote:
It had been suggested that our DNS failed prior to this even
If there is anybody who knows how to build a DNS clean MySQL, I would be
very interested in knowing.
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael,
Thank for the reference. This is useful.
Ben.
Michael Stassen wrote:
Ben Clewett wrote:
JamesDR wrote:
I noticed, on my Linux server, that MySQL makes a DNS lookup anyway.
Even if the IP is used or not. It normally digs on the PTR record. I
had all of my perms IP based, however
Hi,
I've noticed that connections are sometimes left open in MySQL when i use
the Show Processlist command. Does MySQL do any form of housekeeping to
close old connections or is it just down to the developers to make sure they
issue close connection statements?
Thanks.
==
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 10 August 2005 09:07
To: mysql@lists.mysql.com
Subject: Re: Cleanup of connections
Hi,
They appear to be in SLEEP state
Hello.
What state do MySQL threads of your old connections have?
Ben Smith <[EM
ected. If you want to debug this issue, please, provide information
about your operating system and MySQL version. If your
developers connect to MySQL through TCP/IP, check with netstat the state of
connections to MySQL port (usually 3306).
Ben Smith <[EMAIL PROTECTED]> wrote:
> They a
id, vendor
Each query giving a different result.
Regards
Ben.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 10 August 2005 23:29
To: mysql@lists.mysql.com
Subject: Re: HELP! sql command question for mysql
Hello.
I'm not sure about the speed of this quer
om: Scott Noyes [mailto:[EMAIL PROTECTED]
Sent: 11 August 2005 15:39
To: Ben Smith
Cc: mysql@lists.mysql.com
Subject: Re: HELP! sql command question for mysql
> It appears that you don't need to
> specify in the Group By clause all the columns that are referenced
> without an agg
anual
to elaborate on this problem. As far as I can see, this should work
perfectly.
Would any users be able to suggest a solution to this?
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GRANT syntax I use. Why would MySQL think my
client is from '0.0.0.0'?
Thanks in advance for any person who can offer a solution to these problems.
Ben Clewett wrote:
Dear MySQL,
A new installation of 4.1.9 on AIX 5. I have a GRANT that is not working.
Connecting from foreign serv
this problem may be
resolved?
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
have no problem.
Regards,
Ben Clewett.
Eric Bergen wrote:
MySQL 4.1.14 is the current version. You should always upgrade to the
lastest release and test your problem before trying to report bugs.
Ben Clewett wrote:
Dear MySQL,
My MySQL 4.1.9 has lost the ability to work out what IP
Any suggestions?
Regards,
Ben Wilson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Relational Database Design Clearly Explained, Second Edition
ISBN: 1558608206
The original edition was my first primer on relational databases. It was
an excellent read.
Ben
Maurice van Peursem wrote:
Hi,
I'm relatively new to the database-scene. I've installed MySQL on Mac
phpMyAdmin has the ability to export to XML format. If you take a look at
its code, you may see what command is used to dump to XML. Specifically, the
code for XML export is in /libraries/export/xml.php. May put you in the
right direction.
Ben
On 11/28/05, prathima rao <[EMAIL PROTECTED]>
ype of index I need.
This must be a common problem, is there any person who can help me?
Thanks in advance,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e ID's you need and select against them. Then sort the
data afterwards. Select a size of cell to suit most effective queries.
I will have to benchmark...
Thanks for the help,
Ben
Jigal van Hemert wrote:
Xiaobo Chen wrote:
Hi, all
I am trying to use this with error:
drop tempo
Sorry, subject corruption, my last email should have had this subject,
not 'temporary table issue'...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jigal,
Thanks, I'll give this a go...
Ben
Jigal van Hemert wrote:
Ben Clewett wrote:
But the index does not seem nearly as fast as liner (normal) indexes.
Hence using a less effective liner index may be better...
After this method I still need select a radius within these data
p
]
log-bin = ../logs/my-bin
I do have the new tables 'mysql.general_log' and 'mysql.slow_log' which
contain correct information.
Does any member have any advise on what may be going wrong?
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://list
In answer to my own question:
Why don't the binary logs write?
The '%-bin.index' file left over from previous version (4.1.9) had to be
deleted after the conversion to 5.1.6.
By deleting this file, the binary logs started to recreate.
I hope this is useful to somebody :)
Ben
I keep hacking at this but haven't been able to get it right yet.
I have two tables
Userinfo contains a login, User's Name, Group Name
Log contains login, host, datetime of last login
What I need to do is return user information (userinfo.name/groupname) of
users that have logged into
he host in question the information is
returned. This produces too many results as some of those users have since
migrated to a different access point.
-Original Message-
From: Andrew Wallo [mailto:theme...@microneil.com]
Sent: Tuesday, February 10, 2009 12:05 PM
To: Ben Wiechman
Subject: Re:
| Host | LoginTime | LogoutTime |
+--+--+-+-+
| 0010E70A8004 | 172.17.6.100 | 2009-02-09 09:16:24 | 2009-02-10 04:42:08 |
+--+--+-+-+
1 row in set (0.
Awesome... that works. Had to add a where clause to limit it to a specific
host.
The explain for that looks... interesting.
Thanks
-Original Message-
From: ddevaudre...@intellicare.com [mailto:ddevaudre...@intellicare.com]
Sent: Tuesday, February 10, 2009 12:47 PM
To: Ben Wiechman
Cc
Ben Wiechman
Network Administrator
Wisper High Speed Internet
Office: 866.394.7737
Direct: 320.256.0184
Cell: 320.247.3224
b...@wisper-wireless.com
> -Original Message-
> From: Gary Smith [mailto:g...@primeexalia.com]
> Sent: Friday, March 27, 2009 12:59 PM
> To: mysql@lis
Also ensure you issue: FLUSH PRIVILEGES; after making any changes to
permissions..
On 24 September 2012 20:09, Rick James wrote:
> That says that your password in not correct. You have not gotten to specific
> privileges.
>
> Did you previously do
> GRANT ... TO myuser@localhost IDENTFIED BY '.
s? Do any users know of a fix?
Thanks!
Ben Clewett.
Thread pointer: 0x7f6ea014cf90
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 410220e8 thread_stack 0x4
/usr/sbin/m
the advantage without the disadvantage. But this is a lot
of work to change every query we ever run!)
I am working on reproducing the error, but so far it appears to be random.
Ben
On 2012-10-09 18:44, Rick James wrote:
As for the crash, I don't know. Instead, I recommend either shri
SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
On 22 November 2012 15:01, Neil Tompkins wrote:
> Michael,
>
> Thanks this kind of works if I'm checking two types. But what about if I
> have 5 types ?
>
> On Thu, Nov 22, 2012 at 2:53 PM, Michael Dykman wrote:
>
>> response did not go t
BY id HAVING listid = 'x,y,z';
On 22 November 2012 15:10, Ben Mildren wrote:
> SELECT id FROM mytable WHERE type IN(x,y,z) GROUP BY id;
>
> On 22 November 2012 15:01, Neil Tompkins wrote:
>> Michael,
>>
>> Thanks this kind of works if I'm checking
*HAVING typelist = 'x,y,z';
On 22 November 2012 15:25, Ben Mildren wrote:
> Ah read it quickly and misread your requirement. Joins are likely FTW
> here. The alternative would be to do something like this, but I'd opt
> for the joins if you have a reasonably sized
Dear MySQL,
Using 5.1.56, I have experienced this core dump. Is there anybody out
there qualified to give an opinion on this?
Many thanks,
Ben Clewett.
Thread pointer: 0x7fd5280dbd90
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no
how processlist" and "show slave hosts" take a very long
time to update their status when the slave has gone.
Is there any way to have a refresh rate of about 10 seconds, as I did
on slave side ?
Thank you !
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
2015-06-18 22:52 GMT+02:00 shawn l.green :
>
> On 6/18/2015 2:10 PM, Ben RUBSON wrote:
>>
>> Hello,
>>
>> In order for the slave to quickly show a communication issue between
>> the master and the slave, I set slave_net_timeout to 10.
>> "show slave
2015-06-19 12:08 GMT+02:00 Ben RUBSON :
>
> 2015-06-18 22:52 GMT+02:00 shawn l.green :
>>
>> On 6/18/2015 2:10 PM, Ben RUBSON wrote:
>>>
>>> Hello,
>>>
>>> In order for the slave to quickly show a communication issue between
>>> the
x27;d like to insert a row into the second
with a set value.
I tried this but it is not working. I'm not very familiar with subqueries as
you can see.
insert into table_2 ( id, value ) values ( (select id from table_1), '1' );
Ben Wiechman
[EMAIL PROTECTED]
n 0; hex ; asc ;; 13: len 0; hex ;
asc ;; 14: SQL NULL; 15: len 4; hex 8000; asc ;; 16: len 4; hex
8001; asc ;; 17: len 1; hex 80; asc ;; 18: len 4; hex 64626d73;
asc dbms;; 19: len 1; hex 00; asc ;;
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archive
)
VALUES ( NULL , '35126600409511509' , '2007-12-18 23:59:58' ,
'5.150556400501e+01' , '-3.696216681689e-01' ,
'8.00016653e-02' , '1.0
Many thanks!
Ben Clewett.
--
MySQL General Mailing List
For list archive
way for minutes or hours, or until it is restarted.
This load cannot be accounted for by the processlist.
I need to know why MySql does this. If any person knows how I an
identify the problem, please let me know!
Thanks!
Ben Clewett.
# top
top - 08:19:50 up 5 days, 9:52, 1 user, load
= db.site
replicate_do_table = (etc)
Ben
Paul Berry wrote:
hey guys - is it possible to have a lightweight slave setup? so that you
only take X amount of tables from the DB
curious what good solutios are out there
--
MySQL General Mailing List
For list archives: http
ich are replication slaves and masters at the same time who
tend to do this 100% CPU thing for hours on end...
Kind regards,
Ben
Kevin Hunter wrote:
At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote:
I need to know why MySql does this. If any person knows how I an
identify the problem, plea
put the CPU load at 100%?
If four of my ten MySql servers are doing this regularly, I can't be the
only person with this problem. Can somebody from MySql please let me
know that on earth you are doing to my CPU's??
Regards,
Ben
BTW, who controls InnoDB? Is it Oracle or Sun?
ntial read and write.
If any members can suggest what might be appropriate, I would be
interested in knowing :)
Regards,
Ben Clewett.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ver-writing the 'mysql' database, restart MySql. If you have not
over-written this database, then you have lost your users and
permissions. But you should be able to log in as 'root' with no password.
Also check your error.log. Chances are this will tell you what is wrong :)
Try:
SELECT DISTINCT Colour FROM table;
Or, if you want to do it correctly:
SELECT Colour FROM table GROUP BY color;
Richard wrote:
Hello,
I don't know if it is possible to do this with mysql alone ...
Here goes :
I've got a database list which is like to following :
Num|Name|
# mysqldump --help
look for the flag --no-data
Ben
Esbach, Brandon wrote:
Is there any way to backup a complete database structure
(tables/fields/indexes/etc), without the data? Or even get a creation
script per table?
At present the only way I can think of is to restore a backup to
Try:
> mysql -u root -p
mysql> GRANT SUPER ON *.* TO myuser@'%';
mysql> GRANT SUPER ON *.* TO myuser@'localhost';
Andre Hübner wrote:
Hi List,
i wrote this alrready in mysql-forum a few days ago, but did not get any
answer. :(
i try to do backup with mysqldump from external host with
privileges for normal db-users.
rights should be limited to own db.
Thanks
Andre
- Original Message - From: "Ben Clewett" <[EMAIL PROTECTED]>
To: "Andre Hübner" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, February 20, 2008 9:46 AM
Subject: Re: external mysql
Cisco's Access Registrar supports MySQL 4.x. Does anyone have any experience
trying to make it work with MySQL Cluster?
Ben Wiechman
Network Admin
Wisper High Speed Internet
[EMAIL PROTECTED]
1 - 100 of 385 matches
Mail list logo
