mysql replication

2012-08-28 Thread aaron zhang
Hi all i use mysql database,when i use mysql replication ,the slave host do not replication,i check the error message,i found error message,it is 'row is too large', i do not understand why,please tell and help me ,thanks

Re: explain shows type = ALL for indexed column

2010-12-07 Thread Aaron Turner
g-subqueries.html > > If you have further questions after doing that, show the table structures, > the query, and the explain output. > -- Aaron Turner http://synfin.net/         Twitter: @synfinatic http://tcpreplay.synfin.net/ - Pcap editing and replay tools for Unix & Windows

explain shows type = ALL for indexed column

2010-12-07 Thread Aaron Turner
d tweak to solve this specific issue. Server is a dual-quad core w/ 4GB of RAM, although it's not dedicated to MySQL (webserver and some other database centric background jobs run). Table1 however is on a dedicated RAID1 disk pair and is getting regular inserts/deletes (it's a log table).

Re: substring query

2010-06-10 Thread Aaron Savage
Sorry Jay, Here is what I came up with. select substring(substring_index(myfile,'.',-2),1,4) AS MyColumn from mydatabase group by MyColumn; That appears to yield what I need. I just need to filter out the results that do not have an extension. -Aaron On Thu, Jun 10, 2010 at 9:

Re: substring query

2010-06-10 Thread Aaron Savage
re wording. I want to cut that off. Also, some paths do not have an extension and I am trying to ignore those. So simply. I am just trying to pull out the file extension but there were some conditions I did not list. -Aaron > > SUBSTRING_INDEX should do what you want. > >

substring query

2010-06-10 Thread Aaron Savage
;html'. The only common they all have is the period before the extension. Anyone created a nested substring query that can do what I am looking to do? Thanks, Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/m

Re: Replication switch Master to slave and back

2009-07-08 Thread Aaron Blew
ce they're both writable. -Aaron On Wed, Jul 8, 2009 at 1:38 PM, Cantwell, Bryan wrote: > I have successfully set up a replication master/slave scenario with my > MySQL 5.0.51a > Now in the event of a fail over to the slave (an identical appliance), I > want the old master to becom

Ordering an IN query

2009-06-05 Thread Aaron Fischer
build the query. Is there some way of doing that? Thanks, -Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Best RAID for a DB + LVM?

2009-02-24 Thread Aaron Blew
n't terribly large would be to cram as much RAM in the host as you can. If you've only got a portion of your data that's heavily accessed, keeping it in RAM would be ideal. -Aaron On Mon, Feb 23, 2009 at 9:17 AM, Brent Baisley wrote: > SCSI isn't necessarily faster no

Re: SPARC to x64 Transition

2009-02-18 Thread Aaron Blew
This is confirmed working on a small test set with MySQL 4.1.22 transitioning from SPARC to X64. Thanks everyone! -Aaron Here's the test set we used: CREATE TABLE `test_innodb` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `bigint` bigint(11) DEFAULT NULL, `float` float DEFAULT

SPARC to x64 Transition

2009-02-13 Thread Aaron Blew
ldump/import necessary to preserve data integrity? If a file copy doesn't work, why specificially would it fail? Thanks, -Aaron

Re: How do you backup HUGE tables?

2009-01-23 Thread Aaron Blew
as an excellent point with innodb-file-per-table as well. Just make sure a single table will never grow to more than the maximum file size of your filesystem. Good luck, -Aaron On Fri, Jan 23, 2009 at 1:18 PM, Daevid Vincent wrote: > We have some INNODB tables that are over 500,000,000 row

Re: How much memory can mysql 5.1 take advantage of?

2009-01-22 Thread Aaron Blew
This doesn't work the same way as system RAM though. You can't extend your innodb buffer pool onto a block device or filesystem. Though this technology would be good for segregating things like InnoDB logs and mysql binary logs. -Aaron On Thu, Jan 22, 2009 at 7:40 AM, mos wrote:

Re: mysqldump: Error 2013: Lost connection to MySQL server

2009-01-12 Thread Aaron Blew
ng to drop/re-import (using a single process), the larger tables continue to fail (though at different points) while some of the small-medium sized tables made it across. Anyone else run into this before? Ideas? Thanks, -Aaron

Obsoleting old ibdata files

2008-10-13 Thread Aaron Blew
e to do a full mysqldump based migration. Thanks, -Aaron

Re: MySQL and SAN storage - a request for comments

2008-09-26 Thread Aaron Blew
rays and can offer performance capabilities way beyond what can be practically achieved by using direct attached storage. -Aaron On Thu, Sep 25, 2008 at 6:38 PM, Michael Dykman <[EMAIL PROTECTED]> wrote: > Hello all, > > I recent started employment with a company which has a lot of

Re: INDEXING ALL COLUMNS

2008-09-05 Thread Aaron Blew
We'd need more information on what the where clauses of the queries look like to assist with this. -Aaron On 9/5/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > Hi, > > What would you say about the below table . What can i do to make it more > effi

Re: innodb/myisam performance issues

2008-09-04 Thread Aaron Blew
2GB of the key_buffer alocation and put it towards the innodb buffer pool What are the system's specs? What's it's underlying storage? What flags were used when you created the filesystem(s)? What OS/Version of MySQL are you running? Could you send us some iostat output? Thanks

Automatic email to database member on X date?

2008-07-04 Thread Aaron Norlund
but we 'manage' the database through phpMyadmin. Thank you for your help! Aaron N. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Moving Database from Windows to Linux

2008-06-26 Thread Aaron Blew
nsfer mechanism (FTP, scp, etc.). -Aaron On Thu, Jun 26, 2008 at 5:09 PM, <[EMAIL PROTECTED]> wrote: > See Thread at: http://www.techienuggets.com/Detail?tx=42035 Posted on behalf > of a User > > Hi, > > I'm running MySQL 5.0.51 Community edition. I have a half a gigabyte

Re: Performance problem with more than 500 concurrent queries

2008-06-26 Thread Aaron Blew
Generally your error log will be .err in your data_dir. -Aaron On Thu, Jun 26, 2008 at 8:46 AM, <[EMAIL PROTECTED]> wrote: > Sorry about the long signature in the email. I forgot to remove it... > > Guillermo > > > > > > > From: > [EMAIL PROTECTE

InnoDB File Fragmentation

2008-06-20 Thread Aaron Blew
les have been added because of data growth. My questions are these: * How does InnoDB store VARCHAR information? Is it based on the column max length? * How does InnoDB decide to re-use free blocks within the data files? Are rows prone to fragment? Thanks, -Aaron -- MySQL General Mailin

create view not working

2008-06-17 Thread Aaron Ryden
why doesn't this work? the select works perfectly create view cost_report as SELECT c_name, d_manuf as Manufacturer, d_model as Model, count(1) as "Number Enrolled", d_price as "Monthly Price", count(1)*d_price as "Cost" FROM `b_devices` A left join b_device_types B on A.d_id = B.d_id left join

Re: Block size of filesystem

2008-05-09 Thread Aaron Blew
ifferent points within the InnoDB data file. In a business intelligence application where there's not much deleting this probably isn't a concern... I think the best way to approach it may be to look at your average row size and base your InnoDB and filesystem block sizes around tha

Re: Block size of filesystem

2008-05-09 Thread Aaron Blew
Will you be using the MyISAM or InnoDB table engines? I had heard that InnoDB uses 16k blocks internally, so that might be a good starting point, though I'd love to have someone confirm or deny that this is actually true. -Aaron On Fri, May 9, 2008 at 12:01 AM, Iñigo Medina García <

Re: Comparing keys in two tables

2007-10-26 Thread Aaron Fischer
Thanks Peter and Baron, these both worked well. The "left join on" took .1919 seconds and the "left outer join as" took .1780 seconds. =) On Oct 26, 2007, at 11:37 AM, Peter Brawley wrote: Aaron An exclusion join: SELECT a.col FROM a LEFT JOIN b ON a.col=b.col WHER

Comparing keys in two tables

2007-10-26 Thread Aaron Fischer
compare the index field in Table A to the index field in Table B. I would like to see all records where the index in Table A does not exist in Table B. Thoughts? Suggestions? Much appreciated! -Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

mysqld fails to start with error unknown option '--enable-named-pipe'

2007-08-27 Thread Aaron Stromas
27; '--sysconfdir=/etc' '--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' '--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thread-safe-client' '--with-comment=MySQL Comm

Query Question

2007-04-16 Thread Aaron Clausen
int date datetime Essentially, the client enters his id and it creates a record in the signin table. I need a query that can identify all the clients who signed in for the first time during a specific month. I have fought this one for a couple of days now and just can't seem to get it. --

Re: ENCODE() and DECODE()

2007-03-13 Thread Aaron Cannon
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Googling for ASP AES I found several promising results. - -- Skype: cannona MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail address.) - - Original Message - From: "Neil Tompkins" <[EMAIL PROTECTED]> To: <[EMAIL

Re: MD5()

2007-03-10 Thread Aaron Cannon
rs credit cards. There are too many ways security can be compromised on such systems. If that is in fact the case, I would suggest you outsource the customer billing. Remember also that security breaches of this type can seriously damage the reputation of any organization. Aaron - -- Skype: cann

/etc/my.cnf in 5.0.27 RHEL4 RPMS is broken!

2007-03-06 Thread Aaron Scamehorn
again! >Fix: Remove the following section from /etc/my.conf: [mysql.server] user=mysql basedir=/var/lib In /etc/init.d/mysql, parse_server_args sets $bindir=/var/lib/bin. So, /usr/bin/mysqld_safe is not found. >Submitter-Id: Aaron Scamehorn >Originator: >Organization: Cognitive

Re: [inbox] Re: Breaking Up Tables

2007-03-01 Thread Aaron Cannon
.sql.bz2.3 db.sql.bz2 \ >db.sql.bz2 6. decompress the db.sql.bz2 file bunzip2 db.sql.bz2 7. import db.sql into wherever. Hope this helps. Aaron -- Skype: cannona MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail address.) - Original Message --

Re: MySQL Daylight Savings Time Patch

2007-02-21 Thread Aaron Cannon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 If it's any consolation, I got the exact same warnings. However, I don't know if it's normal either. - -- Skype: cannona MSN/Windows Messenger: [EMAIL PROTECTED] (don't send email to the hotmail address.) - - Original Message - From: "Jerry

Re: Data types and space needs

2007-01-05 Thread Aaron Cannon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Actually, I think he was asking if the sized used by the storage engine would change if you used for example int(2) as apposed to int(10). My guess is it would not, but that's just a guess. Aaron Cannon - -- Skype: cannona MSN/Windows Mess

Re: 5.1.14-beta with ssl build failure

2007-01-05 Thread Aaron Cannon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 It is unfortunate that mysql does not offer a binary version with ssl support for Linux. Does anyone know why? It can't be for export reasons, as they do offer a windows version with SSL support. Aaron Cannon - -- Skype: cannona MSN/Wi

select statement question

2007-01-03 Thread Aaron Cannon
value is not in any row in D. for example: C = 1 2 3 4 5 6 7 8 11 D = 2 4 6 8 10 and the statement would return: 1 3 5 7 11 Probably an easy question for those of you more experienced but I have no clew. Thanks in advance. Sincerely Aaron Cannon - -- Skype: cannona MSN/Windows Messenger: [EMAIL

Re: Weird MySQL Connection Issues

2006-02-13 Thread Aaron Axelsen
to further investigate. Any other suggestions are welcome, thanks! -- Aaron [EMAIL PROTECTED] wrote: > If you are running MySQL on Windows, then I'm wondering > whether you are having a problem with running out of > available ports, for clients to connect to MySQL on. > > This may

Weird MySQL Connection Issues

2006-02-12 Thread Aaron Axelsen
suggestions? Thanks! -- Aaron Axelsen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump

2005-11-15 Thread Aaron Morris
Right, that is what I am doing, but it does not work. Have you used mysqldump successfully? - Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Aaron Morris" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, November 15, 2005 1:40 PM Subject

mysqldump

2005-11-15 Thread Aaron Morris
I have a very simple database I am trying to backup. I run myslqdump and it gives me the code below. Which does nothing but cause errors when I try to run it. Thank you in advance for your help -Aaron -- MySQL Administrator dump 1.4

Locking Issue

2005-08-11 Thread Aaron
dont know what direction would be best to further diagnose this. If you have any advice , it would be greatly appreciated. thanks for your time! Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump question

2005-05-13 Thread Aaron Wohl
http://www.birdsoft.demon.co.uk/proglib/slowpipe.htm would seem to do what you want... I havent tried it yet, but noted the URL for the next time I needed that functionality. - Original message - From: "Amit M Bhosle" <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Date: Fri, 13 May 2005 09

Question about indexing a highly searched table

2005-01-03 Thread Aaron
usually* in the search criteria. everything is ordered by deletedate to get the most recent results first. What should the thinking be when deciding how to best index this table for speed of searches? All advice welcome and appreciated! Thanks, Aaron

Why is this simple query so slow?

2004-12-10 Thread Aaron
Hi all , I have a relatively simple query that is taking longer than I think it should. Can anyone possibly give me some idea why this might be or any potential bottleneck areas I might want to check out? thanks! Here is some information. The query below takes around 8 seconds, and return

Re: Problem using debug switch with mysqlimport

2004-12-08 Thread Settles, Aaron
Sure enough... I just installed the latest 4.1 linux binaries, I didn't realize that the server itself had to be compiled with the debug enabled (although now that I realize that it makes complete sense). It would be nice if the documentation for mysqlimport would at least make note of this. Thank

Problem using debug switch with mysqlimport

2004-12-06 Thread Settles, Aaron
ly utilized this feature. Does anyone out there have any input? Thanks. Aaron

Newbie, MySQL test fails, spent hours, please help

2004-12-06 Thread Aaron Ford
Hey. The code that I'm trying to get to work is as follows. The problem is with the 7th, 8th, and 9th lines... Test MySQL Error " . mysql_errno() . ": " . mysql_error() . ""); elseif (mysql_num_rows($result) == 0) echo("Query executed successfully!"); else { ?> Variable_nameValue ")

Upgrading 3.23 to 4.1

2004-12-06 Thread Aaron E. Diehl
greatly appreciated. Thanks in advance, Aaron /opt/csw/mysql4/bin/mysqld_safe --basedir=/opt/csw/mysql4 --datadir=/opt/csw/mysql4/data --port=3307 & Log File: 041206 11:19:53 mysqld started 041206 11:19:53 InnoDB: Started 041206 11:19:53 Fatal error: Can't open privilege tables: Can&#

serious bug in 4.1: doubles failing equality tests

2004-11-24 Thread Aaron J. Mackey
series, as the improvement to filesort seems to greatly affect my application ... I'm quite willing to apply a software patch locally to fix the problem. Thanks, -Aaron -- Aaron J. Mackey, Ph.D. Dept. of Biology, Goddard 212 University of Pennsylvania email: [EMAIL PROTECTED] 415 S

Re: Tables Crash when I Delete A Row

2004-11-08 Thread Aaron
Hi Gleb , thanks for the answer. Thats exactly what the problem was. I needed to rebuild the fulltext indexes on my tables. After I did that , the problem seems to have magically disappeared. :) Cheers, Aaron - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]

Error 1034 - FULLTEXT Related?

2004-11-07 Thread Aaron
delete a record again. I have also noticed that the only tables that are corrupting are ones that have fulltext indexes. Here is some more info , if anyone can help , it would be greatly appreciated. Should I consider rebuilding the full text indexes? Thanks, Aaron mysql> DELETE F

Tables Crash when I Delete A Row

2004-11-06 Thread Aaron
; is not fixed because of errors Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag Then, I can fix the problem by using the --safe-recover option , but as soon as a delete is done on the table , it corrupts again. Anyone have any ideas? Tanks, Aaron

4.1 Crashing upon running mysqld_Safe

2004-10-28 Thread Aaron
val__15Item_func_round + 228 0x82deed4 _end + 1156532 0x8048101 (?) Does anyone know what this means exactly? If it helps , we're running Red Hat 6.2 , Linux 2.2.19-6.2.12smp . I got it running on a similarly configured machine with no problems , so Im kinna stumped. Thanks! Aaron

Slow ORDER BY query..

2004-10-25 Thread Aaron
ake around 5 , and some will take ridiculously long times. I think that has to do perhaps with the amount of rows matching before the ORDER BY? I've included all the information I can think of below if anyone feels like having a look, It would be be greatly appre

Table Lock Delays and Connection Pooling

2004-10-18 Thread Aaron
e the lock delays on a slow SELECT statement? Thanks ! Aaron

RE: Why this query doesn't group the email addresses?

2004-07-13 Thread Aaron Wolski
varchar, sir. > -Original Message- > From: Wesley Furgiuele [mailto:[EMAIL PROTECTED] > Sent: July 13, 2004 1:14 PM > To: Aaron Wolski > Cc: [EMAIL PROTECTED] > Subject: Re: Why this query doesn't group the email addresses? > > What type of field is the

RE: all upper case records.. Keeping first char upper and rest lower?

2004-07-13 Thread Aaron Wolski
ry is that is groups all the columns (first,last,email) into one column. What I would like is just the 'first' column. Something tells me this isn't possible? Thanks to you as well for the help. I wouldn't have figured it out for myself that's for sure. Aaron > -Ori

all upper case records.. Keeping first char upper and rest lower?

2004-07-13 Thread Aaron Wolski
Hey guys, I have a column in a table called 'first'. Currently all records are upper case. Is it possible for me to do a select statement that makes all chars after the first char lower case? Example: Current: AARON After: Aaron I think this is possible.. just don't know how

RE: Why this query doesn't group the email addresses?

2004-07-13 Thread Aaron Wolski
Yes sir. Exactly! A > -Original Message- > From: Victor Pendleton [mailto:[EMAIL PROTECTED] > Sent: July 13, 2004 11:15 AM > To: 'Aaron Wolski '; '[EMAIL PROTECTED] ' > Subject: RE: Why this query doesn't group the email addresses

Why this query doesn't group the email addresses?

2004-07-13 Thread Aaron Wolski
.last For some strange reason it doesn't seem to group the email addresses. I'd be hard pressed to find every occurrence out of 1000 records, but I DID quickly spot two exact same records which means the email address was not grouped. What can I do or where did I go wrong? Thanks! Aaron -

RE: anyone help with this query? Returning tooooo many results

2004-07-09 Thread Aaron Wolski
Well well... That worked too! Damn... this is starting to make life easier :) Thanks again. Very much appreciated!!! Aaron > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: July 9, 2004 2:00 PM > To: Aaron Wolski > Cc: [EMAIL PROTECTED

RE: anyone help with this query? Returning tooooo many results

2004-07-09 Thread Aaron Wolski
ll of those customers who DO have email address that matches in each table? Thanks again guys. Very much appreciated! Aaron > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: July 9, 2004 12:17 PM > To: Aaron Wolski > Cc: [EMAIL PROTECTED] &

anyone help with this query? Returning tooooo many results

2004-07-09 Thread Aaron Wolski
mers AS t1, productb_customers AS t2 WHERE t1.email != t2.email When I do this query. I get 486,057 results returne. Where am I going wrong? Any ideas? Thanks so much for the help! Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Session wait_timeout and interactive_timeout variables

2004-07-07 Thread Aaron Jacobs
d to work? Or is the way I am simulating this case flawed? I must say that the documentation is not very verbose about server variables and so wasn't extremely helpful to me in solving this problem. If there's another better way to solve my locking issue, I would love to hear tha

making lower case then first char to upper case?

2004-06-30 Thread Aaron Wolski
THEN changes the first character of each result to an upper case? Example: Currently in DB: AARON to Lowercase: aaron to Uppercase: Aaron Any idea on if I can do this and how I might approach it? Thanks so much Aaron

Tough Query Problem

2004-06-16 Thread Aaron Clausen
I am trying to write a script that can take logs from our mail server, boil down the rejections to determine the sources of distributed SMTP dictionary attacks against our mail server. Basically I have a table "send_failures like this that gets fed with the raw data from the logs: host_ip

AS error with version 4.0.18-standard

2004-05-22 Thread Aaron Wolski
right syntax to use near 'AS percentage FROM CartTable WHERE company ='1' AND submitted=' Any clue why this would no longer work? Thanks! Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

sql syntax error

2004-04-20 Thread Aaron P. Martinez
x27;. ' WHERE (users.policy=policy_names.id) AND (users.username IN (%k))'. ' ORDER BY users.priority DESC '; Please help! Thanks in advance, Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Administrative limitation

2004-04-02 Thread Aaron Wolski
Yes. Or find a host that will give you ability for multiple databases. HTH Aaron > -Original Message- > From: David Fleming [mailto:[EMAIL PROTECTED] > Sent: April 2, 2004 10:30 AM > To: [EMAIL PROTECTED] > Subject: Administrative limitation > > (newbie questi

RE: @@identity

2004-03-10 Thread Aaron
Great - thanks! -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: March 10, 2004 5:36 PM To: 'Aaron '; '[EMAIL PROTECTED] ' Subject: RE: @@identity Rough example. Assuming that you are using the same connection since last_insert_id() is

@@identity

2004-03-10 Thread Aaron
How can I select the last record that was inserted? An ASP/VB example would be great too! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Please help with "check" syntax

2004-01-29 Thread Aaron P. Martinez
d in the online manual and can't find anything that helps. I would really like to get this going as soon as possible to evaluate...any and all help is GREATLY appreciated. Thanks, Aaron Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Does the MySQL packet limitation still exist?

2004-01-23 Thread Aaron P. Lopez
h MySQL 4.01+. At the very least I should be able to save a file of size 32MB from the php interface, but I cannot. What else would be causing this limitation? Cheers, Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
in your replies. Thanks again. Aaron- On Jan 10, 2004, at 3:20 PM, Johannes Franken wrote: * Aaron Gerber <[EMAIL PROTECTED]> [2004-01-10 21:33 +0100]: Locally, I can connect to the MySQL server [...] but I can't connect if I put in the IP address (locally or remotely) Maybe mysqld is c

Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
s is the user accounts. I've set up the user to be able to connect from anywhere. Summary(user: xxx, host: %, password: Yes, privileges: ALL PRIVILEGES , grant: Yes). I used phpmyadmin to set up the accounts. Thanks in advance, Aaron- -- MySQL General Mailing List For list a

Re: Rollback

2004-01-02 Thread Aaron Wohl
You can add a version field to each row. Then add a seperate table with info with a list of the versions and a flag for deleted. Queries would look for each record that has the highest version number thats not deleted. Having a lot undo/redo info can get kind of complicated, especialy with multip

VC++ and mysql and openssl

2003-12-27 Thread Aaron Hagan
its talking to is a mysqlsql version 4.0.13 on unix) i am using openssl version openssl-0.9.7a and mysql-4.0.17. Has anyone else seen this type of error before? thanks for the help! Aaron __ __ __ __ -- MySQL

View SSL connections ?

2003-12-24 Thread Aaron Hagan
the 'show processlist;' command can display what threads are encrypted and which ones aren't? thanks aaron __ __ __ __ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To un

Database Attributes

2003-11-26 Thread Aaron Efland
Hello, I was wondering if someone could provide a brief description for both of the following attributes within the 'db' table: 'create_tmp_table_priv' and 'References_priv' Any information you can provide will be helpful. Thanks, Aaron -- MySQL

Re: Migration to INODB?

2003-11-21 Thread Aaron Wohl
Run all your tables thru this. Save the script as xinno_convert. As in xinno_convert < foo.sql | mysql Suposedly you can also alter a table to innodb. But that never worked for me it just looped using cpu for days. So I made this script which worked fine. Other than converting implicit lockin

upgraded, now nulls act differently

2003-10-02 Thread Aaron P. Martinez
oblem only presents itself when i add NEW users to the database. Any help as to how i can correct this? Thanks in advance, Aaron Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

IP Address Operations in MySQL

2003-09-23 Thread Aaron Clausen
I'm running 3.23.49 on a Win2k machine and wonder if anybody has some advice on how to write queries dealing with IP addresses. Specifically, I have a table with an ip address field. I want to be able to do queries based on subnet. Has anybody got anyting like this? -- Aaron Clausen [

Help debugging this Query?

2003-08-14 Thread Aaron Wolski
one help guide me to get the results of #1 but with the WHERE of #2? Thanks so much! Aaron

RE: Help debugging this Query?

2003-08-14 Thread Aaron Wolski
--+ I am still getting the output I had before in the 77,000+ results being returned. I am at wits end here and don't know where else to look *shrugs* ANY clues? Do you want to see some of the table data? Thanks Aaron > -Original Message- > From: Andy Jackman [mailto:[EM

Re: MySQL field data type for ISBN numbers

2003-08-10 Thread Aaron Holmes
Perhaps just something trivial but both numbers are differing: > SELECT * FROM book_details WHERE ISBN = '1---1' and >and I've put a test ISBN number in of 1--111-11 In any case I have ran a test on my servers with mysql V 4.0.13 and things work accordingly.

Changing ENUM Values

2003-07-17 Thread Aaron Blew
So I've got fairly big sized table (20,000 records) which has an ENUM row. I need to change the name of one of the ENUM options. For example, if the ENUM value was 'blue' before, it needs to be 'purple' now. What's the best way to do this? Thanks, -Aaron

Can't get MySQL to log queries.

2003-06-06 Thread JACKSON,AARON (HP-Boise,ex1)
CommandArgument I am using MySQL 4.0.13 on Redhat 7.3. Aaron

can you do this? mysql backend question

2003-06-03 Thread Aaron P. Martinez
was far from exhaustive in my search i'm sure. I'm not looking for someone to spell this out, rather just perhaps a pointer to a particular portion of some document that might explain this. Thanks in advance Aaron Martinez -- MySQL General Mailing List For list archives: http://lists

Choosing a column for primary key

2003-03-27 Thread Aaron Williams
erformance problems as the table grows. Would joins of tables with character based primary keys be slower than those with numeric based keys? Has anyone had experience implementing a character-based primary key in a table of non-trivial size (> 500,000 rows)? Thanks for any assistance or poi

MyODBC 3.51 - Memory allocation error with BLOBs

2003-03-02 Thread Aaron O'Neil
How-To-Repeat: I suspect there is a bug in the ODBC driver in relation to blobs. I'm now using 3.51.06, but was having this same problem on 3.51.05. I'm using Visual C++ and their CRecordset wrapper for the ODBC calls. I'm using the positioned updates. As long as I keep the binary data I'm trying

Different value from same function

2003-02-18 Thread Aaron Conaway
gt; select inet_aton("172.20.20.2"); +--+ | inet_aton("172.20.20.2") | +------+ | 2886996994 | +--+ 1 row in set (0.00 sec) -- Aaron Conaway Network Engineer III V

Replication Problems with Adding New Records

2003-02-13 Thread Aaron Weed
... Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]&

RE: IP Addresses -- How to Store

2003-02-11 Thread Aaron Conaway
Thanks to Peter, Ravi, and Dan. That's exactly what I needed to know. -- Aaron Conaway Network Engineer III Verisign, Inc. -- Telecom Services Division http://www.verisign.com Office: 912.527.4343 Fax: 912.527.4014 -Original Message- From: Peter Hicks [mailto:[EMAIL PROT

IP Addresses -- How to Store

2003-02-11 Thread Aaron Conaway
ight on this type of data storage? -- Aaron Conaway Network Engineer III Verisign, Inc. -- Telecom Services Division http://www.verisign.com Office: 912.527.4343 Fax: 912.527.4014 - Before posting, please check

Re: bug submitted (non-unique indicies in heap tables do not work correctly)

2003-01-09 Thread Aaron Krowne
Cute =) (MySQL sql query queries smallint =) Aaron Krowne On Thu, Jan 09, 2003 at 04:36:12PM +0100, [EMAIL PROTECTED] wrote: > > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of t

Re: Backups mechanism

2003-01-08 Thread Aaron Clausen
counting system, and to test out bug fixes, new features, etc., I'll just dump the running database and pipe it into a test database. I found mysqldump to have a bit of a learning curve, but I could not survive without it now. -- Aaron Clausen --

Re: Backups mechanism

2003-01-07 Thread Aaron Clausen
ng mysqlbackup. Works fine and I have used it for restorals on a number of occasions. Even better, mysqlbackup generates SQL files, which, with a little manipulation, can be imported into other database systems. -- Aaron Clausen --

filters

2003-01-02 Thread Aaron Scribner
ere are no tags in the Subject lines of the messages sent to the list, that is what I usually use to filter messages. Does anyone have any tips for filtering these messages using Eudora? I just sub'd to 7 different MySQL lists and cannot get any of my filters to work right. and sorry for th

Error 2013: Lost connection to MySQL server

2002-12-19 Thread Aaron J. Martin
/configure --prefix=/local --with-libwrap=/local \ --with-charset=usa7 --with-mysqld-user=mysql \ --localstatedir=/local/dbdata >Submitter-Id: >Originator: Aaron Martin >Organization: Institute for Cr

  1   2   >