Re: Error installing perl module DBD::mysql

On 10/25/05, Ziaul Mannan <[EMAIL PROTECTED]> wrote: > ** Low Priority ** > > Hello, > > I was able to install the following perl modules fine: > DBI > Data::Dumper > Data::ShowTable > DBI.pm > > Then,when I am try to install perl module called 'DBD::mysql' on AIX > 5.2(64-bit) and 5.3. In both cas

Re: MySQL Control Center

On 11/22/05, Jim Winstead <[EMAIL PROTECTED]> wrote: > On Tue, Nov 22, 2005 at 04:50:42PM -0800, Jon Drukman wrote: > > What happened to MySQL Control Center (aka mycc or mysqlcc)? The > > dev.mysql.com site redirects to the Query Browser page. QB is a poor > > substitute for mycc. It looks like

Re: Drop all tables?

On 1/2/06, JJ <[EMAIL PROTECTED]> wrote: > Is there an easy way to drop all (MyISAM) tables of a MySQL 3.23 database > besides deleting it and then recreating an empty database? Read up on mysqldump. For 3.23, something like the following should do the trick: mysqldump databasename --add-drop-ta

Re: How do increase memory allocated to MySQL?

2011/2/3 Yannis Haralambous : > > what am I doing wrong? > > the query was just > > SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%' When you use a leading wildcard symbol, MySQL will do a full table scan regardless of any indexes you've created. If you've got a MyISAM table, I recomme

Re: [Replication] - load

On 10/10/07, Ratheesh K J <[EMAIL PROTECTED]> wrote: > So every morning all the queries will be slow for the first time on the DB > server 2 and thereafter will be served by the query cache as they will be > cached and never invalidated until the night. Sorry for the late reply, I'm trying to ge

Re: R: Re: FW: Re: what is a schema? what is a database?

On Mon, Apr 7, 2008 at 1:24 AM, Moon's Father <[EMAIL PROTECTED]> wrote: > Schema is a collection of databases. A schema is a definition of tables & fields and their relationship. Kevin. -- [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: how to Get file modified time and date of file by using builtin function or procedure in sql?

On Thu, Jul 24, 2008 at 1:17 AM, Sivasakthi <[EMAIL PROTECTED]> wrote: > Hi All, > > how to Get file modified time and date of file by using builtin function or > procedure in sql? In a related thread from earlier today you were advised that any interaction with the filesystem should be done via a

Re: What is your favorite GUI tool for creating and querying tables in MySQL?

On 12/21/06, Behrang Saeedzadeh <[EMAIL PROTECTED]> wrote: Hi, What is your favorite GUI tool for working with MySQL. EMS SQL Manager is feature-rich but sometimes buggy and also very expensive. Navicat is not very handy. It forces to switch between mouse and keyboard repeatedly. What is your f

Re: MySQL Administrator problem

On 1/19/07, Daniel Culver <[EMAIL PROTECTED]> wrote: Are you working on a Mac? If so, logging in as root is not good enough. You must have set up and log into the root user account of your Mac computer or server. The OP is talking about managing MySQL accounts with MySQL Administrator. MySQL A

Re: FW: MySQL patches from Google

On 4/26/07, Mike OK <[EMAIL PROTECTED]> wrote: I read the Google blog post regarding these patches. They admit using MySQL for some internal data storage needs but not in the general search system. Still, that leaves many other applications. Groups, gmail, reader, news et al... -- Kevin. --

Re: Ho do I backup

On Thu, 28 Oct 2004 12:24:02 +0100, Barry Zimmerman <[EMAIL PROTECTED]> wrote: > > I have tried the following: > > mysqldump -u admin -p --databases yabbse > yabbsebackup.sql > > It seemed to work, but where can I find the yabbsebackup.sql file? Not very > experienced with backing up. Barry, T

Re: Posting Question

On Tue, 9 Nov 2004 13:21:54 -0600, Lewick, Taylor <[EMAIL PROTECTED]> wrote: > I am asking before I post so I don't anger everyone... > > Is this list okay to post a specific question regarding multiple row > inserts.. > > I am doing this in perl, and I need some help with the perl part... There

Re: Searching a table and replacing all instances of a string with another

On Fri, 12 Nov 2004 22:12:29 -0500, Joshua Beall <[EMAIL PROTECTED]> wrote: > Hi All, > > I would like to search through all fields in a table, and anytime a search > string comes up, have it replace it with another string. By way of example, > let's say I wanted to replace every occurence of 'Pe

Re: Installing DBIx::DWIW on CPAN

On Wed, 15 Sep 2004 11:27:55 -0700, Sanjeev Sagar <[EMAIL PROTECTED]> wrote: > > Hello All, > > I am trying to install DBIx::DWIW but giving me following error. > > No such file `DBIx-DWIW-0.41.tar.gz' > > I am trying to install from CPAN > > cpan> install DBIx::DWIW > > Could not fetch autho