Any one tried the script from HowToForge
http://www.howtoforge.com/shell-script-to-back-up-all-mysql-databases-each-table-in-an-individual-file-and-upload-to-remote-ftp
#!/bin/sh
# System + MySQL backup script
# Copyright (c) 2008 Marchost
# This script is licensed under GNU GPL version 2.0 or
Hi Rob,
Thanks for getting back to me on this. You were right on the money with the
imposed quota on that directory, I tried copying some large files across to
the folder and found it limited to 8Mb for some reason, I'll look into
removing that limit.
One thing which is puzzling me at the moment
you can make mysql to use memory for creating temp files rather than disk
set sort_buffer_size=1024*1024*100;
and try your query.
Also the size of the columns is based on the db engine ur using, i dont
remember the exact number, i will denfinitly find it in mysql docs.
regards
anandkl
On
Hi list,
Aborted clients and connects are increasing very fast.
Aborted_clients
4934 Aborted_connects
5034 connect_timeout 10
wait_timeout 28800
Please tell me how to fix this problem.
--
Krishna Chandra Prajapati
MySQL DBA,
Mob: 9912924044
Email-id: [EMAIL PROTECTED]
I have a server that runs only MySQL. It services several other servers
inside a firewalled intranet. All connections to the MySQL database are
done using static IP addresses.
Recently I had to start monitoring the firewall traffic on this
intranet, and discovered the MySQL server is
Heston,
What happens if you remove the Order By clause from the query?
Does the file size drop? Also why are you using LIMIT 1, 699? The 1
skips the first row because that is the offset. If you just want the first
700 rows then use Limit 700
Mike
At 06:29 AM 10/22/2008, you wrote:
Hi
hi all...
i had a weired thing happened
is it possible for a user privileges to expire?!
suddenly today an application stopped working and i was getting the
message that the user can't login.
now, i did mess with it last night trying to give it file privileges but
since i would have
[EMAIL PROTECTED] wrote:
Point to an internal dns server
We don't have one.
Is somebody with a weird hostname connecting to your server via ssh ?
Nope. This is occurring while the server's intranet is totally unmanned.
-Richard
--Original Message--
From: Richard S.
Hi Guys,
I'm trying to sort by a particular order:
SELECT * FROM tablename
WHERE id='5' OR id='9' OR id='25' OR id='34'
ORDER BY id(5, 34, 9, 25)
Can anyone tell me the proper syntax to accomplish this task?
Thanks for your help.
Keith
ORDER BY id(5, 34, 9, 25)
Can anyone tell me the proper syntax to accomplish this task?
ORDER BY FIELD( id, 5, 34, 9, 25 )
PB
-
Keith Spiller wrote:
Hi Guys,
I'm trying to sort by a particular order:
SELECT * FROM tablename
WHERE id='5' OR id='9' OR id='25' OR id='34'
ORDER BY id(5,
On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods
[EMAIL PROTECTED] wrote:
Recently I had to start monitoring the firewall traffic on this intranet,
and discovered the MySQL server is routinely sending queries to the main DNS
server (outside the firewall). I suspect the server is performing
Awesome! Thanks very much - exactly what I was looking for. I'm in the
field and was under the gun, otherwise would have checked the manuals first.
Again, thanks.
-Richard
Hassan Schroeder wrote:
On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods
[EMAIL PROTECTED] wrote:
Recently I
2008/10/21 Moon's Father [EMAIL PROTECTED]:
Could you please give me an idea of how to manage the privileges inside
mysql?
http://www.google.co.uk/search?q=mysql+grant
first hit :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm not familiar with order by field (unless field is a UDF). I know of
order by binary. Is this standard mysql syntax?
On Wed, Oct 22, 2008 at 10:42 AM, Peter Brawley [EMAIL PROTECTED]
wrote:
ORDER BY id(5, 34, 9, 25)
Can anyone tell me the proper syntax to accomplish this task?
ORDER
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_field
it is
ORDER BY ...
and in this case the ... is the function described above.
On Wed, Oct 22, 2008 at 12:24 PM, Jim Lyons [EMAIL PROTECTED] wrote:
I'm not familiar with order by field (unless field is a UDF). I know of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Keith Spiller schrieb:
Hi Guys,
I'm trying to sort by a particular order:
SELECT * FROM tablename
WHERE id='5' OR id='9' OR id='25' OR id='34'
what about ... WHERE id in (5, 9, 25, 34) ...
ORDER BY id(5, 34, 9, 25)
like the others said
The next issue of MySQL Magazine has been uploaded to the website at
http://www.mysqlzine.net. It is a free pdf magazine about MySQL
administration and development. Download it while it's hot!
thanks,
Keith
--
Editor
MySQL Magazine
http://www.mysqlzine.net
--
MySQL General Mailing List
For
17 matches
Mail list logo