Hi.
On Friday 18 May 2012 18:21:07 Daevid Vincent wrote:
> Actually, I may have figured it out. Is there a better way to do this?
I don't see why you need the dvds table when the dvd_id is in the scene table:
SELECT a.dvd_id
FROM scenes_list a, moviefiles b
WHERE a.scene_id = b.scene_id
AND
Hi.
On Thursday 10 Mar 2011 at 20:09 mos wrote:
[snip]
> Let's say I have a Document_Id column and the url is
> www.mydocuments.com/public?docid=4
> to retrieve document_id=4, I don't want someone to write a program to
> retrieve all of my public documents and download them. I want them to go
>
Gavin Towey wrote:
There are scripts out there such at the Maatkit mk-parallel-dump/restore that
can speed up this process by running in parallel.
However if you're doing this every week on that large of a dataset, I'd just
use filesystem snapshots. You're backup/restore would then only take
Hi all,
I've got a fairly large set of databases I'm backing up each Friday. The
dump takes about 12.5h to finish, generating a ~172 GB file. When I try
to load it though, *after* manually dumping the old databases, it takes
1.5~2 days to load the same databases. I am guessing this is, at leas
Consider a wiki that lets you edit rows in a db table. Each page is a
row in the table, and has fields that anyone can edit. Like all wikis,
it keeps a history of edits (including who made the edits), and lets
you revert an edit, or even delete a row (page) completely.
Has anyone implemented somet
Many sites let you search databases of information, but the search
queries are very limited.
I'm creating a site that'll allow arbitrary SQL queries to my data (I
realize I'll need to handle injection attacks).
Are there other viable ways to query data? I read a little on
"Business System 12" (BS
I have a directed graph (nodes and edges) that I want to store
"efficiently": given two nodes, I want to quickly find the shortest
path between them. The graph is NOT acyclic (it's not a tree), is
fairly "sparse" (about 1 edges for 2500 nodes), and changes
occasionally.
I know PostgreSQL/MySQL
Hi
Is there any way to restrict access to the tcp port on mysql. I only
want my 5 class C's to be able to access the port but it is a public
server.
Any help would be greatly appreciated.
Kelly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
Hi.
On Wednesday 08 August 2007 18:39, Jason Pruim wrote:
> Did some more testing, made a new table and matched the field names,
> now it will load it without any errors, it's just only importing the
> first row... Not the rest of the 934 records...
You are using ENCLOSED BY '"' in your SQL, whic
Hi.
On Thursday 05 July 2007 17:35, you wrote:
> > I want to delete from the 'Item' table
> > all the items identified by the folowing query:
>
> If you have MySQL 5+, you can do it using a sub-query:
>
> DELETE FROM
> Item
> WHERE
> ProductID IN (
> SELECT
> Item.ProductID
> FROM
> It
Hi
I want to delete from the 'Item' table all the items identified by the
folowing query:
SELECT
Item.ProductID
FROM
Item, ItemTag
WHERE
ItemTag.TagID = '168'
AND
ItemTag.ItemID = Item.ProductID;
but I'm not sure how to go about it. Can anyone help?
Thanks
Mark
--
My
Keith,
The definitive way is to turn on the query log and watch it for a few days
or weeks.
In your my.cnf under [mysqld] add the line:
log=mysql-query
Then restart your server.
In your server's data directory (e.g. /usr/local/mysql/data/), there will
now be a log file called mysql-query.log.
Apologies for the mass cross-posting: I haven't been able to find a single
answer or reference for the problem below (googling didn't help), and
was hoping someone could point me to something helpful. I'm convinced
there's a well-known answer here that I just can't find :(
We're modeling a collec
In PostgreSQL, the following SELECT statement will return all the
columns for 'tabname':
SELECT x.attname FROM pg_attribute x, pg_class y WHERE
x.attrelid=y.oid AND relname='tabname';
Does MySQL have anything similar?
I know about "SHOW COLUMNS FROM tabname", but am looking for something
more S
I have some data in a regular MySQL table called usplaces:
city |state|country|latitude |longitude |population|comments
-+-+---+-+---+--+
New York |NY |USA|40.704234| -73.917927|8008278 |Big Apple
Chicago |IL |USA
o try...
Kelly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bind-address=127.0.0.1
datadir=//SOFTWOODSERVER/SharedDocs/mydata/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#set-variable=max_allowed_packet=3M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=PTurk
password=password
I have three tables (x, y, and z) with the same 3 fields (id, name,
number). If I do:
SELECT * FROM x, y, z WHERE ...
each row of my result will contain 3 id fields, 3 name fields, and 3
number fields.
Of course, I can/should do:
SELECT x.id AS x_id, x.name AS x_name, x.number AS x_number,
erent ownership.
The group owner is different. Any ideas? Thanks,
Kelly
Script:
#!/bin/sh
date=`date -I`
sudo su -
mkdir /usr/local/mysql/bakups/$date
chown root.mysql /usr/local/mysql/bakups/$date
chmod 770 /usr/local/mysql/bakups/$date
/usr/local/mysql/bin/mysqldump --tab=/usr/local/mysql/bakups/
=mysqlhotcopy",
"backup_user", "backup_password",
then, just to be sure,
chown root.nobody mysqlhotcopy
chmod 700 mysqlhotcopy
Any ideas would be greatly appreciated. I would really like to add this
to a cronjob to have it run automatically. Tha
Good good.
On 24 Feb 2005, at 20:46, [EMAIL PROTECTED] wrote:
BINGO!!!
Thanks Dan!
Kelly
Daniel Walker <[EMAIL PROTECTED]>
What version of MySQL are you using? 4.1.1 uses an enhanced password
hashing system that isn't compatible with clients built for older
versions.
T
this MySQL server
What do I need to do to allow the host to connect? Thanks,
Kelly
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
1300 Elmwood Avenue
Buffalo, NY 14222
http://www.itec.suny.edu
Main: 716-878-4832
Fax: 716-878-3485
Office: 716-878-3984
Cell: 716-432-4
Thanks guys! I did follow the procedure, but somewhere during the first
and second attempt I mucked it up. Followed the directions slowly and
carefully a third time and we are up and running. Thanks for your help!
Kelly
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
ollab/mysql-4.1.10/sql/mysqld
What do I need to do to make it start properly? Thanks in advance!
Kelly S. Brace
Information Technology Exchange Center
Twin Rise 200
1300 Elmwood Avenue
Buffalo, NY 14222
http://www.itec.suny.edu
Main: 716-878-4832
Fax: 716-878-3485
Office: 716-878-3984
Cell: 716-432-4978
[EMAIL PROTECTED]
I have a table of full URLs and IPs and am using the following query to return
distinct web requests by domain. Using SUBSTRING_INDEX it only returns the
domain part of the URL:
SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct ip) as count
from tablename WHERE SUBSTRING_INDEX(url, '
: > -Original Message-
: > From: John Kelly [mailto:[EMAIL PROTECTED]
: > Sent: Tuesday, October 21, 2003 3:45 PM
: > To: [EMAIL PROTECTED]
: > Cc: [EMAIL PROTECTED]
: > Subject: Re: Need help constructing query ...
: >
: >
: > - Original Message -
: >
- Original Message -
From: "Daniel Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 21, 2003 2:33 PM
Subject: Re: Need help constructing query ...
: > Hi, I have a table full of logged urls and ip addresses. The following
: > query returns
Hi, I have a table full of logged urls and ip addresses. The following query
returns all the urls and the number of requests. How would I modify it to return
unique requests based on distinct ip addresses?
select url, count(*) as pageviews from table group by url order by pageviews
desc
--
MySQ
Richard Dice is a friend of mine, and has done a wonderful
tutorial on "Choosing the right database system" that I found
marvelous, at webmonkey:
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
Regards,
Kelly Black
Sprint PCS
Performance Engineering
Just run mysql in it's own little "jail"
with --user=mysql # or some username you add to the tables...
Regards,
Kelly Black
-Original Message-
From: Dimitar Haralanov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 4:18 PM
To: [EMAIL PROTECTED]
Subjec
Don
This is more help than I ever anticipated, and
I certainly thank you very much. Let me digest / re-program
this. If there's anything I can do you for, just let
me know.
Thanks lots!
Regards,
Kelly W. Black
Linux was very clearly the answer, but what was the question
Also you can do
mysql -u userid -p -h hostname dbname < /path/to/your/script.sql
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Anderson Pereira Ataides [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 5:37
Usually there's a little more administrative work to limiting
usage...but it's up to you.
Regards,
~KB
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 2:38 PM
To: Black, Kelly W [PCS]; 'Dimitar Haralanov'; [EMAIL PR
I think this might do what you want, but then you will be required to log
in with the -p syntax...
GRANT SELECT on *.* TO yourlogin@'%' IDENTIFIED BY "somepassword";
FLUSH PRIVILEGES;
mysql -u youruserid -p -h hostname dbasename
Regards,
Kelly Black
Linux was very clearly
idn't know about
the sum *before* the distinction...
Thanks guys, I will try these and see if I can fix it.
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Serge Paquin [mailto:[EMAIL PROTECTED]
Sent: Wednesday
.
Thanks for your help.
Regards,
Kelly W. Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 8:30 PM
To: Black, Kelly W [PCS]
Cc: Mysql (E-mail)
Subject: RE: sum() usi
You guys probably need to start mysql with the --skip-grant option
and fix the allow tables...
See the mysql.com website or google.com for "lost password" "mysql"
-Original Message-
From: Chee-Wai Yeung [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 5:09 PM
To: [EMAIL PROTECTED]
]
Sent: Tuesday, March 25, 2003 4:13 PM
To: Black, Kelly W [PCS]
Subject: Re: mysql install---help please
I typed in
/usr/local/mysql/bin/mysql -u userid -p -h localhost password:
prompted for password, gave only one I ever use
response was
ERROR 1045: Access denied for user: '[EMAIL PROT
Try
/usr/local/mysql/bin/mysql -u userid -p -h hostname
password:
mysql>
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 3:16 PM
To: kather
Try using
GRANT ALL ON Security.* TO newbuddy@'%' INDENTIFIED BY 'password';
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
-Original Message-
From: Terrance Win [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003
s, as so:
mysql> CREATE TABLE clean_pcf AS SELECT DISTINCT * FROM pcf where release =
curdate()-1;
Query OK, 2438 rows affected (0.11 sec)
Records: 2438 Duplicates: 0 Warnings: 0
mysql>
Any ideas on how I can get rid of the bug wars???
Regards,
Kelly Black
Linux was very clearly the ans
o ignore specified fields? I will be
using a LOAD file to contain the load parameters and that the field
options are top to bottom for fields left to right.
**When I come to a field I want mysql to ignore do I just use this
parameter?
IGNORE
jim kelly
---
Cute.
sql, query
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql-help@;lists.mysql.com]
Sent: Thursday, November 14, 2002 6:38 AM
To: Black, Kelly W [PCS]
Subject: confirm unsubscribe from [EMAIL PROTECTED]
Hi! This is the ezmlm program. I'm managing the
[
If you ran into any problems it would probably
be RAM. RAM is cheap so if you have trouble...just
pop a couple of 512MB chips in it.
~KB
-Original Message-
From: Jeremy Zawodny [mailto:Jeremy@;Zawodny.com]
Sent: Wednesday, November 13, 2002 11:12 AM
To: Devore, Jacob
Cc: '[EMAIL PROTECTE
You might need to use rpm -e to uninstall previous version first.
Check the documentation.
~Kelly W. Black
-Original Message-
From: Rick Root [mailto:rroot@;wakeinternet.com]
Sent: Wednesday, November 13, 2002 10:47 AM
To: mysql
Subject: Upgrading MySQL from 3.23.41 to 3.23.53a
I
Did you remember to allow backwards compatibility in @INC
for perl 5.6.1?
~K Black
-Original Message-
From: Octavian Rasnita [mailto:orasnita@;home.ro]
Sent: Wednesday, November 13, 2002 2:58 AM
To: MySQL List
Subject: Using MySQL with Perl 5.8?
Hi all,
I was able to install the modul
27.0.0.1 localdomain.localhost localhost
~Kelly W. Black
-Original Message-
From: Phil Iovino [mailto:phil@;nxtek.net]
Sent: Wednesday, November 13, 2002 10:36 AM
To: 'Paul DuBois'; Black, Kelly W [PCS]; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installation Help
It doesn't appear this part is valid sql, query
DATA_DIRECTORY="/tmp";
~K Black
-Original Message-
From: Yuyi Guo [mailto:yuyi@;fnal.gov]
Sent: Wednesday, November 13, 2002 9:21 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: create table w/ data/index directory
Hi,
I am usin
Right.
My mistake.
I think you get the general idea.
~K Black
-Original Message-
From: Paul DuBois [mailto:paul@;snake.net]
Sent: Tuesday, November 12, 2002 4:21 PM
To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin'
Cc: [EMAIL PROTECTED]
Subject: RE: Installa
Get on out there with your bad self Michael !!
:)
~KB
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Tuesday, November 12, 2002 3:23 PM
To: David Kramer
Cc: '[EMAIL PROTECTED]'
Subject: Re: Why does safe_mysqld runs as root?
David Kramer wrote:
>By
Check if mysqld or some other process uses all
available memory. If not you may have to use
'ulimit' to allow mysqld to use more memory
or you can add more swap space",
If it persists, use vmstat 1
~Kelly W Black
-Original Message-
From: Jeremy Zawodny [mailto:Jere
See the file INSTALL_BINARY
~KB
-Original Message-
From: Pierre [mailto:pierre@;epinetworx.com]
Sent: Tuesday, November 12, 2002 1:45 AM
To: [EMAIL PROTECTED]
Subject: Problem compiling mysqlgui 1.7.5
Hi,
I try to compile mysqlgui-src-1.7.5 on my GNU/Linux system with gcc-3.2
but with
Make sure you issued the correct GRANT statements
at the sql, query.
mysql>use mysql;
Database Changed
mysql> GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';
#note that will give FULL access...see the docs to restrict this.
mysql> FLUSH PRIVILEGE
Don't re-install.. Fix the problem
Try issuing
shell>cd /usr/local/mysqlversion
shell>./configure
~K Black
-Original Message-
From: mod_perl [mailto:shine_perl@;spectrum.net.in]
Sent: Monday, November 11, 2002 10:23 PM
To: [EMAIL PROTECTED]
Subject: unable to start mysql
hi all,
when
Make sure when you are creating the database that
U_Number | int(9) unsigned | | PRI | NULL
is
U_Number | numeric() | | PRI | NULL
-Original Message-
From: Petre Agenbag [mailto:internet@;boesmanland.com]
Sent: Tuesday, November 12, 2002 4:27 AM
To: [E
You don't have a compiler installed? Hmmm. This seems tough to
believe.
Try issuing 'which cc'
~K Black
-Original Message-
From: leaddog1 [mailto:jsobeck@;lead-dog.net]
Sent: Tuesday, November 12, 2002 6:44 AM
To: [EMAIL PROTECTED]
Subject: Solaris 2.6
Is there any version of MySQL wi
Make sure some previous version of MySql isn't running.
I have seen this on systems which had the OS installed version
of MySql, and I had to issue
shell> /sbin/service mysql stop
shell> cd /usr/local/mysqlversion
shell> ./bin/mysqld_safe -user=theuserid
Hope this helps...
~
I have been using the MySql 4.x MAX with absolutely
NO problems. It's being used on heavily operated servers,
and I upgraded to 4.x for it's incredible index speeds and
it's VERY reliable to me.
In fact, in our local benchmarks it's kicking the living crap out
of Oracle on sq
Michael I have a nice perl program I wrote that I use to dump
from MySql to a tab delimited ASCII file. I would
pass it along if you think it would help...
~Kelly W. Black
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Monday, November 11, 2002 2:38
.
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary@;wiley.com]
Sent: Monday, November 11, 2002 1:48 PM
To: Adolfo Bello
Cc: Black, Kelly W [PCS]; Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
There is a cleanup script run via cron that removes files from
XFS is X server Font Server, and is unrelated.
~Kelly W. Black
-Original Message-
From: David Kramer [mailto:DKramer@;reflect.com]
Sent: Monday, November 11, 2002 1:51 PM
To: [EMAIL PROTECTED]
Subject: Mysql starts under XFS on boot up???
I noticed that Mysql starts up under XFS, Im
mysql.sock /tmp/mysql.sock
and things seem to work fine.
~K Black
-Original Message-
From: Adolfo Bello [mailto:adolfobello@;bisapi.com]
Sent: Monday, November 11, 2002 1:32 PM
To: Black, Kelly W [PCS]
Cc: Mysql Lists
Subject: RE: /tmp/mysql.sock question (newbie)
I am also a newbi
Can you post about 30 seconds worth of
the vmstat 1 command when the system
is busy?
Thanks
~Kelly W. Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:kahnmatt@;engin.umich.edu]
Sent: Monday, November 11, 2002 11:09 AM
To: [EMAIL PROTECTED]
Subject: Commands out of sync
Hi
You can do this in /etc/my.cnf
~K Black
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary@;wiley.com]
Sent: Monday, November 11, 2002 10:05 AM
To: [EMAIL PROTECTED]
Subject: /tmp/mysql.sock question (newbie)
Hello all, I would like to change where the /tmp/mysql.sock file get
wanted to be within the bounds of 'good reading'.
Thanks!
Regards,
Kelly Black
Sprint PCS
18200 Von Karman
Irvine, Ca. 92612
949-623-5417
Linux was very clearly the answer, but what was the question again?
-
Befo
tp'
'--with-imap-ssl=/usr/home/colossus/pine4.33/imap'
'--with-jpeg-dir=/usr/lib' '--with-zlib' '--with-openssl=/usr/local/ssl'
'--with-png-dir=/usr/lib' '--enable-magic-quotes=yes'
'--enable-memory-limit' '--enable-trac
Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the
server package, but MySql.com has it in the client's:
$ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin
/usr/bin/mysqladmin
/usr/share/man/man1/mysqladmin.1.gz
sql, query
~Kelly W. Black
PS IN the future
Mysqladmin is seperate rpm
~K Black
-Original Message-
From: SpyProductions Support Team [mailto:support@;spyproductions.com]
Sent: Friday, November 08, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: MysQL Installation
I just installed the most recent version of MySQL with an RPM (throug
127.0.0.1 localhost
Oh and I have to say this for the list-> sql, query
~Kelly W. Black
-Original Message-
From: Mertens Bram [mailto:bram-mertens@;linux.be]
Sent: Friday, November 08, 2002 9:55 AM
To: mysql mailing list
Subject: Re: Error connecting to Mysql via Apache/PHP - Access
Make sure /etc/hosts has this line
127.0.0.1 localhost
~Kelly W. Black
-Original Message-
From: Kevin Passey [mailto:kpassey@;kdpsoftware.co.uk]
Sent: Thursday, November 07, 2002 4:38 AM
To: 'Timothy Venn'; Mysql (E-mail)
Subject: RE: Host not allowed to connect problem
This is incorrect.
!google "new line character" linux windows
-Original Message-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 11:33 AM
To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: Re: Problem importing
I have seen this when Windows was involved.
Windows word and note pads have a different new
line character than Un*x type systems.
Perhaps that's what's foiling the sql query.
~K Black
-Original Message-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 10
Try using dashes.
-mm-dd
-Original Message-
From: Andrew Sitnikov [mailto:sitnikov@;infonet.ee]
Sent: Wednesday, November 06, 2002 9:39 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: DateTime comparation problems
Hello bugs,
SELECT ... FROM table o WHERE o.date >= 20020901
Also see
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht
ml
It helped me a lot here...
sql query by the man
~Kelly W. Black
-Original Message-
From: Daniel Kasak [mailto:dkasak@;nusconsulting.com.au]
Sent: Tuesday, November 05, 2002 2:49 PM
To: Alain
rsor";
while ( <> ) { # your data is fed into the program via STDIN
my @data=split;
$cursor->execute(@data);
}
$cursor->finish;
$dbh->disconnect();
The question marks are replaced by real data on the fly from STDIN.
Thanks to Richard Dice for this interesting wrinkle
So use the C syntx instead.
:)
-Original Message-
From: Steven Webb [mailto:scumola@;yahoo.com]
Sent: Tuesday, November 05, 2002 12:21 PM
To: Black, Kelly W [PCS]; Mysql list
Subject: RE: using libmysqld - can't connect to remote DB as client.
Ok, but I'm writing this in C
I have had problems with this kind of statement:
date = DATE
Try
date = 'DATE'
or even
date =curdate();
Note you can subtract
date = curdate()-1;
I have encountered no problems with upper/lower case in Linux
and Mysql.
~Kelly W. Black
-Original Message-
From:
ie "can't connect: $DBI::errstr\n";
as in this way you can get some useful error output about the connect.
Not certain but at least I am trying to help :)
Oh and don't forget sql query! :)
~Kelly W. Black
-Original Message-
From: Steven Webb [mailto:scumola@;yahoo.
g sleep within the Perl program.
Perform query.
sleep 10;
perform query.
sleep 10;
Hope this helps,
~Kelly W. Black
-Original Message-
From: heath boutwell [mailto:heathboutwell@;yahoo.com]
Sent: Tuesday, November 05, 2002 7:19 AM
To: [EMAIL PROTECTED]
Subject: RE: Thread Thrashing and 3.
Make sure you use the complete line of syntax
mysqladmin -u username -p -h hostname create databasename
password: (enter the password to that userid here)
Oh yeah sql query .
~Kelly W. Black
-Original Message-
From: john [mailto:john@;cllug.org]
Sent: Monday, November 04, 2002 3:53
Try using
shell>mysqladmin -u root -p -h hostname databasetobecreated
password:
~Kelly W. Black
-Original Message-
From: Admin-Stress [mailto:meerkapot@;yahoo.com]
Sent: Monday, November 04, 2002 2:41 PM
To: [EMAIL PROTECTED]
Subject: newbie: creating database error
After play
Thanks!!!
I appreciate all the help I can get.
I am trying to validate what appears to be a working query, and will
post back to the list as soon as I can confirm it works.
I think many others will benefit from my working this out..
Thanks again and all my best!
~Kelly W. Black
-Original
Try using
mysql>show variables;
Some variables can be exported to the sql server via the environment table.
For example:
shell>ulimit=2046
shell>export ulimit
shell>mysqld restart
Hope this helps,
~Kelly W. Black
-Original Message-
From: Nissim Lugasy [mailto:lugasy@;l
This simply returns me to the documentation.
Thanks
-Original Message-
From: James Northcott [mailto:jnorthcott@;dpmg.com]
Sent: Monday, November 04, 2002 12:13 PM
To: Mysql (E-mail)
Subject: RE: Interesting Challenge
> mysql> SELECT cell, sector,
If you only want one row, then sel
More appropriately, use curdate()feature from within sql.
select * where date= < curdate()-1;
for example
~Kelly W. Black
-Original Message-
From: Benjamin Pflugmann [mailto:benjamin-mysql@;pflugmann.de]
Sent: Monday, November 04, 2002 1:06 PM
To: Jim Hogan
Cc: [EMAIL PROTEC
You might also need to add hostname.
It depends on what GRANT sql statement was
used to add the user id.
Something like
mysql -u userid -p -h hostname dbasename
should work.
If not, check that mysqld is in fact running. You can
use
ps -aux | grep mysql
Regards,
~Kelly W. Black
play the two rows as a total sum together in one row?
I have been struggling with this and could really use some help.
Thanks in advance for any ideas.
Regards,
Kelly Black
Linux was very clearly the answer, but what was the question again?
Use the ROUND statement
ROUND(sum(CLICKS),sum(IMPS)/sum(CLICKS)*100.0,0),2);
-Original Message-
From: David Garamond [mailto:davegaramond@;icqmail.com]
Sent: Sunday, November 03, 2002 2:31 AM
To: [EMAIL PROTECTED]
Subject: rounding behaviour
hi,
mysql> select 1/29;
+--+
| 1/29 |
+-
Typically if your OS runs, the mysql will too.
You should only be worried with hardware
if you are running large database apps
on a slow system.
-Original Message-
From: Stephen Hitchner [mailto:steve@;number41media.com]
Sent: Friday, November 01, 2002 9:40 PM
To: Mysql
Subject: mysql die
/to/mysql.sock /tmp/mysql.sock
~Kelly W. Black
-Original Message-
From: Paul DuBois [mailto:paul@;snake.net]
Sent: Friday, November 01, 2002 6:26 PM
To: CM Miller; [EMAIL PROTECTED]
Subject: Re: Cannot Log into MySQL
At 16:27 -0800 11/1/02, CM Miller wrote:
>Still workin' at
PRIVILEGES;
The server will automatically answer on the virtual socket.
Regards,
~Kelly W. Black
-Original Message-
From: Matt Neimeyer [mailto:matt@;neimeyer.org]
Sent: Friday, November 01, 2002 10:45 AM
To: Daniel Kasak; [EMAIL PROTECTED]
Subject: Re: Multiple MySQL Instances...
&
Okay killall -HUP then
-Original Message-
From: Mark [mailto:admin@;asarian-host.net]
Sent: Thursday, October 31, 2002 6:45 PM
To: Black, Kelly W [PCS]; 'CM Miller'; [EMAIL PROTECTED]
Subject: Re: Still not getting a mysql prompt
- Original Message -
From: "Blac
t or are denied.
This is why I make these recommendations.
Kelly W. Black
Irvine Ca.
sql , query
-Original Message-
From: CM Miller [mailto:cmmiller1973@;yahoo.com]
Sent: Thursday, October 31, 2002 5:11 PM
To: [EMAIL PROTECTED]
Subject: Still not getting a mysql prompt
I'm still
It's all right here => http://www.mysql.com/manual.php
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Thursday, October 31, 2002 1:49 PM
To: [EMAIL PROTECTED]
Subject: Creating users through SQL
How do I create users for a specific database using SQL?
-
Michael
Heheheh lmao!
I can see what you mean
oh yea sql query!
~K Black
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Thursday, October 31, 2002 12:11 PM
To: '[EMAIL PROTECTED]'
Subject: Re: sql query
Black, Kelly W [PCS] wrote
-
From: [EMAIL PROTECTED] [mailto:mysql-help@;lists.mysql.com]
Sent: Thursday, October 31, 2002 2:14 PM
To: Black, Kelly W [PCS]
Subject: confirm unsubscribe from [EMAIL PROTECTED]
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
You must issue
flush privileges;
to the sql query line.
~K Black
-Original Message-
From: alex [mailto:alex@;dynaweb.ru]
Sent: Thursday, October 31, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: access denied for user with granted privileges
Hi ppl!
I've got a strange problem.
I've c
Try compiling form source instead of running binary.
~K Black
-Original Message-
From: Mark [mailto:admin@;asarian-host.net]
Sent: Thursday, October 31, 2002 12:33 PM
To: heath boutwell; [EMAIL PROTECTED]
Subject: Re: Thread Thrashing and 3.23.53a
- Original Message -
From: "hea
compile mysql with
./configure --with-memory-limit=
I forget the exact syntax.
It's also possible to pass the limit on via the env.
try using "show variables;"
as your sql query, and read how my.cnf is affecting the
settings.
Then you can export memory limits with ulimit to env from the
shel
Joe
You might want to try owning all the mysql files over to
a userid like "mysql" and then use
cd /usr/local/mysql-ver.
./bin/mysqld_safe --user=mysql &
sql query
Regards
~K Black
-Original Message-
From: Joe M [mailto:joe_m@;circlepressroom.com]
Sent: Thursday, October 31, 2002 11:1
1 - 100 of 147 matches
Mail list logo
