On Mon, Aug 13, 2012 at 8:25 PM, Thufir hawat.thu...@gmail.com wrote:
Looking at:
Group gmane.comp.db.mysql.general
Description The main list for general MySQL discussion
Address mysql@...
Status posting allowed
http://dir.gmane.org/gmane.comp.db.mysql.general
It would
On Tue, Apr 3, 2012 at 04:10, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message -
From: Singer X.J. Wang w...@singerwang.com
Perhaps something called a VM can be use?
Perhaps something called documentation can be provided?
I also notice that the original poster seems
On Mon, Sep 26, 2011 at 14:30, Michael Albert m_albert...@yahoo.com wrote:
I don't suppose I am the first to notice this, but most of
the pages on dev.mysql.com have been listed by google
as attack pages, e.g http://dev.mysql.com/downloads/.
Has there been a problem, or is google being
On Thu, May 5, 2011 at 10:29, Grega Leskovšek legr...@gmail.com wrote:
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock
On Wed, Dec 29, 2010 at 04:57, Hajo Locke hajo.lo...@gmx.de wrote:
Hello,
i want to talk from php to different mysql-servers with different versions.
is it a recommend way to compile php always against newest libmysqlclient or
not so important?
You should use the newest stable version so
On Fri, Jun 18, 2010 at 16:30, Dave deal...@gmail.com wrote:
SELECT * FROM contacts WHERE state = 'CA' and name = 'bob' or
name = 'sam' or name = 'sara'
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a
[Top-post.]
You'll probably have much better luck on the MySQL General list.
CC'ed on this email.
On Tue, Jun 15, 2010 at 20:58, Jan Reiter the-fal...@gmx.net wrote:
Hi folks!
I'm kind of ashamed to ask a question, as I haven't followed this list very
much lately.
This isn't
On Sat, Jan 30, 2010 at 01:49, Vikram A vikkiatb...@yahoo.in wrote:
Dear Admin,
I would like to share and get inputs from experts on MYSQL Db.
I request you to grant access to me.
You may not have noticed, but you're already posting to the list.
All you have to do is subscribe and you
Just as a heads-up, in case you guys weren't yet aware (cross-posting):
Elance.com was the victim of an SQL injection attack earlier this
summer (they apparently missed our billions of threads on sanity).
According to their folks, only names, company names, phone numbers,
and email
On Mon, Jul 20, 2009 at 15:03, Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problemr...@doctor.nl2k.ab.ca
wrote:
Hello, we are trying to move a Joomla Site
and the administrator does nowrk.
Using MySQL 5.1.36 on MAC OS X Server.
How can I fix this?
This would be
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If
On Sun, Apr 19, 2009 at 23:42, Cameron Rogers cameronl...@gmail.com wrote:
Hi everyone. I am starting my first web site. I have a temporary contract
with godaddy but know there are better options out there. The only problem
is, I don't know reliable sources to research which hosting program
On Mon, Mar 30, 2009 at 19:45, Dian Crayne dcra...@crayne.org wrote:
Chuck Crayne (ccra...@crayne.org) has died. I am his widow.
I cannot unsubscribe him from this list because I do not
have his user name and password. Please remove him from your
membership list. If you need to talk to me
On Mon, Feb 2, 2009 at 13:43, Martin Gainty mgai...@hotmail.com wrote:
select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
That hit the nail right on the head. That was the same thing I
was going to suggest, Martin. I think people tend to
On Thu, Jan 15, 2009 at 20:44, Daevid Vincent dae...@daevid.com wrote:
I've been tasked with cleaning up a bunch of 'eventum' tables that got
accidentally dumped into several databases and then replicated.
I'm wondering if I can just go through with a simple command to blow
these all away:
On Wed, Jul 23, 2008 at 11:45 AM, [EMAIL PROTECTED] wrote:
Guys,
I have been fighting with mysql trying to get it to only show every after
the last dot(.) on a ip. for example
instead geting 10.0.0.0 only get 10.0.0
As pulled from a database row? Sorry, I didn't quite understand your
On Wed, Jul 23, 2008 at 12:10 PM, [EMAIL PROTECTED] wrote:
Yes, sorry. I have a database that records ip of attacks on a customer
server, what I like to do get a count so that I can see what subnet is
doing the major of the attacks.
select ip from ipslimit 10;
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi [EMAIL PROTECTED] wrote:
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
[snip=schema]
In that , I need to calculate the number of total sites , number of
total Accessed Sites,number of
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi all, i have an existing database (internal) with a user named 'admin',
everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's privileges
on test as same as
On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
is there any command that can set so that admin's privileges on internal =
admin's privileges on test???
what i'm trying to avoid is manually adjust admin's privileges on test if
admin's privileges on internal changed.
Ratheesh,
There's a specific list for PHP database functions, Databases and
PHP (PHP-DB), which you can find at http://php.net/mailinglists .
I'm forwarding your message over to there, and recommend that you
subscribe to that list. You'll probably get more direct responses by
On Tue, Apr 15, 2008 at 2:20 PM, B. Keith Murphy [EMAIL PROTECTED] wrote:
Hey everyone,
I just posted the Spring issue of the MySQL Magazine. This issue contains
a great group of articles that you will want to read. In addition, Sheeri
Cabral did a fabulous job with a new layout for the
On Tue, Apr 15, 2008 at 3:11 PM, minky arora [EMAIL PROTECTED] wrote:
Hi Gurus,
I am a newbie.Please bear with me.
Could someone pls guide me as to the best way of adding excel files as
tables to Mysql ?
mysqldump is for exporting data. What you're looking for is the
LOAD DATA [LOCAL]
On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim [EMAIL PROTECTED] wrote:
Hi Everyone,
I am attempting to use this command: load data infile
'/volumes/raider/elks.test.txt' into table elksCurrent fields terminated by
'\t' lines terminated by '\n';
[snip!]
The error that I'm getting is:
|
On Mon, Apr 14, 2008 at 3:33 PM, Jason Pruim [EMAIL PROTECTED] wrote:
On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
That's because it's attempting to insert the name of the columns
from your CSV into MySQL --- and 'Record' is not a valid INT.
Replaced field name with 0 and had
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown [EMAIL PROTECTED] wrote:
Does your file actually have the characters \t \t \n at the end of
each row like that?
Send it to me as an attachment off-list and I'll help you figure
it out and then post back here for the MySQL archives
On Tue, Apr 8, 2008 at 7:28 AM, Steven Macintyre
[EMAIL PROTECTED] wrote:
Hi all,
I have the following SQL statement;
SELECT count( salesID ) AS count, branch_name, company_name, branch.branchID
FROM sales
LEFT JOIN IGuser ON sales.IGuid = IGuser.IGuid
LEFT JOIN
On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan
[EMAIL PROTECTED] wrote:
Hi
Is there a documentation on replication of MySQL Database on Gentoo
From the manual:
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
--
/Daniel P. Brown
Forensic Services, Senior Unix
On Sun, Mar 30, 2008 at 9:59 AM, Velen [EMAIL PROTECTED] wrote:
Hi,
How can i limit connections to my database?
RTFM: http://dev.mysql.com/doc/refman/5.0/en/user-resources.html
--
/Daniel P. Brown
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing
On Fri, Mar 21, 2008 at 9:14 AM, Velen [EMAIL PROTECTED] wrote:
This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate
pc and the only communication that can be use between the two PC is a USB
pendrive.
Is there another way of copying a table from one Database to
On Fri, Mar 21, 2008 at 10:04 AM, Velen [EMAIL PROTECTED] wrote:
This one is alright but is there an alternative that can be run with the
mysql prompt?
Not to dump a file, but to import, yes. Check out the LOAD DATA
INFILE command:
On Thu, Mar 20, 2008 at 1:41 PM, Velen [EMAIL PROTECTED] wrote:
Actually I am updating TableA in DatabaseA with values from TableB in
DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a
.txt file containing data from TableB then using VB6 once more to
recronstruct
On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles [EMAIL PROTECTED] wrote:
Using mysqldump, I'm about to dump all databases and import to another
instance - new . My question is do I need to define all security and
users in the new mysql or the security definitions and privileges will
be
On Wed, Mar 19, 2008 at 3:51 PM, Brown, Charles [EMAIL PROTECTED] wrote:
I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the
On Wed, Mar 12, 2008 at 3:15 PM, MAS! [EMAIL PROTECTED] wrote:
does the lock table on MySQL (I'm using 5.0.22 or 5.0.45) works
even for a cached result?
Hold your horses, dude. That's the third time you sent that
email. Someone will give you an answer if you're patient.
If you can't
On Wed, Mar 12, 2008 at 3:26 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Wed, 12 Mar 2008, Michael Dykman [EMAIL PROTECTED] wrote:
It's quite simple; -p, --password takes an optional argument which
it will only look for if
a) the short form is immediately followed by a non-space
On Mon, Mar 10, 2008 at 11:07 AM, [EMAIL PROTECTED] wrote:
I'm getting an error trying to run this command:
root mysql_tzinfo_to_sql /usr/share/zoneinfo/America/ | mysql -u xxx -p
xxx
ERROR 1046 (3D000) at line 1: No database selected
mysql -D mysql -u xxx -p mysql_tzinfo_to_sql
On Mon, Mar 10, 2008 at 11:36 AM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Mon, 10 Mar 2008, Daniel Brown [EMAIL PROTECTED] wrote:
mysql -D mysql -u xxx -p mysql_tzinfo_to_sql
/usr/share/zoneinfo/America/
The -D flag selects the database `mysql`, which is where the time
zone
On Mon, Mar 10, 2008 at 2:29 PM, Terry Babbey [EMAIL PROTECTED] wrote:
Hello,
I have a huge database that I would like to migrate from a server
running 4.0.16 to a server running the Windows version 5.0.45. The
database is approximately 3,500,000 records. I get timeout errors using
On Mon, Mar 10, 2008 at 2:58 PM, skills2go
[EMAIL PROTECTED] wrote:
Hi Folks
I'm trying to copy a database table form one database to another on a
different server. Is it possible through myphpadmin, or do I need software?
If software, do you know of any good programs to do this?
On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Mon, 10 Mar 2008, Daniel Brown [EMAIL PROTECTED] wrote:
The same question just received an excellent answer from Rolando
Edwards about ten minutes ago. Check the archive here:
http://marc.info/?l=mysqlm
On Mon, Mar 10, 2008 at 4:05 PM, Terry Babbey [EMAIL PROTECTED] wrote:
Thanks to all for the quick replies.
Yes, the mysqldump worked perfectly. Boy do I feel like a newbie now!
If I use the method below, will that transfer the mysql admin database
too with the user information?
On Thu, Mar 6, 2008 at 10:20 AM, Andre Hübner [EMAIL PROTECTED] wrote:
Hi List,
user wants to do:
SELECT COUNT(*) FROM mysql.time_zone_name;
problem ist that this table in mysql is empty. I dont know how to fill with
data. I tried on testmachine with mysql_install_db but it leaves
On Wed, Mar 5, 2008 at 12:13 AM, Michael Hemer [EMAIL PROTECTED] wrote:
Hi,
I have been researching to see if it's possible to have a MySQL database
with it's data files on a cd-rom, but could use some help to determine if I
have found out the full truth of what's possible. I would
On Tue, Mar 4, 2008 at 10:57 AM, Esbach, Brandon
[EMAIL PROTECTED] wrote:
[snip!]
SELECT
t.pass, t.id
FROM
theTable t
GROUP BY
t.serial_number
ORDER BY
t.date desc
Try adding the LIMIT keyword.
SELECT t.pass, t.id FROM theTable t GROUP BY
On Tue, Mar 4, 2008 at 11:24 AM, Esbach, Brandon
[EMAIL PROTECTED] wrote:
Thanks for the reply,
Sorry, should have been more specific on that :).
I need to access the last record by date for each serial_number in the
table (not just latest record)
Okay, this is untested, so I don't
On Tue, Mar 4, 2008 at 12:02 PM, Esbach, Brandon
[EMAIL PROTECTED] wrote:
Hmm didn't notice that replies are sent to personal emails :o!
I'll look down that avenue once I've completed the mysql version upgrade
(mysql 4 on my test bench, mysql5 upgrade in progress on the production
server)
On Mon, Mar 3, 2008 at 2:01 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
hi all, i just installed mysql and started mysqld.
it suggested i change pw for root, so i did:
mysqladmin -u root password my_pw;
but i can't do:
mysqladmin -u root -h dev.jss.com password my_pw;
how do i change pw
On Mon, Mar 3, 2008 at 2:46 PM, Hiep Nguyen [EMAIL PROTECTED] wrote:
mysql select user,host,password from mysql.user;
+--+--+--+
| user | host | password |
+--+--+--+
| root |
49 matches
Mail list logo