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

explain shows type = ALL for indexed column

2010-12-07 Thread Aaron Turner
-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). Any advice would be appreciated! -- Aaron Turner http

Re: explain shows type = ALL for indexed column

2010-12-07 Thread Aaron Turner
-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 Those who would give up essential

substring query

2010-06-10 Thread Aaron Savage
'. 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/mysql?unsub

Re: substring query

2010-06-10 Thread Aaron Savage
. 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. SELECT SUBSTRING_INDEX('myfile.path

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:28 AM, Jay

Re: Replication switch Master to slave and back

2009-07-08 Thread Aaron Blew
both writable. -Aaron On Wed, Jul 8, 2009 at 1:38 PM, Cantwell, Bryan bcantw...@firescope.comwrote: 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 become

Ordering an IN query

2009-06-05 Thread Aaron Fischer
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
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 brentt...@gmail.com wrote: SCSI isn't necessarily faster now. The big difference used to be SCSI's

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 NULL

SPARC to x64 Transition

2009-02-13 Thread Aaron Blew
/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
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 dae...@daevid.com wrote: We have some INNODB tables that are over

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 mo...@fastmail.fm

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

2009-01-12 Thread Aaron Blew
(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
migration. Thanks, -Aaron

Re: MySQL and SAN storage - a request for comments

2008-09-26 Thread Aaron Blew
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 mysql servers (100+ is my best estimate so far

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 efficient. CREATE TABLE mailer_student_status

Re: innodb/myisam performance issues

2008-09-04 Thread Aaron Blew
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 and good luck, -Aaron

Automatic email to database member on X date?

2008-07-04 Thread Aaron Norlund
' 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: Performance problem with more than 500 concurrent queries

2008-06-26 Thread Aaron Blew
Generally your error log will be HOSTNAME.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 PROTECTED] To: mysql@lists.mysql.com Date: 26.06.2008 17

Re: Moving Database from Windows to Linux

2008-06-26 Thread Aaron Blew
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 sized database that I'd like to move

InnoDB File Fragmentation

2008-06-20 Thread Aaron Blew
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 Mailing List For list archives: http

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
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 [EMAIL

Re: Block size of filesystem

2008-05-09 Thread Aaron Blew
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 that. -Aaron On Fri, May 9

Comparing keys in two tables

2007-10-26 Thread Aaron Fischer
to 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

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 WHERE b.col IS NULL; PB

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

2007-08-27 Thread Aaron Stromas
-fasynchronous-unwind-tables' 'CXX=gcc' 'LDFLAGS=' -- Aaron Stromas | Tik-tik-tik!!!... ja, Pantani is weg... mailto:[EMAIL PROTECTED] |BRTN commentator +972 (0)54-6969581 |L'Alpe d'Huez http://www.izoard.com |1995 Tour de France

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. -- Aaron

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
. 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: cannona MSN/Windows

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

2007-03-06 Thread Aaron Scamehorn
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 Capital, LLC. MySQL support: none Synopsis: Bad

Re: [inbox] Re: Breaking Up Tables

2007-03-01 Thread Aaron Cannon
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 - From: [EMAIL PROTECTED

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: 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/Windows

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 Messenger

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
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 be your problem: From the manual

Weird MySQL Connection Issues

2006-02-12 Thread Aaron Axelsen
or 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]

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

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: mysql@lists.mysql.com Sent: Tuesday, November 15, 2005 1:40 PM Subject: Re: mysqldump Aaron

Locking Issue

2005-08-11 Thread Aaron
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

Question about indexing a highly searched table

2005-01-03 Thread Aaron
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

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.

Upgrading 3.23 to 4.1

2004-12-06 Thread Aaron E. Diehl
. 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't find file: './mysql/host.frm

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... html head titleTest MySQL/title body !-- mysql_up.php -- ?php $host=; $user=; $password= ; mysql_connect($host,$user,$password); $sql=show status; $result = mysql_query($sql); if

Problem using debug switch with mysqlimport

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

serious bug in 4.1: doubles failing equality tests

2004-11-24 Thread Aaron J. Mackey
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. University Avenue office: 215-898-1205 Philadelphia, PA 19104-6017 fax:215-746-6697 -- MySQL General Mailing List

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] To: [EMAIL

Error 1034 - FULLTEXT Related?

2004-11-07 Thread Aaron
to 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 FROM

Tables Crash when I Delete A Row

2004-11-06 Thread Aaron
-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
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 appreciated. Thanks! Aaron

Table Lock Delays and Connection Pooling

2004-10-18 Thread Aaron
on a slow SELECT statement? Thanks ! Aaron

Why this query doesn't group the email addresses?

2004-07-13 Thread Aaron Wolski
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 -- MySQL General Mailing List

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? Were the records exactly the same? -Original

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 to execute

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

2004-07-13 Thread Aaron Wolski
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 -Original Message- From: Wesley

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 email field? Wes On Jul 13, 2004

anyone help with this query? Returning tooooo many results

2004-07-09 Thread Aaron Wolski
, 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.com/[EMAIL

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

2004-07-09 Thread Aaron Wolski
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] Subject: Re: anyone help

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] Subject: RE: anyone

Session wait_timeout and interactive_timeout variables

2004-07-07 Thread Aaron Jacobs
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 that as well. Thanks, Aaron Jacobs

making lower case then first char to upper case?

2004-06-30 Thread Aaron Wolski
and 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
='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
) 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 question) Our web host provides one

@@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]

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 connection specific

Please help with check syntax

2004-01-29 Thread Aaron P. Martinez
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
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.mysql.com

Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
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 archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Can't connect to MySQL server

2004-01-10 Thread Aaron Gerber
. 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 configured to listen on its

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

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 unsubscribe:http

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 General Mailing List For list

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

upgraded, now nulls act differently

2003-10-03 Thread Aaron P. Martinez
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 [EMAIL

RE: Help debugging this Query?

2003-08-14 Thread Aaron Wolski
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:[EMAIL PROTECTED] Sent

Help debugging this Query?

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

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. Thanks, Aaron Holmes

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 --- Aaron Blew Jackson

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
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.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Choosing a column for primary key

2003-03-27 Thread Aaron Williams
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 pointers. Aaron [EMAIL

Different value from same function

2003-02-18 Thread Aaron Conaway
) | +--+ | 2886996994 | +--+ 1 row in set (0.00 sec) -- Aaron Conaway Network Engineer III Verisign, Inc. -- Telecom Services Division http://www.verisign.com Office: 912.527.4343 Fax: 912.527.4014

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

IP Addresses -- How to Store

2003-02-11 Thread Aaron Conaway
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: http://www.mysql.com

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 PROTECTED

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 the following

Re: Backups mechanism

2003-01-08 Thread Aaron Clausen
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 - Before posting, please check: http://www.mysql.com/manual.php

Re: Backups mechanism

2003-01-07 Thread Aaron Clausen
. Even better, mysqlbackup generates SQL files, which, with a little manipulation, can be imported into other database systems. -- Aaron Clausen - Before posting, please check: http://www.mysql.com/manual.php (the manual

filters

2003-01-02 Thread Aaron Scribner
that there 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 the WOB. - Aaron

Error 2013: Lost connection to MySQL server

2002-12-19 Thread Aaron J. Martin
--prefix=/local --with-libwrap=/local \ --with-charset=usa7 --with-mysqld-user=mysql \ --localstatedir=/local/dbdata Submitter-Id: submitter ID Originator: Aaron Martin Organization: Institute for Crustal Studies, UCSB

Re: Can MySQL handle 120 million records?

2002-12-18 Thread Aaron Clausen
in the next six months. But MySQL has been rock solid. I have lost no data, save through my own stupidity, at any point. I would recommend it without reservations. -- Aaron Clausen - Before posting, please check: http

  1   2   >