Re: Getting the value of a row you just inserted

2003-10-09 Thread todd
rement column. See http://www.php.net/manual/en/function.mysql-insert-id.php todd[1] -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE/hd7v9xvMmfxCaFkRAsoZAJ9eL5aQf0dCHwY/nFdH5vQIny0BrgCgrcI3 V64M7/8+BnyHjJLlzYvG1C4= =MFdB -END PGP SIGNATURE- -- MySQL General Mailing Lis

sql join help?

2003-02-19 Thread Todd
enter it (city and state) into the empty fields of "MSI_List" in accordance with the zip code in "MSI_List"? Thanks in advance! Todd Clemmer - Before posting, please check: http://www.mysql.com/manua

Show Grants problem

2006-04-13 Thread Todd Smith
SELECT * FROM user WHERE User = 'user1' I do get results. Could the user have been added using an insert causing the SHOW GRANTS to fail? Any Ideas Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

INNODB database size

2006-04-25 Thread Todd Smith
that the innodb space is full. I know that the space isn't full because it is still working. I am wondering how I can get a true size of the space used. I would like to get back into the 2G segments. Any suggestions. Todd -- MySQL General Mailing List For list archives:

"tracing" connections to mysql.

2005-07-11 Thread todd . hewett
ql and it has been ran fine. After that I've increased max_connections limit in /etc/my.cnf and app runs fine. Is there a way to determin what connectiions to MySQL are being used by whom? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: "tracing" connections to mysql.

2005-07-12 Thread todd hewett
Thanks Gleb, That was educational. Is there a way to log connections in such a way that is easy to tell how many connections were happening at one time? Thanks, Todd -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 12, 2005 12:26 AM To: mysql

Blew MySQL away by accident

2005-09-04 Thread Todd Cary
t;yum remove mysql" and "yum install mysql" and "yum install mysql-server" and the control files are not recreated. Any suggestions? Todd -- Ariste Software 200 D Street Ext Petaluma, CA 94952 (707) 773-4523 -- MySQL General Mailing List For list archives: http://lists.

Re: Blew MySQL away by accident

2005-09-04 Thread Todd Cary
thank you again! Todd Michael Stassen wrote: Todd Cary wrote: Unfortunately, I blew MySQL away by replacing the MySQL control tables with others and not making a copy of the folder. My data is backed up, so that is not a problem, but I cannot reinstall MySQL and create the mysql directory

Confused about privileges

2005-09-05 Thread Todd Cary
I have created a table, "sfyc" and as root I issued the following: grant all on * to todd identified by 'my_password' with grant option; However, "todd" cannot access "sfyc" with mysql -u todd -p sfyc And the mysql db contains the following: user table

Re: Confused about privileges

2005-09-05 Thread Todd Cary
;sfyc" does show in the table, "db". Todd Chris wrote: Did you run the statement witht he mysql database as the current database? If so , you're statement probably got converted to this: grant all on mysql.* to todd identified by 'my_password' with grant option;

Inserting information into multiple tables and problems

2005-09-20 Thread Todd Hewett
CB_MANUFACTURER (PCB_MANUFACTURER_COMPANY_NAME) VALUES(A); ERROR 1064: You have an error in your SQL syntax near 'INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534), INSERT INTO' at line 2 Any help ideas recommendations are appreciated. Thanks, Todd

Re: Inserting information into multiple tables and problems

2005-09-20 Thread Todd Hewett
as unknown columns. Any other ideas out there? Thanks Todd mysql> INSERT INTO VCS_PO_NUMBER (VCS_PO_NUMBER) VALUES(899234); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) mysql> VALUES(36534); ERROR 1216: Cannot add a c

RE: Inserting information into multiple tables and problems

2005-09-20 Thread todd hewett
-- ----+ 1 row in set (0.02 sec) Thanks again for your help in get

RE: Inserting information into multiple tables and problems

2005-09-21 Thread Todd Hewett
todd hewett wrote: >>>mysql> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) >>>mysql> VALUES(36534); >>> >>>ERROR 1216: Cannot add a child row: a foreign key constraint fails > > >>Can you please post the output of: > >

Recover from plain text log

2005-09-26 Thread Todd Ellison
ay to parse binary logs and recover from them, but is there a way to do the same for text logs? I think I can write a bash script to reformat the file into a series of queries, but I was hoping there was an easier way. Thanks so much, anyone willing to help. Todd Ellison -- MySQL General Ma

Re: MySQL University session on March 12: MySQL and ZFS

2009-03-12 Thread Todd Lyons
tern) / > 14:00 BST / 15:00 CET / 17:00 MDT (Moscow)       How to Use Charsets and > Collations Properly      Susanne Ebrecht A quick reminder, in the U.S. we're in daylight savings time now, so those times are 7AM PDT / 8AM MDT / 9AM CDT / 10AM EDT. Ultimately though, you can't go

Re: Indexing dynamics in MySQL Community Edition 5.1.34

2009-06-27 Thread Todd Lyons
or buffer setting that will explain the sudden drop in speed. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Copy 70GB ibdata, etc. and server won't start now

2009-07-15 Thread Todd Lyons
a, not just the ibdata and iblog files. Just make sure that your innodb settings in my.cnf match. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Re: Copy 70GB ibdata, etc. and server won't start now (Action Required)

2009-07-15 Thread Todd Lyons
not being fair is someone expecting me to do their work for them just so they can receive emails from a public list that they joined. Regards... Todd On Wed, Jul 15, 2009 at 10:20 AM, wrote: > Hello Todd Lyons, > > I use Boxbe to protect my email address. While I did receive your e

Re: Slave log files going nuts...

2009-07-16 Thread Todd Lyons
all sequentially in a row in short order. Look at your cron jobs that start or end around the time that all those "empty" binlogs are being created. -- Regards... Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Any tool convert ibdata1/ib_logfile0/ib_logfile1 files to myisam data offline

2009-07-16 Thread Todd Lyons
NGINE = MyISAM Repeat for each table.  Script it if it's more than a few tables. Note that foreign keys will break if your InnoDB table uses them. -- Regards...      Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: recovery help needed

2009-08-25 Thread Todd Lyons
some other machine on the same LAN, give it the bogus IP with the same netmask. 3. No need to worry about routes, it's on the same LAN. 4. On the other machine, connect using 'mysql -h10.200.100.10 -uroot -p'. When you enter the correct password, it should let you in. * I don't

Re: DB/table problem

2009-09-10 Thread Todd Lyons
or because you have some issue or problem with xtrabackup? I'm not aware of any show-stopper bugs. I'm just curious, because it works well for us. The backup is online with the only lock held occuring while it's copying over the *.frm and *.MY* files, which is not very much for

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Todd Lyons
databse, will I be avail to uploaded into > a myisam > database and will it work? Depends. If you use foreign keys in innodb, then you cannot import that into myisam because myisam does not support foreign keys. If you do not use foreign keys, it should work. -- Regards... Todd -- MySQL

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Todd Lyons
sibly erroneous assumption that if you were using foreign keys, when you switched to MyISAM you wanted to continue to use foreign keys. Without the op saying one way or the other, Michael's answer is more correct than mine. -- Regards... Todd -- MySQL General Mailing List For

Re: How can I know if Mysql Crashed or stopped gracefully

2009-10-27 Thread Todd Lyons
. At least in my testing so far, I've not hit a timeout or received an incorrect OK or FAILED message in the 5.1.x series. -- Regards... Todd The best thing about pair programming is that you have the perfect audience for your genius. -- Kent Beck -- MySQL General Mailing List For lis

Re: Moving from one MySQL server to three MySQL servers?

2010-08-18 Thread Todd Lyons
s wanting to split the load onto 3 machines. When you restarted the stress test, did it access new tables or the same ones that the previous stress test did? What happens if you tell innodb to use less memory and do your tests? Have you found any way to make mysql not run out of memory? -- Regards.

Re: master-slave replication sync problems.

2010-08-31 Thread Todd Lyons
ter, the slave should timeout after only 5 minutes and then resume replication. -- Regards...      Todd I seek the truth...it is only persistence in self-delusion and ignorance that does harm.  -- Marcus Aurealius -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Capitalize Input via Auto Complete?

2010-09-16 Thread Todd Lyons
e of the machines that you're ssh'ing to. # my workstation has ForwardX11=yes in ~/.ssh/config ssh host1 # then from there: ssh -X host2 On host 2, running a gui app pops it up on my local desktop. -- Regards...      Todd I seek the truth...it is only persistence in self-delusion and igno

Re: why mysql choose a bad query

2010-11-05 Thread Todd Lyons
fields in the key (i.e. a covering index) does it still choose what you consider to be the wrong key? -- Regards...      Todd I seek the truth...it is only persistence in self-delusion and ignorance that does harm.  -- Marcus Aurealius -- MySQL General Mailing List For list archives: http:

Chronicle of fixing broken replication, and a question

2011-07-26 Thread Todd Lyons
259 487727085 which of course confirmed the log position I determined in step #12. To be honest, the biggest step in the sequence above is likely #8. The ability to assess a situation without freaking out (for too long) is a big part of a sysadmin job IMHO. Regards... Todd -- If Amer

Re: Chronicle of fixing broken replication, and a question

2011-07-26 Thread Todd Lyons
able slows things down tremendously, so it isn't the best fit in this case. ...Todd -- If Americans could eliminate sugary beverages, potatoes, white bread, pasta, white rice and sugary snacks, we would wipe out almost all the problems we have with weight and diabetes and other metabolic di

Re: SLOW performance over network

2011-09-29 Thread Todd Lyons
.0086 > seconds' at the bottom).  I have many ODBC clients accessing this server as > well, they all have slowness problems too. > > I'm stumped.  What could possibly be causing this issue? Wild Guess: Does DNS resolution, especially reverse dns resolution, still work o

Re: RES: Force drop table

2012-01-25 Thread Todd Lyons
--datadir /var/lib/mysql_tmp/' It simply sounds like you need to find the appropriate value to use to make your data accessible. Regards... Todd -- SOPA: Any attempt to [use legal means to] reverse technological advances is doomed.  --Leo Leporte -- MySQL General Mailing List F

Re: RES: Force drop table

2012-01-25 Thread Todd Lyons
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons wrote: > For example, I shut down my mysql daemon, I make a copy of my > corrupted database at /var/lib/mysql/ into /var/lib/mysql_tmp/, and > then manually start the mysql daemon in the foreground with this: > su - mysql -c '/u

Re: RES: RES: Force drop table

2012-01-26 Thread Todd Lyons
e data is important and have a budget for recovery, you can try (whatever solution is local for you) hiring a consultant skilled in mysql crash data recovery: - Oracle - Percona - SkySQL Regards...Todd -- SOPA: Any attempt to [use legal means to] reverse technological advance

Re: big character constant

2012-03-27 Thread Todd Lyons
to print the check mark and the first one to have the problem because there is no heavy check mark in latin1. What am I missing, why is it printing out the correct value "using latin1" but not "using utf8" ? ...Todd -- Always code as if the guy who ends up maintaining your cod

Re: big character constant

2012-03-28 Thread Todd Lyons
œ” > 1 row in set (0.00 sec) And THAT was what I expected. Thank you so much for clearing that up. ...Todd -- Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. -- Martin Golding -- MySQL General Mailing List For list archives:

Re: MySQL Crash when Open_files reach 128

2012-05-02 Thread Todd Lyons
a cronjob that's telling it to shut down. Please check that before deciding it's a memory or file issue. ...Todd -- Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. -- Martin Golding -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Assistance with replication

2012-11-12 Thread Todd Lyons
'; I'll bet it's some giant number so the slave just doesn't realize that it's lost its connection. ...Todd -- The total budget at all receivers for solving senders' problems is $0. If you want them to accept your mail and manage it the way you want, send it the way the

Re: Determining Table Storage Engine Type on Crashed Table

2007-12-05 Thread Todd Lyons
27; Unknonwn whether other engines obey the same rules and methods. - -- Regards... Todd Chris: grep 500 sendmail.mc undefine(`FAIL_MAIL_OVER_500_MILES')dnl Chris: just in case ... Linux kernel 2.6.22-14-generic 3 users, load average: 0.00, 0.00, 0.00 -BEGIN PGP SIGNATURE--

Sane values for replication

2007-12-06 Thread Todd Lyons
ould kickstart the replication process) because it hits the timeout rather quickly. Of course this doesn't address potential errors with the Slave SQL Thread, but that is known. - -- Regards... Todd There are four boxes to be used in defense of liberty: soap, ballot, jury, and

Replication Question

2008-02-20 Thread Todd Lyons
n I want a daemon to read that relay-log and replicate those commands into a local BDB database. The reason is for maximum speed.) - -- Regards... Todd we're off on the usual strange tangents. next will be whether it is ethical to walk in your neighbor&#

Re: purge binary logs on master

2008-05-19 Thread Todd Lyons
7;. Just confirming that your command does seem correct, dunno why it's not working for you. - -- Regards... Todd when you shoot yourself in the foot, just because you are so neurally broken that the signal takes years to register in your brain, it does not mean that your foot does

Make Innodb give memory back?

2008-11-25 Thread Todd Lyons
r/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [mysqldump] quick -- Regards... Todd All truth passes through three stages. First, it is ridiculed. Second, it is violently opposed. Third, it is accepted as being self-evident. -- MySQL General Mailing

Installing MySQL on Fedora

2003-11-29 Thread Todd Cary
I tried installing MySQL on Fedora and all seemed to go fine, but there is no mysqladmin.   Have I missed something here? And I am not sure where the mysql executable resides.  The version is MySQL-3.23.58-1.i386.rpm Todd -- <>

Export in XML

2003-12-01 Thread Todd Cary
Is there a way to export/import MySQL tables in XML format? Todd -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Export in XML

2003-12-01 Thread Todd Cary
Jay - I am not an expert with XML, however I use it with Delphi and Delphi's TClientDataset. In this usage, I use the builtin SaveTo and LoadFrom methods. Todd Jay Blanchard wrote: [snip] Is there a way to export/import MySQL tables in XML format? [/snip] Well Todd, it is a little

Re: Export in XML

2003-12-01 Thread Todd Cary
John - Right under my nose!  Thanks Todd John Griffin wrote: Look at http://www.mysql.com/doc/en/mysql.html. The -X option may give you what you need. -Original Message- From: Dan Greene [mailto:[EMAIL PROTECTED]] Sent: Monday, December 01, 2003 9:57 AM To: Todd Cary; Jay

Re: Export in XML

2003-12-01 Thread Todd Cary
Dan - Or from my place, "It pays for me to read the docs - thoroughly".  Oh!  Docs!  What are they? :-[ Todd Dan Greene wrote: The most guarenteed way to have a feature in a product pointed out is to make a public statement that it's not available :) keyboard in mout

Ignore Replication Temp Tables

2004-01-20 Thread Todd Burke
Is there any way to disable replication of all temp tables using replicate-ignore-table or some other means? The names of the temp tables are generated randomly by a script. Thanks Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Batch Deletes...

2003-06-09 Thread Todd Gruben
ed data. This takes about 30secs and my delete scripts takes about 4 hours. It is deleting about 500,000 rows out of a 4 million row table with several indexes. -Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BTREE indexes in Heap table

2003-06-10 Thread Todd Gruben
how do your set the index type in 4.1? My tables still appear to hash indexes. -Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1 not using btree index on heap table on an UPDATE

2003-06-13 Thread Todd Gruben
Any reason why a SELECT which finds no matches returns instantly but an update which has the same where clause takes about 2 secs to return. explain reports that the select is exaninng 10 rows in a 300,000 row table. which is exactly what i am expecting. are there any know issues? -Todd

Replication Performance

2003-06-24 Thread Todd Burke
ce? 2/ Is there any documentation on handling and configuring large tables? Hope this is not too confusing... Many thanks Todd Burke phbnyc.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Dual / Single CPU

2003-06-30 Thread Todd Burke
cpu? These boxes will be used mostly as readers (delayed inserts done thru replication). Thanks -- Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Dual / Single CPU

2003-06-30 Thread Todd Burke
so mysql can take full advantage of the dual cpu w/out a recompile? Thanks --Todd On Mon, 30 Jun 2003, Mike Wexler wrote: > > > Todd Burke wrote: > > >Which is the better option to host mysqld: > > > >MACHINE A: > > > > 2.4 GHz CPU > >

Can't start MySQL on Mac OS X

2003-07-02 Thread Todd O'Bryan
27;s running because /tmp/mysql.sock doesn't exist and when I run mysql I get: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Any ideas? Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't start MySQL on Mac OS X

2003-07-02 Thread Todd O'Bryan
OK. I've verified that no mysqld is running using Egor's command from below, and by using netstat (which someone else suggested) there is nothing listening on port 3306. Any new ideas? Thanks, Todd On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote: "Todd O'Brya

OS X downloads

2003-07-02 Thread Todd O'Bryan
There are two sets of binary downloads at mysql.com for Mac OS X. They're different sizes, but both say OS 10.2. Is that a typo? Is one of the two for OS 10.1, and could I have downloaded the wrong one and could that be the reason I can't get mysql to start? Todd -- MySQL General Ma

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread Todd O'Bryan
Do what it says: cd /usr/local/mysql ./bin/mysqld_safe and see if that's any better. Todd On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote: Hi, I got the following message when trying to start the mysql instance: $ mysqld_safe & [1] 22717 $ The

Re: Can't start MySQL on Mac OS X

2003-07-02 Thread Todd O'Bryan
I figured out what happened, though I don't know when it happened... I had screwed up the permissions for the /tmp/ directory, so the mysql user could not create the socket it needed there. A well-placed chmod and things are back in working order. Thanks to all for the suggestions,

Re: The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable

2003-07-02 Thread Todd O'Bryan
point (actually, we were at the limit of my knowledge when I told you to try cd-ing and re-typing the command) and I'm just throwing out possibilities... Todd On Wednesday, July 2, 2003, at 08:57 PM, [EMAIL PROTECTED] wrote: Todd, It didn't help. Here is the message:

Re: select help

2003-07-06 Thread Todd O'Bryan
I'm new, too, so someone correct me if I'm wrong, but... if you make it an ENUM field in a table you can store it using the value in the selection, retrieve it as the same value, and still get all the advantages of numeric storage. Todd On Sunday, July 6, 2003, at 02:38 PM, Dan

Restoring from a mysqldump

2003-08-03 Thread Todd Cary
I have a file produced by mysqldump and I need to restore it. Can someone point me toward the instructions on how to do this? Todd -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Granting privileges

2003-08-03 Thread Todd Cary
I have installed Red Hat 9 and it installs MySQL.  After logging on as root, I did the following: mysql mysql> use mysql; mysql> grant all -> on * -> to todd indentified by 'my_password' -> with grant option; I then log out of mysql and log out as root.  Logge

Re: Granting privileges

2003-08-03 Thread Todd Cary
Jamie - Two questions: 1) Does "grant all" give the user the rights to create a database. 2) What is the difference between "on * " and "on *.* " Todd Jamie Krasnoo wrote: You still need to flush the privileges. Changes in permissions are not automatica

Re: Granting privileges

2003-08-03 Thread Todd Cary
Jamie - <<< grant all on *.* to [EMAIL PROTECTED] identified by 'some_password' with grant all; flush privileges; >>> That definitely works, but what I am not sure about is now -u todd -h localhost has all "Y" in the privileges; before only the first few

Re: Granting privileges

2003-08-03 Thread Todd Cary
I did some experimenting and here is what I found: grant all -> on * -> to bugsbunny indentified by 'bugs -> with grant option; After putting the above into MySQL as root, I signed on as "todd" with the appropriate PW and tried to get into mysql with mysql

Re: Granting privileges

2003-08-03 Thread Todd Cary
Roger - Thank you for taking the time to clarify that for me.  I was using "PHP with MySQL" and they are not clear on the differences I found and you explained. Thanks again Todd Roger Baklund wrote: * Todd Cary I did some experimenting and here is wh

Re: Revoking select on a single table

2004-08-30 Thread Todd Charron
> Thanks for all your help. This may be the best solution available. Would it be possible to get it posted to a faq or mentioned in the docs? I imagine it's a situation that may come up frequently for users. Also, if you have any ideas on how one might perform updates on specific

Re: Revoking select on a single table

2004-08-30 Thread Todd Charron
(encrypted or not) cannot be retrieved via that account, only overwritten. > > UPDATE secrettable SET column = 'value'; > > DELETE FROM secrettable; > That may be possible, but I can't really see anywhere where that would be useful. Thanks. Todd -- MySQL Gene

Re: Revoking select on a single table

2004-08-30 Thread Todd Charron
Thinking about this some more, it might be possible to achieve what my last email suggests by allowing select on the primary key column. Or would that set us back again? Thoughts? Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Revoking select on a single table

2004-08-30 Thread Todd Charron
le set secretinfo="blah" where ID_Num=2; So far as I've been testing this seems to work while preventing the user from ever selecting what's in the other secrettable columns. Thanks again! Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Problem running MySQL in high school lab

2004-08-30 Thread Todd O'Bryan
ows XP Professional machines, and the students log into a domain hosted by a server in another teacher's lab. Any ideas appreciated, Todd P.S. If you could cc me any replies, I'd appreciate it, since I read the list on digest. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cygwin and High School Lab

2004-08-31 Thread Todd O'Bryan
x27;m going to try running MySQL from the Windows command prompt today to see if that makes a difference. Thanks, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Crash on Windows XP SP2 when not run as an administrator

2004-08-31 Thread Todd O'Bryan
I've tested mysql in my high school lab running from an administrator and from a student account, both from within the Cygwin terminal, and at the Windows command prompt. From the administrator account, it runs fine for hours. From the student account, it promptly (within 15 seconds or so) cras

4.1 client protocol?

2004-09-16 Thread Todd Gruben
uch a beast exist? --- Todd Gruben -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

DECIMAL math?

2003-09-07 Thread Bill Todd
Since DECIMAL fields are stored as strings how are calculations performed? Does MySQL use string math routines or does it convert the string to a double and use the double for the calculation? The real question is, can floating point imprecision errors occur when using the DECIMAL type? Bill --

BDB transaction isolation levels?

2003-09-08 Thread Bill Todd
What transaction isolation level(s) does BDB support? I can't find any information on BDB transactions section 7.6 of the manual. Thanks, Bill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Difference between Serializable and Repeatable Read with InnoDB

2003-09-08 Thread Bill Todd
Since InnoDB does not allow phantom reads with Repeatable Read isolation (which are allowed in the ANSI SQL definition of Repeatable Read) what is the difference between these two isolation levels. Is it just serialization and that is all? Bill -- MySQL General Mailing List For list archives: h

Do InnoDB rollback segments expand dynamically?

2003-09-08 Thread Bill Todd
Using InnoDB with an autoextend tablespace, if I start a transaction that results in many record versions, will the rollback segments grow dynamically and force the tablespace to grow dynamically to provide the required room for record versions in the rollback segments? Bill -- MySQL General Ma

RE: Do InnoDB rollback segments expand dynamically?

2003-09-09 Thread Bill Todd
; From: Heikki Tuuri [mailto:[EMAIL PROTECTED] > Sent: Monday, September 08, 2003 10:44 PM > To: [EMAIL PROTECTED] > Subject: Re: Do InnoDB rollback segments expand dynamically? > > > Bill, > > - Original Message - > From: ""Bill Todd"" <

How much memory does MySQL need?

2003-09-09 Thread Bill Todd
I know, I know, with database servers more is always better. However, assume I need to deploy MySQL using InnoDB to multiple sites. Hardware cost is a significant consideration. Is there any information available on MySQL's memory requirements? Most database vendors give you something as a starting

How identify long running query etc?

2003-09-10 Thread Bill Todd
Using MySQL and InnoDB, are there system tables or other tools that I can use to see which statements that are executing have consumed the most CPU time and find out which user, transaction and/or connection those statements belong to? If I identify a user that is causing a problem is there a way

Is the table cache used with InnoDB?

2003-09-10 Thread Bill Todd
I cannot tell from the Reference Manual whether the table cache is used with the InnoDB database engine or not? It sounds like it only applies to tables that are stored in separate disk files. Is the table cache used by InnoDB? Bill -- MySQL General Mailing List For list archives: http://lists

Iterating thru FullText Index

2004-03-05 Thread Todd Burke
Is there any way to iterate thru the keys in a fulltext index? This issue does not come up for other indexes since ORDER BY can achieve this: For example if table t is indexed on part_id SELECT DISTINCT part_id FROM t ORDER by part_id; will return all keys in index order Is there a way to do

Front end for MySQL databases

2002-11-27 Thread Todd Cary
what others use for front-ends to MySQL DB's. Also, the site will only allow SSH connections and the client is using a Windows platform. Many thanks.... Todd - Before posting, please check: http://www.mysql.com/manua

Using PHP to do a MySql Dump

2002-12-20 Thread Todd Cary
Is there a function that can be implemented with PHP to do the equivalent of a mysqldump? Todd -- Ariste Software, Petaluma, CA 94952 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Select newest records

2003-03-14 Thread Todd W
I am having troubles with queries, selecting only the newest records. Select ID,title,article From news ORDER BY ID LIMIT 0,2 I tried this but it always shows the first two records and I want to select the last two records(newest ones added). Can someone help out? Thanks -

Importing into an AutoIncrement field

2003-03-21 Thread Todd Cary
my value and overwrite it with the "auto" value? The next is question is the command line syntax for importing a file liek the above? I have never done it and I am using the Linux version of MySQL. Todd -- Ariste Sof

Restoring a DB

2003-03-25 Thread Todd Cary
If I have a file, mydb.mbk that was created with mysqldump, how do I recreate/restore the DB? Do I run a command line using "mysql" with a switch and "mydb.mbk"? Todd -- Ariste Software, Petaluma, CA 94952 \n [EMAIL PROTECTED]

Can't uninstall, reinstall, or otherwise get 4.0.12 to work on Mac OS X

2003-03-30 Thread Todd O'Bryan
OS X computer, but I really need a working version on my iBook. Any help, pointers, or insight greatly appreciated! TIA, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OS X errors (using 4.0.12 package installer)

2003-03-30 Thread Todd O'Bryan
hutdown... 030330 16:51:18 InnoDB: Shutdown completed 030330 16:51:18 /usr/local/mysql/bin/mysqld: Shutdown Complete 030330 16:51:18 mysqld ended Any idea what to do now? And shouldn't the installer be taking care of all of this semi-automatically? Todd -- MySQL General Mailing Lis

Still Mac OS X problems (4.0.12)

2003-03-31 Thread Todd O'Bryan
connect to local MySQL server through socket '/tmp/mysql.sock' (2) Help! If anybody has any idea how to fix this, I'd appreciate it. TIA, Todd -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mac OS X package problems

2003-04-01 Thread Todd O'Bryan
on questions they haven't successfully answered yet, but it's hard to be successful at that if I don't have a working mysql installation. Each student has entered 6 or 7 questions as an XML document, and I just have to get them into the database and set up a quiz program. Thanks, Tod

JDBC can't connect, but command line can...

2003-04-02 Thread Todd O'Bryan
'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test; Database changed mysql> show tables; Empty set (0.00 sec) mysql> - I've searched for info on troubleshooting the JDBC connection and skimmed the O'Reil

Re: JDBC can't connect, but command line can...

2003-04-02 Thread Todd O'Bryan
s ::1: Connection refused Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 0 4.0.12-standardTwz!2tvp, Bad handshakeConnection closed by foreign host. --- 4.0.12 looks like it's MySQL, but I have no idea what this means. This at least looks l

Re: JDBC can't connect, but command line can...

2003-04-03 Thread Todd O'Bryan
ly if you forget what all is involved in the switch. Color me stupid, Todd On Wednesday, April 2, 2003, at 10:56 AM, Mark Matthews wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Todd O'Bryan wrote: | I've managed to get mysql up and running again (I don't know how) but | JDBC

Re: About JDBC

2003-04-05 Thread Todd O'Bryan
It should be enough to place the .jar file in the jre/lib/ext folder (Binside your Java installation folder. If you don't want to do that, you (Bcould modify your CLASSPATH environment variable to include wherever (Byou decide to place the .jar. (B (BTodd (B (BOn Saturday, April 5, 2003,

  1   2   3   >