On Thu, Jan 15, 2009 at 20:44, Daevid Vincent 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:
>
> find /var/
On Mon, Feb 2, 2009 at 13:43, Martin Gainty 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 forget that
MySQL
On Mon, Mar 30, 2009 at 19:45, Dian Crayne 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 about this, my
On Sun, Apr 19, 2009 at 23:42, Cameron Rogers 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 to use.
> Any reco
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 I
On Mon, Jul 20, 2009 at 15:03, Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problem
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 a question to ask
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 address
On Sat, Jan 30, 2010 at 01:49, Vikram A 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 have full access.
[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 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 exactly a PHP
On Fri, Jun 18, 2010 at 16:30, Dave 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 WHERE...IN statem
On Wed, Dec 29, 2010 at 04:57, Hajo Locke 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 you can take
On Thu, May 5, 2011 at 10:29, Grega Leskovšek 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 timestamp, action va
On Mon, Sep 26, 2011 at 14:30, Michael Albert 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 overzealous?
Here'
On Tue, Apr 3, 2012 at 04:10, Johan De Meersman wrote:
> - Original Message -
>> From: "Singer X.J. Wang"
>>
>> Perhaps something called a VM can be use?
>
> Perhaps something called documentation can be provided?
>
> I also notice that the original poster seems to have vanished again, wh
On Mon, Aug 13, 2012 at 8:25 PM, Thufir 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 really be nice if
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
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 |
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 GROU
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 do
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
> serv
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 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 le
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
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 t
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 h
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 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
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 no
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
>
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
>
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
> recronstr
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:
http://dev.mysql.com/doc/refman/5.0/en/load-d
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
--
Forensic Services, Senior Unix Engineer
1+ (570
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
--
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing List
For list
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
> L
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'
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
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
narrowing-
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
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 [
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,num
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
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 cha
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 understan
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;
> +-+
49 matches
Mail list logo
