MySQLDump and Restore

Hi All, Am using mySQLDump to backup db as follows mysqldump --databases OURDB -uroot -pROOTPASSWRD > dump.sql How can I restore OURDB from dump.sql? Thanks Jim

"optemizer" for mySQL!

Hi All, Didn't know there was an "optemizer" for mySQL. Where can I get it from? Thanks Jim Best regards, Jim Clark Project Manager Multilink Systems Ph: 03 9425 9400 Fax: 03 9425 9811

RE: "optemizer" for mySQL!

:05 AM To: Jim Cc: mysql@lists.mysql.com Subject: Re: "optemizer" for mySQL! http://www.devshed.com/c/a/MySQL/A-Technical-Tour-of-MySQL/ The MySQL server has it built in. -Sheeri On 5/8/06, Jim <[EMAIL PROTECTED]> wrote: > Hi All, > > > > Didn't know there was

Auto Install mySQL

Hi All, Does anybody have some advise on automating the install of mySQL and our DB on a PC/Laptop with no user interaction required. Does the SETUP.EXE take any paramaters to auto install without the user dialogs? Thanks, Jim

max_allowed_packet via SQL Statement

Hi All, Is there any way of getting the max_allowed_packet setting via a SQL statement? Eg. select version(); returns the version and need to do same for max_packet_size.

RE: Determining if a trigger exists

There is a TRIGGERS table in the information_schema Eg. select Trigger_Name from TRIGGERS where trigger_name = 'TI_AGENT' AND trigger_schema = 'PROPLINK' -Original Message- From: Adrian Co [mailto:[EMAIL PROTECTED] Sent: Friday, 7 April 2006 1:54 PM To: mysql@lists.mysql.com Subject:

Any limits on Database Size?

Hi All, We used to use Interbase which required a new file to be assigned for every 4 gig of data stored in a DB. Is there any issues like this in mySQL? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

MySQL Encryption

etric encryption capabilities? What are people using in terms of a good solution for encrypting specific columns of table data while providing protection of the key? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?

Re: MySQL Encryption

e security to prevent unauthorised access". Thanks, Jim On 3/19/2010 6:39 AM, John Daisley wrote: Jim, I tend to derive a key based on a separate character string and the contents of the data in the same or a related table. This means each row has a unique encryption key and you never hav

Re: MySQL Encryption

Hi Neil. Information (in most cases a string < 100 chars, but that's probably not important) that actually needs to be decrypted, so a hash won't do. Jim On 3/20/2010 5:09 PM, Tompkins Neil wrote: Hi What sort of information are you looking to encrypt ? If it is for user

inconsistent optimization

Without going into specific details on queries... Using mysql 5.1 as provided with CentOS6, I've noticed some queries providing what I can best explain as inconsistent optimization. The database can be quieted to just controlled queries and at times the same query will return very quickly when

Re: inconsistent optimization

innodb On 8/20/2014 1:22 PM, Martin Gainty wrote: Jim/Jaime What engine are you implementing?/ Qual mecanismo de MySQL que você está implementando? Saludos desde Sud America Martín Date: Wed, 20 Aug 2014 13:54:46 -0300 Subject: Re: inconsistent optimization From: edua...@gerencianet.com.br

Re: MySQL 5.1.22 is out

Is there any kind of timetable for when 5.1 is actually expected to be released? - Original Message - From: "Kaj Arnö" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Wednesday, October 17, 2007 3:07 AM Subject: BLOG: MySQL 5.1.22 is out MySQL users, Sorry for spamming mysql@lists.mys

Table type for high number of insert/delete operations

I have an application which will be inserting and then deleting many thousands of rows per hour within a single table. It essentially queues and then handles requests from a series of processes, deleting the requests after they've been dealt with. Our MySQL 5.0.45 server is set up to use Inno

Unusual sort

I have a table containing web site host names, most of them having both a "name.com" and "www.name.com" version, that I'd like sorted in the following manner: axxx.com www.axxx.com bxxx.com www.bxxx.com wxxx.com www.wxxx.com zxxx.com www.zxxx.com Any way to do this? -- MySQL General Mailin

key_buffer_size and InnoDB tables

On the following page and in the example ini files installed with MySQL it's suggested that key_buffer_size is an option that affects MyISAM performance. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html But on the following page about tuning MySQL server parameters, it says

Re: The current version is 5.0.48, no?

Can these be legally run without a license? Is the only difference that MySQL AB doesn't publish links to the current version on their web page, instead purposely choosing to leave the community version several revisions behind? Yeah, I'm a little confused. - Original Message - Fro

Re: When to create a new user?

to damage control in case of a db related exploit. You'd make this call based on how sensitive and important your data is and how much effort you are willing to put into the planning and design. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: When to create a new user?

On 8/19/2015 9:24 AM, Reindl Harald wrote: Am 19.08.2015 um 15:18 schrieb Jim: On 8/19/2015 8:40 AM, Reindl Harald wrote: Am 19.08.2015 um 14:29 schrieb Richard Reina: I am writing a web application in perl that will create, edit, update and delete data from a MySQL database. I have written

Connections from mysql8.0 to mysql5.1 - bad handshake

I'm attempting just isn't going to work? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Replication and user privileges

rding replicated queries irrelevant on the slave and that is handled all internally via the replication thread with no regard to user privileges? Thank you. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Replication and user privileges

On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user privileges. I understand on the master, the replication user must have the Repl_slave_priv

Re: Replication and user privileges

On 2/26/2019 9:44 AM, shawn l.green wrote: Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but have a question about user

Re: Replication and user privileges

On 2/26/2019 1:57 PM, Jim wrote: On 2/26/2019 9:44 AM, shawn l.green wrote: Hello Jim, On 2/25/2019 7:29 PM, Jim wrote: On 2/25/2019 5:46 PM, shawn l.green wrote: Hello Jim, On 2/25/2019 5:04 PM, Jim wrote: I have a question about mysql replication. I believe I understand most of it, but

Re: Generic graphing tool?

describe, but you could build one without TOO MUCH pain using CharDirector (a free version is available from http://www.advsofteng.com/) and your scripting language of choice. I prefer PHP or Perl, myself. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

mysql client connectivity and "orphaned" connections

t possible that the first process stops doing anything when the ssh connection is dropped? Is there any way, other than "show processlist" to tell whether something is actually going on? Whether there is actual progress? Thanks! Jim -- MySQL General Mailing List For list archiv

help tuning a DB installation

Hi. I'm wondering if anyone can help me tune this database so it runs better on my hardware. I've made some attempts, but either they've made it worse or not changed anything. Changing the database design itself has shown the most improvement, but I'd still like to know how to tune things on

4.0.20: index being ignored in simple query

9.0, kernel 2.6.6. Could the problem be related to memory size, ie is the index too big? If so, how come it uses part of the index rather than none at all? Any help very much appreciated and guruhood grovellingly acknowleged. Thanks Jim Page Relevant data follows

Can records be moved between tables without knowing columns

appens with autoincrement, timestamp fields?) Thanks for the help; I hope it isn't a trivial question. I'm new at this; I didn't find anything on moving records in the list archives. Jim Cant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Replication and Error 1200

in.045', -> MASTER_LOG_POS=4606; Query OK, 0 rows affected (0.00 sec) This runs ok, but slave start; gives the error. This is in mySQL 4.0.12, on Linux. Sorry if that's too much information. Thanks to any and all for comments or help. Regards, Jim N. -- MySQL

Server not configured as slave

config file information from the other slaves to the new slave. Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Server not configured as slave

em? >Also, is there anything in the *.err > file on this machine? Nothing but record of server startups and shutdowns. Thanks for your help. -Jim > > -Original Message- > From: jim > To: [EMAIL PROTECTED] > Sent: 4/14/04 3:26 PM > Subject: Server n

Re: Server not configured as slave

> "jim" <[EMAIL PROTECTED]> wrote: > > > >> Does this machine have a valid server-id? Run show variables like > >> 'server_id' from the mysql monitor. > > > > Interesting. The my.cnf says "server-id = 75" but the &qu

[MySQL] Using the MAX() value in WHERE clause

P BY is added. Is there a way to do this, so that the SELECT can get only values for users who have validated LIKE 'N' and their dateCreated is 10 days before the latest dateCreated? Thanks for your help. Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/m

Re: [MySQL] Using the MAX() value in WHERE clause

> jim wrote: > > > Hi, > > > > The task is to find users whose accounts have not been validated for the > > last 10 days. This SELECT accomplishes that: > > > > SELECT * FROM user WHERE validated LIKE 'N' AND dateCreated <= > > DAT

[MYSQL] Multiple instances of server starting

thers have had this problem, but the answer there does not really explain why these two servers are behaving differently. Can anyone help? Thanks very much! -Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [MYSQL] Multiple instances of server starting

Thanks, Paul. The machines are running RH 9 (one instance) and Fedora Core 1 (multiple instances). It's not really a problem, so much as a curiosity about whether the one with more processes showing was using more resources. Jim On Friday 30 April 2004 07:36 pm, Paul DuBois wrote: &g

[mysql] replication of database structure changes

replication is for data and not for structure, but a formal explanation of what exactly that means is hard to find. Thanks again. Jim N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

OPTIMIZE TABLE and mySQL replication

Hi List, What are some issues relating to using OPTIMIZE TABLE and replication? Does running OPTIMIZE TABLE on a master DB cause the optimizations to be passed on to the slaves? Thanks, Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: OPTIMIZE TABLE and mySQL replication

Jeremy Zawodny wrote: On Fri, May 14, 2004 at 03:10:05PM -0400, Jim wrote: Hi List, What are some issues relating to using OPTIMIZE TABLE and replication? Does running OPTIMIZE TABLE on a master DB cause the optimizations to be passed on to the slaves? It does not. The command doesn&#

Disproportionately slow, but simple, query

of getting the data off the disk and to the client, or something else? Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request th

Found it (was Re: Disproportionately slow, but simple, query)

FYI: Setting up a lab environment for this database answered my question. I moved the big field to a dedicated table, and queries on data_static got much faster. Instead of 60 seconds, the query is done in less than 1. Thanks for all the ideas people sent me privately. Cheers, Jim

MySQL

/workinout/search.html It should be up most of the time, and over time, I will add improvements. Its fast, and simple to use, and its 100% MySQL related. Comments welcome anytime. Thansk Jim Danforth - Before posting, please check

MySQL search engine

a list of useful links, parsed from the emails b. produce a dynamic FAQ page c. summarize problems into a dynamic top ten list d. other useful sorts, filters and regex output, as i think of it. Comments welcome anytime. Thanks Jim Danforth

Changing root access on MySQL

'You must have privileges to update tables in the mysql database to be able to change passwords for others' AFAIK my syntax seems correct but knowing so little about MySQL at this point I confess to being stuck. Thanks to anyone willing to help me ou

Q: Linux - ODBC - MySQL

ver - - - - - - testone.tpl - - - - - - - - - - [thisURL] [sql dsn=MySQLone&username=martin&password=number9&statement=SELECT * FROM Beatles;] Found [NumFound] items [FoundItems] Name = [Name], inst = [inst]

myODBC on Linux newbie question

river when .iodbc.ini files has changed. how do I do that? For that matter, how do I start MyODBC / iODBC ? these are simple questions, but there is no place I've found that talks about MyODBC linux in detail. MySQL is running on another Linux box and is talking to Webmin just fin

Re: myODBC on Linux newbie question

We are using a shopping cart / front end called WebCatalog and it needs ODBC. I know there are other solutions, but if we can get ODBC working then there is no code change for WebCatalog - Jim >why are you using ODBC if you're trying to connect from one linux box to >a MySQL data

Re: Download older versions

ves where these older > RPM's can be downloaded ... if so, where would they be located ?? Old releases can be found at: http://downloads.mysql.com/archives.php Specifically, the RPM packages for 4.0.26 can be found at: http://downloads.mysql.com/archives.php?p=mysql-4.0&v=4.0.26

Re: Where is the more detailed document of MySQL Network?

pport system. 'Remote Troubleshooting' means that MySQL support engineers will log in to your systems to troubleshoot problems. There is more information about this here: http://www.mysql.com/company/legal/supportpolicies/policies-08.html Jim Winstead MySQL Inc. -- MySQL General Maili

Re: Many sources are in correct. For example the Gui Tools.

e gone to SVN where are the publice repo's? You can find the SVN repositories for the GUI tools and Connectors at http://svn.mysql.com/ The server repositories are still at http://mysql.bkbits.net/ Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists

Re: mysql4.0

ase. There are currently no plans to release a new version of 4.0. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sub-query optimizer improvements scheduled?

his "Speeding Up Queries" session at the MySQL Users Conference, optimizations for subquery performance are currently scheduled for the 5.2 release. (And as I'm sure Robin and Zack covered at one of their talks on the MySQL roadmap, 5.2 is currently scheduled to reach a production re

Re: Security fix for 4.0.27?

On Mon, Jun 05, 2006 at 10:16:05PM -0700, Ken Williams wrote: > Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue? > (http://lists.mysql.com/announce/364) > > 4.1 and 5 have been already, kinda wondering why 4.0 hasn't. It will not, because 4.0 does not ha

Re: Differences between MySQL 4 and 5 for scripts

e of a VARCHAR is 255 bytes in MySQL 4.0, and about 64K characters in MySQL 4.1 and later. > Can you load a v5 server with a v4 script? Yes, you can generally load scripts written for MySQL 4.x into MySQL 5.x. You may also want to use the special syntax for specifying version-specific parts of

Re: Random Hangs, Linux AMD 64, 5.0.22 AB Binaries

Sounds like the well-known problem with Debian stable's glibc on x86_64: http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: connecting to the embedded server

lling mysql_real_connect(). http://dev.mysql.com/doc/refman/5.1/en/mysql-options.html Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.1.21 has been released

ter releases.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why release 5.0.23 instead of 5.0.24?

see that some 5.0.23 binaries are listed on the 5.0 download page -- this is a mistake.) Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqlimport csv file import problem

to find an easier way than typing all of the data into a text file for import. Thanks, -- Jim Seymour <[EMAIL PROTECTED]> signature.asc Description: This is a digitally signed message part

Re: mysqlimport csv file import problem

On Mon, 2006-08-28 at 13:47 +0200, Thomas Spahni wrote: > On Sun, 27 Aug 2006, Jim Seymour wrote: > > > Hi, > > > > I download a csv file from Yahoo in this format: > > > > ABIAX > >20.63 > >

Re: Issues on Debian-AMD64 - looking for ideas or help.

IVE_MUTEX_INITIALIZER_NP" > > I'm wondering though - am I missing something here? This is a bug in the version of glibc being shipped with Ubuntu, and apparently Debian as well. Here's the Ubuntu bug for tracking it: https://bugzilla.ubuntu.com/show_bug.cgi?id=11730 There

Re: offer a solution ?

No, you don't want a table for each monitor. One table for the data will be _much_ easier to work with. If you want a history then you need to insert a new record for each datapoint that you get, with, as Frank suggested, a date/time column. How large your table will get will depend on the n

Re: mysql user name length

f > any troubles this may cause... Yes, there are a number of places within the server that only expect the username to be 16 characters, and will almost certainly break in the face of longer usernames. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http:/

Re: reply to header?

On Tue, Aug 02, 2005 at 02:38:01PM -0400, Jason Pyeron wrote: > why does this list not have the reply to header set? This is covered in the mailing list FAQ at http://lists.mysql.com/faq.php Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: Federated engine and "comment"???

elease. This is fixed in 5.0.13, the documentation just hasn't caught up with the change yet. The new syntax is CONNECTION = '...'. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Stored procedures MS SQL Server to MySQL

putting various parts of the query into the parentheses. The error messages always seem to occur around the @count variable. I am using MySQL v.5.0.12 on Debian Etch. TIA, Jim Seymour -- I started using something better than the "standard" back when IBM advertised OS/2 Warp on TV

Re: Stored procedures MS SQL Server to MySQL

On Sun, Sep 25, 2005 at 03:56:46PM -0500, Peter Brawley wrote: > Jim, > > If you really want to return the result in a variable, declare a user > var in the client, declare an OUT var in the SP, have the SP SELECT INTO > it, and pass the user var to the SP in the call: >

Re: MySQL 5.0.13-rc has been released

Is this a "release candidate" as the version in your message subject would imply, or is it an actual "release", as your message states? Or does MySQL AB even bother to differentiate the two? - Original Message - From: "Lenz Grimmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: ;

Problems setting up on Mac OS X

I had the same problem with both of these: mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg and mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg They seem to install OK, but when I set the root password I can't get in afterwards as root. Clues? Jim C. -- MySQL General Mailing Lis

Re: Problems setting up on Mac OS X

Jim C. wrote: > I had the same problem with both of these: > > mysql-standard-4.1.14-apple-darwin7.9.0-powerpc.dmg > and > mysql-standard-4.0.26-apple-darwin7.9.0-powerpc.dmg > > They seem to install OK, but when I set the root password I can't get in > afterwards as

Re: Problems setting up on Mac OS X

ormation. I'll look around for this kind of stuff. . I'm not fond of the idea, but perhaps if I can't get it working, I'll try compiling it from source. Jim C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Financial return calculations help please

v5.0.12 on Debian Linux. TIA, Jim -- I started using something better than the "standard" back when IBM advertised OS/2 Warp on TV. As Linux matured I made the transition from OS/2 v4 to Linux. You don't have to accept less than you deserve. "Use the Power of the Penguin&qu

Re: Financial return calculations help please

On Wed, Oct 05, 2005 at 11:23:00AM -0700, Mike Wexler wrote: > Jim Seymour wrote: > > >I have researched repeatedly and cannot find an answer to the following. I > >need to do something like the following (There is probably an easier > >way). > > > >end_d

Re: Does the MySQL mailing list use MySQl to manage the mailing list?

lm.org/). The subscription lists are kept in a MySQL database, the message archives are simply kept in the filesystem, the index of messages used by the news server and web archive are kept in MySQL, and the search index is kept in MySQL. Jim Winstead MySQL Inc. -- MySQL General Mailing Li

ALTER TABLE - how to fix truncated data?

running MySQL v5.0.13 on a Debian Etch(Testing) box. TIA, Jim Seymour -- I started using something better than the "standard" back when IBM advertised OS/2 Warp on TV. As Linux matured I made the transition from OS/2 v4 to Linux. You don't have to accept less than you deserve. "

Setup for MythTV

Where can I get tips on how to manually set up MySQL for MythTV? MythTV's site was not very helpful in this regards. Jim C. signature.asc Description: OpenPGP digital signature

Re: Setup for MythTV

> So follow the installation directions appropriate for the flavor of Linux > you are using. That's where MySQL lives, in the OS, not the application As far as I can tell, there are none. At least not for Mandriva. The attitude seems to be that MySQL is "just the backe

Re: Setup for MythTV

Hey! Those are some pretty handy looking links. :-) Thanks!! > Did you see this: > > http://www.mythtv.org/docs/mythtv-HOWTO-6.html > > And also: > > http://wilsonet.com/mythtv/tips.php (see the section on Front Ends) > > And lastly: > > http://dipper.info/project/ivtv/ > signature.asc

Re: Problem ( large problem ) with date fields after 4.0.x to 4.1.x upgrade

| > +--+ > 1 row in set (0.00 sec) > > *BIG* problem! What's up with the 2005-09-30 record? Perhaps I'm missing something, but 2005-09-30 looks like the maximum value of EAPDate in the data above. What did you expect the result to be? Jim Winstead MySQL Inc. -- M

Re: Aborting slipped keys

ot;> > > I tried all the \c commands and nothing will get me out of it, I can ^c and > it will get me out, but then I have to login again, which is a pain, how can > I tell mysql to drop me back to a clean prompt? Just close the open quote before you use \c mysql> select &

Re: any alias for MySQL cluster question?

On Fri, Nov 18, 2005 at 02:41:30PM -0800, Jenny Chen wrote: > I'd ask some questions on MySQL cluster. Does anyone know if there is any > email alias for the cluster questions? Yes, there is a mailing list for MySQL Cluster: http://lists.mysql.com/cluster Jim Winstead MySQL Inc.

Re: MySQL Control Center

much lately but at least mycc, even in its beta stage, is > fairly useful. Development of MySQL Control Center was halted a couple of years ago. The new GUI tools (Query Browser, Administrator, etc) are still under active development. Jim Winstead MySQL Inc. -- MySQL General Mailing List Fo

Re: transaction with bdb table gives error "Lock table is out of available locks"

-O bdb_max_lock=12 but i still > receive the same error. Hi Marco. What does 'SHOW CREATE TABLE' look like for your table? You may want to file a bug about this and attach your data and the actual queries being run. I was not able to come up with a test case to reproduce

Re: this listserv function...?

This is addressed in the FAQ for the mailing lists. http://lists.mysql.com/faq.php#replyto Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 5.1 Delopment source

1 mysql-5.1 The name of the repository was changed to mysql-5.1-new, and it looks like the documentation may not have been updated. try: sfioball -r+ bk://mysql.bkbits.net/mysql-5.1-new mysql-5.1 Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Performance Problem on query kind of like a group by

M read_rnd_buffer_size = 3m These have not had any effect. Also caching is not an option because the first hit in one of my more complicated use cases takes over 7 seconds. Someone please help. karma is yours if you can help me on this. Thank You Jim Tyrrell -- MySQL General Mailing List

socket error

[mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Thanks Jim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Replication

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:

Re: Trying to Create a Trigger

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

Re: How many users access MySQL

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

Re: Partial Replication

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

Re: Performance tips

now() - it's a non-deterministic function. -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: long login times?

Jed: Are you using an in-network IP to access the database ie: 127.0.0.1 192.168.98.## or are you using a public IP or full domain name ie: DB001.MY-DOMAIN.COM ... Jim > I've started logging how long my php application takes to login to > mysql, and often it's well bel

Re: [PHP] Because you guys/gals/girls/women/insert pc term here are a smart lot

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

Re: UPDATE jujitsu?

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

Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?

> 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

Re: timeout

a timeout problem. > How can I increase the timeout period. > TIA > mosaed > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com

Re: How do you backup HUGE tables?

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

how can trace stored procedure usage?

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

  1   2   3   4   5   6   7   8   >