l. This also
> explains why it's always 0 for InnoDB tables :-)
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
(MB)',
> Round( Sum( data_free ) / 1024 / 1024, 3 ) AS 'Free Space (MB)'
> FROM information_schema.tables
> GROUP BY table_schema ;
>
>
> Thank you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
27; where prod_id='3069' and
> prod_code='a0071';
> Query OK, 1 row affected (0.00 sec)
> Rows matched: 1 Changed: 1 Warnings: 0
>
>
>
>
> How can I list rows with no recent updates ( or the once where the above
> updates were not done) or say wit
de firmas
> de virus 5170 (20100603) __
>
> ESET NOD32 Antivirus ha comprobado este mensaje.
>
> http://www.eset.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com
ed.
>
> Thanks for any help!
>
> Andre
>
> --
> Andre Matos
> andrema...@mineirinho.org
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
CC7F
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
ow to
> catch the slave back up to the master? The master is not being overloaded,
> it is keeping up no problem, and the backup server is 8x the server than
> the
> application server, so it shoulnd't even be an i/o or cpu issue.
>
> Please help! :)
>
>
> Thanks in advance
> Steven Staples
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
> Please, Can any one you help me?
>
> Thank you
>
> VIKRAM A
>
>
>
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
//www.mit.edu/~y_z/ <http://www.mit.edu/%7Ey_z/>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
d) from
> table_name)
> >> ?
> >>
> >>
> >> Thanks in advance.
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=armand...@gmail.com
> >>
> >>
> >>
> >
> >
> >
>
>
>
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
ibe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
gt; ORDER BY order_date;
>
> or
>
> SELECT * FROM orders WHERE order_date =>'2010-01-01' AND <= '2010-01-30'
> ORDER BY order_date;
>
> Neither of these work.
>
> What am I missing?
>
> -ML
>
> --
> MySQL General Mailing List
> For list
archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
ere.
On Tue, Jan 5, 2010 at 1:50 PM, Carsten Pedersen wrote:
> Is there any particular reason not to use the MySQL ODBC driver to import
> the data directly into Excel?
>
> / Carsten
>
> Jim Lyons skrev:
>
> A command to convert the table mytab in database mydb int
excel-compatible.html
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=ishaq...@yahoo.co.uk
>
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
do a select on the data
you want, redirecting it into an output file.
On Tue, Jan 5, 2010 at 7:17 AM, ishaq gbola wrote:
> Hi all,
>
> I would like to know if there is a tool or command in mySQL that allows one
> to export the result of query into excel formart
>
>
>
&g
71414c107d1c5&token=160eb1977a91a41f90271414c107d1c5>
> 8524
>
>
> I dont want the Null row ,
>
> how to remove the null display ,
>
>
> Thanks
>
>
>
>
> On Sat, Jan 2, 2010 at 11:38 PM, bharani kumar <
> bharanikumariyer...@gmail.com> wrote:
&g
,
>
>
>
> This query purpose is , i have around 1000 patients in my DB,
>
> Each patient may have one,two,three hospital code,that's y the field are
> hospital1,hosptial2,hospital3,
>
>
> i know , i can display all hospital code with unique , but i d
hat are reasons and how do i decrease the same?
>
> We are using connect() method in PHP code and have tried below command
>
> mysqladmin flush-hosts
>
> but still the value is same.
>
>
> Thanks
> Jeetendra Ranjan
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
derid` (`folderid`),
> KEY `threadid` (`threadid`),
> KEY `inboxfolderindex` (`folderid`,`toid`,`totype`),
> KEY `sentitemsindex` (`fromid`,`fromtype`)
> ) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 INSERT_METHOD=LAST
> UNION=(`messages2009`);
>
>
>
>
>
>
> Sudhir NimavatSenior software engineer.
> Quick start global PVT LTD.
> Baroda - 390007
> Gujarat, India
>
> Personally I'm always ready to learn, although I do not always like being
> taught
>
>
> The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> http://in.yahoo.com/
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
Ken D'Ambrosio wrote:
>
> > > rename table oldschema.table to newschema.table;
> >
> > Just to be 100% clear -- I assume you have to first create the
> destination
> > database, and then do this for all the tables in the source database?
> >
>
> Yep.
gspot.com/
> "Peace" is the Ultimate thing we want.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
garwal, (281)846-8957, http://UnmeteredVPS.net
> Host your MySQL driven app on a CentOS VPS for $25/mo
> Unmetered bandwidth = no overage charges, 7 day free trial
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
ySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
Is this or similar syntax in MySQL or is my dotage coming upon me
>
>
> Thanks in advance,
>
> Bruce
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jlyons4...@
procedure to follow that will
> allow me to archive these files and
> Then start new ones so I can get my disk space back?
>
> Thanks in advance.
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com
, it takes 10 minutes or so.
>
> Tim...
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
y related options in mysqld --help --verbose. Is there a
> way to achieve this, without modifying the startup script ?
>
> Thanks in advance.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql
er.
>
> I'll be interested in the answer, though, from someone with experience.
>
> -- Pete Wilson
> http://www.pwilson.net/
>
>
> --- On Thu, 5/14/09, Jim Lyons wrote:
>
> > From: Jim Lyons
> > Subject: Re: MAC address as primary key - BIGINT or CHAR(12)
>
e:
> 1. MAC address defined as BIGINT
> 2. MAC address set as primary key
>
> Should I consider changing it to CHAR(12)?
>
> Replies will be appreciated.
> Ilia
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
, 2009 at 11:45 AM, Abhishek Pratap wrote:
> Hi Jim
>
> Unfortunately I have thousands of such points. So explicit statement
> calling will be very expensive both computationally and in terms of
> writing..
>
> Thanks,
> -Abhi
>
>
> On Fri, May 8, 2009 at 12:37 P
table_name where start <= ( LIST of time stamps) AND end >=(
> list of time stamps).
>
> Clearly above query accepts only one item in the list. Is there a way to do
> this for multiple items in the list ??? I can't think of anything at this
> moment.
>
>
> Thanks,
> -Abhi
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
x27;;
>
> If I try logging in as this user though the following happens:
>
>
>
> mysql> create database testdb;
> ERROR 1044 (42000): Access denied for user 'user'@'localhost' to
> database 'testdb'
>
> Can someone point out the error of
rmington Ave.
>
> Farmington, CT 06032
>
>
>
> 860.674.8796 / FAX: 860.674.8341
>
>
>
> <http://www.the-infoshop.com> www.the-infoshop.com
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
t; ...
> user_id INT NOT NULL,
> current_timestamp TIMESTAMP,
> primary key (id)
> );
>
> I will not use auto_increment
>
> Is there other way to generate unique primary key in MySQL?
>
> Thank you
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
the mysqldump command.
2009/4/19 Jim Lyons
> try something like:
>
> mysqldump -u(user) -p (db-name) `ls z*` > (filename)
>
>
> 2009/4/19 ChoiSaehoon
>
>
>> Is there a way to dump only specific tables starting with a certain
>> character?
>>
&
> MSN 메신저의 차세대 버전, Windows Live Messenger!
> http://windowslive.msn.co.kr/wlm/messenger/
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
> Richard
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
eone has beaten
> me to it, but I am so not in the mood to write one!
>
>
>
> Any hints, recommendations, and ideas are wholly welcome!
>
>
>
> ---
>
> Kind Regards,
>
> Mr Gabriel
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
cross-schema invocations of sp's and this is the last
piece I have to figure out.
Thanks,
Jim
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
No, there's only one mysqld process running. Thanks, tho.
On Thu, Mar 19, 2009 at 3:56 PM, Claudio Nanni wrote:
> I am afraid you have two mysql instances up on the same host.
>
> ps -ef | grep mysql ?
>
>
> Claudio
>
>
> Jim Lyons wrote:
>
>> I hav
illing up after replication has
broken?
Thanks
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
great! thanks much.
On Wed, Mar 18, 2009 at 1:52 PM, Claudio Nanni wrote:
> Ok sorry, I did not understand at first.
>
> GRANT INSERT on mydb.audit_table to ''@'%';
>
> should do the work.
>
> Cheers
>
> Claudio
>
> Jim Lyons wrote:
&g
;>
>> I guess I could put it in test, but then everyone could do anything with
>> it,
>> which would not be particularly desirable. The table should be "insert
>> only", not readable or updateable by anyone but the owner of "mydb".
>>
>> Is there any way I can do this?
>>
>> Thanks,
>> Jim
>>
>> --
>> Jim Lyons
>> Web developer / Database administrator
>> http://www.weblyons.com
>>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
ege.
I guess I could put it in test, but then everyone could do anything with it,
which would not be particularly desirable. The table should be "insert
only", not readable or updateable by anyone but the owner of "mydb".
Is there any way I can do this?
Thanks,
Jim
--
resides.
We use LVM snapshots to move the data around, since our databases are
several terabytes. Does this mean our snapshots are inconsistent? There’s
no way we can get all innodb data on a single partition.
Thanks,
Jim Lyons
--
Jim Lyons
Web developer / Database administrator
http
>> --
> >> Baron Schwartz, Director of Consulting, Percona Inc.
> >> Our Blog: http://www.mysqlperformanceblog.com/
> >> Our Services: http://www.percona.com/services.html
> >>
> >>
> >
>
>
>
> --
> Baron Schwartz, Director of Consulting, Percona Inc.
> Our Blog: http://www.mysqlperformanceblog.com/
> Our Services: http://www.percona.com/services.html
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
support that syntax?
> >
> > http://dev.mysql.com/doc/refman/5.0/en/logical-operators.html
> >
> >
> > __
> > This email has been scanned by Netintelligence
> > http://www.netintelligence.com/email
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
tabase and
> table, I get the same error message.
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
User='root';
> FLUSH PRIVILEGES;
> exit
>
> When I try to log in now:
> # mysql -u root -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
>
> Can someone give me a nudge/push/drag me kicking and screaming in the right
> direction?
>
> Thanks everyone :)
>
> --
> Tim DeBoer
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
tion comes with default storage engine myism and innodb.
> Just verify show engines on mysql prompt.
>
>
> On Fri, Feb 20, 2009 at 5:25 AM, Jim Lyons wrote:
>
>> We have 5.0.22 installed on a test machine and for some reason the innodb
>> storage engine was not enabled.
a BlackBerry from T-Mobile
>
> ------
> *From*: Jim Lyons
> *Date*: Thu, 19 Feb 2009 23:06:33 -0600
> *To*:
>
> *Subject*: Re: Resend: enabling storage engine with RPM install
> How does one do that in my.cnf?
>
> It is possible to dis
y.cnf. I would love
it, if I could, though.
On Thu, Feb 19, 2009 at 10:47 PM, wrote:
> Perhaps you disabled it via my.cnf
>
>
> Sent via BlackBerry from T-Mobile
>
> -----Original Message-
> From: Jim Lyons
>
> Date: Thu, 19 Feb 2009 22:45:01
> To: MySQL
> S
"InnoDB: blah blah", you
> have a binary that includes InnoDB, and it's just disabled for some
> reason.
>
> Baron
>
> On Thu, Feb 19, 2009 at 6:58 PM, Jim Lyons wrote:
> > Sorry, but I'm resending because I made a mistake in terminology and want
> to
> &
oes one make the selections in the first place with RPMs?
We've always just taken what we got and it was sufficient.
Thanks,
Jim
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
age engine once mysql's been installed
by an RPM? How does one make the selections in the first place with RPMs?
We've always just taken what we got and it was sufficient.
Thanks,
Jim
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
the time
taken should not depend on the size of the database, should it (unless I
have to rebuild some indexes)?
Thanks,
Jim
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
procedures.
Is there a way to do that? Is there a better overall way to track procedure
calls? What about function calls?
Thanks,
Jim
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
management or LVM" ... I knew there was a way to
> use LVM for backups somehow. Maybe a solution for us?
> http://www.mysqlperformanceblog.com/?s=backup
>
> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/
>
> Some other backu
a timeout problem.
> How can I increase the timeout period.
> TIA
> mosaed
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
> 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/lib/mysql/ -name eventum*
>
> Or is there some other magic that a "DROP TABLE
r list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
pera and Safari:
> http://www.rgraph.org (Updated January 4th)
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
now() -
it's a non-deterministic function.
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
t; replication?
>
> --
> --
> Open Kairos http://www.openkairos.com
> Watch More TV http://sebelk.blogspot.com
> Sergio Belkin -
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
ze it later.
>
> Thanks,
> Shuly,
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
net/resume | Blog at http://www.lolajl.net/blog/
> "In rivers, the water that you touch is the last of what has passed
> and the first of that which comes; so with present time." - Leonardo da
> Vinci (1452-1519)
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
o create dump and do this manually every time it fails.
>
>
> Advise?
>
> Also is replication really this unreliable? It breaks at the slightest
> hiccup...
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
is problem? Is there something I can do to speed up
queries to IS? I know these are views, are they so complicated that it
takes forever to query them. This reduces their usefulness if true.
Thanks
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
s & Regards,
> Tanveer Bhurani
> "The Bend on the road is not the end of the Road..., Unless you forget
> to make the turn"
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
> Based on your experiences, is there anything we should be aware of before
> investigating this route and putting it into practice ?
>
> Thanks,
> Neil
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
I ran the same script on a Windows mysql 4 version, the value of
com_select persisted over the login, which is what it should.
Is this a bug in mysql 5? Is something set incorrectly in my config file
that would cause this (I can't find anything)?
Thanks for any help.
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
> /*!40103 SET [EMAIL PROTECTED] */;
>
> /*!40101 SET [EMAIL PROTECTED] */;
> /*!40014 SET [EMAIL PROTECTED] */;
> /*!40014 SET [EMAIL PROTECTED] */;
> /*!40111 SET [EMAIL PROTECTED] */;
>
> -- Dump completed on 2008-10-27 13:50:53
&
-
>
>What I'd like to know is how to get more info about the query
> identified with 30399 (in this example). I mean, the exact query, like
> "SELECT pr1, pr2 FROM someDB".
>
> Thanks
>
> Matias
>
> --
> MySQL General Mailing List
> For lis
unction to do this. Any suggestions?
>
> TIA
> Mike
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
> of region and location names. Would that help, or is there a better way?
>
> Mark
> --
> http://mark.goodge.co.uk - my pointless blog
> http://www.good-stuff.co.uk - my less pointless stuff
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database:
>> 270.8.2/1739 - Release Date: 10/22/2008 7:23 AM
>>
>>
>>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
_number
>
> WHERE CC = max( CC );
>
>
>
> But this also causes an error, anyone able to offer some pointers am I able
> to use sub queries ?
>
>
>
> Thanks Dave.
>
>
>
>
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
gt; automatic - you have to either flush logs or bounce the server. We use
>> "Purge Master" periodically.
>>
>>
>
> i do this from cron
>
> mysql -e "PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)"
>
> perhaps not that &#x
tial integrity OR can it also
> speed up JOIN queries?
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
(normalized) way of representing this?
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
Zbigniew Szalbot
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
--
>
>
> Is it possible to have the column "OptionalDesc" as showed in the first
> table above?
>
> Thanks for any help.
>
> Andre
>
> --
> Andre Matos
> [EMAIL PROTECTED]
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
recommendations that could help us improve the speed? Would more
>>>> memory help us? Any comments or recommendations are greatly
>>>> appreciated.
>>>>
>>>> Thanks much.
>>>>
>>>>
>>>> Jim Leavitt
>>>> Developer
>>>> Treefrog Interactive Inc. (<http://www.treefrog.ca>www.treefrog.ca)
>>>> "Bringing the Internet to Life"
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: <http://lists.mysql.com/mysql>
>>> http://lists.mysql.com/mysql
>>> To unsubscribe: <http://lists.mysql.com/[EMAIL PROTECTED]>
>>> http://lists.mysql.com/[EMAIL PROTECTED]
>>>
>>
>> Jim Leavitt
>> Developer
>> Treefrog Interactive Inc. (<http://www.treefrog.ca/>www.treefrog.ca)
>> "Bringing the Internet to Life"
>> ph: 905-836-4442 ext 104
>> fx: 905-895-6561
>>
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
re greatly appreciated.
>
> Thanks much.
>
>
> Jim Leavitt
> Developer
> Treefrog Interactive Inc. (www.treefrog.ca)
> "Bringing the Internet to Life"
>
>
>
>
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
> See if that improves the numbers on the prepared statement.
>
> - michael dykman
>
>
> On Tue, Sep 2, 2008 at 5:41 PM, Jim Lyons <[EMAIL PROTECTED]> wrote:
> > I have a question about the prepare/execute commands provided by mysql.
> >
> > I devised
e for
statement-at-a-time versus prepare/execute? And why prepare/execute in the
mysql commandline program is so much slower than prepare/execute in Perl?
Thanks.
Jim
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
#x27; AND PARAM =
> 'TIMEOUT'table |type |possible_keys |key | ken_len|ref | rows| 1
> |SIMPLE | | | | | |Impossible WHERE noticed afte
> --
> Krishna Chandra Prajapati
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
(x int);
> create table t3 (x int);
>
> create table t_merge (x int) engine=merge union=(t1,t2,t3);
>
> drop table t1;
> drop table t_merge;
>
> create table t_merge (x int) engine=merge union=(t2,t3);
>
> -Original Message-
> From: Jim Lyons [mailto:[EMAIL
--
--
alter table t_merge union=(t2, t3)
--
ERROR 1146 (42S02) at line 16: Table 'jlyons.t1' doesn't exist
Is this a bug or expected behavior?
Thanks,
Jim
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
correction, the command that's failing evidently is the 'create table
columns_priv', not a drop table. Sorry for the typo.
2008/8/24 Jim Lyons <[EMAIL PROTECTED]>
> The command that's failing evidently is the "drop table columns_priv" which
> is why yo
le... why i must droped my
> table? cırrent server is running properly.. but either OS version or HW is
> very old. We took new powerfull server, anc we want to migrate our data to
> new server...
> onlt this i want to do it.
>
>
>
>
> 2008/8/22 Jim Lyons <[EMAIL PR
sy <[EMAIL PROTECTED]>
> İ am migrating database from mysql-client-4.0.20 running server(current) to
> mysql-client-5.0.51a running server(new) ..i ve took mysqldump and
> transfered to new server and restored but process broken up with this error
> message.
>
>
>
>
>
exists*
>
>
> My old server mysql version is mysql-client-4.0.20 is running on
> old
> server but mysql-client-5.0.51a is running now
>
> what can i do
>
> regards
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
ces) on the same server.
> I know we can do that using different port, but should i use two different
> my.cnf files, and also, what is the procedure to stop one mysql service and
> keep other one running.
>
> regards
> anandkl
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
;5.0.45-log' socket: '/var/lib/mysql/mysql.sock' port: 3306
> Source distribution
> 080819 12:55:41 [Warning] Neither --relay-log nor --relay-log-index were
> used; so replication may break when this MySQL server acts as a slave and
> has his hostname changed!! Please
> immediately.
>
> Thank you.
> ********
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
;t specify the socket the
3306 master needs to connect to on the 3307 master. In the "change master
to" command I can only specify the port. I did specify it as 3307 but the
"slave" still can't connect.
Has anyone done this?
--
Jim Lyons
Web developer / Database administrator
http://www.weblyons.com
1 - 100 of 104 matches
Mail list logo
