Database persistent read error

2007-07-09 Thread eric
problem cleared. On no.3 - did all the same things, uninstalled - reinstall - deleted IE7 files - nada... installed firefox - same problem. Can't figure where it is getting the data from. Eric

Experiment with MySQL User Defined Functions in Java

2003-12-19 Thread eric
x27;t want to test on your production data. http://freshmeat.net/projects/judf/?topic_id=66 Cheers, -- Eric Herman Seatle, WA [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Experiment with MySQL User Defined Functions in Java

2003-12-20 Thread eric
On Sat, 2003-12-20 at 06:32, Marcelo Anelli wrote: > Eric, please can you indicate how to write & use an UDF in php? > David Sklar wrote it, I have not used it. http://www.sklar.com/page/section/projects Cheers, -- eric > Thanks > > eric wrote: > > If you hav

Re: 64-bit Linux MySQL and ramdisks

2004-01-28 Thread Eric
Hi, I am curious, is there really that big of a benefit to using a ramdisk this way? If you have enough memory for your keycache and buffers and don't have to use tmp space for any queries? Add the query cache in 4 to that and I wonder what is left to ramdisk? Thanks, Eric At 10:51

not found driver 3.51 not found

2003-10-15 Thread .eric
the service, and reinstalled it, but nothing happens. im not sure whats wrong but for the record i have the following: windows xp mysql 2.5.4 WinMySQLadmin 1.4 if anyone can help me with this problem, i would greatly appreciate it. thanks in advance! --- eric smith http:/m00q.tk - [EMAIL

Re: 4.0.18 or 4.1.1-alpha?

2004-03-05 Thread Eric
EMS a great deal. thanks, Eric At 09:31 AM 3/5/2004, Victor Medina wrote: >If it's going to be a full production environment where stability is >crucial, use 4.0.18. > >If it is going to be for a development proyect, you can use 4.1.1 and >enjoy the new features. > >

Re: 4.0.18 or 4.1.1-alpha?

2004-03-05 Thread Eric
Hi, hmm, mysql support needed to know that a few weeks ago! :) Thanks, Eric At 09:58 AM 3/5/2004, Victor Medina wrote: >If you use the "old-password" settings in your server, ems should connect with out a >hitch > >Best Regards! >On Fri, 2004-03-05 at 13:41, Eric

Re: two masters, one slave

2004-03-15 Thread Eric
e "masters" :) Thanks, Eric At 10:45 AM 3/12/2004, Ken Menzel wrote: >Not at this time, however you could have two different slaves on the >same physical server using mysql_mutli type of configuration. >http://www.mysql.com/doc/en/mysqld_multi.html > >Hope it

Re: Process Monitoring

2004-04-20 Thread Eric
Hi, The mysql administrator tool is a lot better for this. They still seem to be working out some bugs, but there is a lot of flexibility with the graphs. I have been able to see peaks in bandwidth and queries that I never noticed before.. Thanks, Eric At 12:35 PM 4/20/2004, Peter J

Re: urgent: how to increase the database size

2004-04-29 Thread Eric
round 4.0.1 or something like that. So in that case, if you don't have autoextend, you could have a db with a max size. Or maybe he is just running out of disk space :) Thanks, Eric At 08:29 AM 4/29/2004, Paul DuBois wrote: >At 23:32 +0530 4/28/04, [EMAIL PROTECTED] wrote: >>Hi,

Re: triggers (or too-many-crappy-questions)

2004-04-30 Thread Eric
moan about RTFM crap are much more of a bother to me than a poor guy who doesn't know his way around mysql yet, doesn't get how useful and complete the manual is, and needs some basic help. Thanks, Eric At 11:49 AM 4/30/2004, Chris W wrote: >David Griffiths wrote: > >&g

Re: MySQL Benchmark. OT and beyond...

2004-05-27 Thread Eric
that is certainly one of them. Thank you, Eric At 10:48 AM 5/27/2004, RV Tec wrote: >JG, > >> I am a FreeBSD user, but after having run benchmarks for >> the past 2 weeks, I think you'll be surprised when you see >> the results from Linux. >> >> Linux

Re: License

2003-03-06 Thread Eric
with support you can count on that response. A very big deal when you are freaking out about your data being randomly corrupted :) Thanks, Eric At 08:12 AM 2003-03-06, Benjamin Pflugmann wrote: Hi. On Thu 2003-03-06 at 12:45:19 +, [EMAIL PROTECTED] wrote: > > If I develop a software

Mysql 4.0.1-Alpha: Union + Limit bug.

2002-03-21 Thread eric
5; +--+ | data | +--+ | 1| | 2| | 3| | 4| | 5| +--+ 5 rows in set (0.00 sec) mysql> select * from a union select * from b limit 5,5; Empty set (0.00 sec) mysql> >Fix: None known. >Submitter-Id: >Originator:Eric Poulsen >Organization: >My

Text formating in Perl

2002-08-04 Thread eric
up this way when I look at the table with mycc However when I try to print it out after SELECT print p("$ref->[5]"); it prints all as one line. How do I maintain text format extraction in Perl 5.6.1? I can't seem to find the answer in either of the two bo

Use of certain keywords in SQL statements problematic

2001-03-06 Thread eric
-- (Original SQL query line was all one line, originating from a PHP page; it has been edited only for readability.) >How-To-Repeat: I have not tested creating a table with such a column name. However, with an existing table, the li

Bug in 3.23.33? Or design decision?

2001-03-07 Thread eric
T and UPDATE. Is this expected behavior? Or is this an actual bug? Eric A. Stewart - Network Administrator - [EMAIL PROTECTED] University of South Florida, Tampa Campus Library - Technology Work: http://www.lib.usf.edu/ | MS/MIS | ICQ# Play: http://cerebus.lib.usf.edu/ | Gra

Possible bug in self-join order optimization

2001-10-18 Thread Eric
I am sending this again as I am desperate for some help and believe this to be a signifigant bug if it actually is one...which it seems to be. See below for examples. What is quite puzzling is MySQL's estimation of the number of rows from each of the self-joins. The conditions on alias queryTab

Re: Possible bug in self-join order optimization

2001-10-19 Thread Eric
? Has anyone ever thought of coding this? Can anyone give me a place to start? eric. On Thu, Oct 18, 2001 at 10:40:43AM -0500, Eric wrote: > I am sending this again as I am desperate for some help and believe > this to be a signifigant bug if it actually is one...which it seems to > be.

Re: Possible bug in self-join order optimization

2001-10-20 Thread Eric
uld take (especially since the attribute I'm doing a range on is not indexed)? eric. On Sat, Oct 20, 2001 at 02:30:13PM +0300, Sinisa Milivojevic wrote: > On Fri, 19 Oct 2001 13:03:02 -0500 > Eric <[EMAIL PROTECTED]> wrote: > > > > Well, answering my own email, what

Re: Possible bug in self-join order optimization

2001-10-20 Thread Eric
The information I require is the number of rows that will come from a SELECT which places a certain range restriction on an unindexed attribute...and I need this to not take much time relative to actually executing the query (constant time would be best). eric. On Sat, Oct 20, 2001 at 03:06

Re: Possible bug in self-join order optimization

2001-10-20 Thread Eric
has anyone thought about doing this? eric. On Sat, Oct 20, 2001 at 07:52:28PM +0300, Sinisa Milivojevic wrote: > Eric writes: > > I have no problem using STRAIGHT_JOIN, etc. My problem is really just > > figuring out the optimal join order. Is doing a "SELECT COUNT" on &

Mandrake and myisampack

2002-01-09 Thread Eric
I had mandrake 7.2 running on my system. It crashed and I transfered my back up files to a system running Debian 2.2. The file were db.frm db.myd db.myi. These are packed files and the mysql I am now running does not use these. What can I do?? Need help Eric

Re: Innodb - row locks?

2002-10-07 Thread Eric
ripts that are not persistent. >I figured I needed to autocommit = 0 and commit explicitly. But I just >wanted to see if that made sense. sql,query,mysql arrgghh >Thanks, > >Eric > >http://www.kwinternet.com/eric >(250) 655 - 9513 (PST Time Zone) > >

Re: ERROR 2013: Lost connection to MySQL server during query

2002-10-18 Thread Eric
and I can't reproduce it. The same query executing over and over and over, but sometimes it chokes with the Lost connection error. Isn't there a way to make the mysql error log a LOT more verbose? Eric At 11:56 AM 2002-10-18 -0400, //mikezero/ wrote: [

Re: ERROR 2013: Lost connection to MySQL server during query

2002-10-18 Thread Eric
mysql mysql 264824 Oct 18 09:57 bob-bin.076 I have been running with this in my my.cnf log log-slow-queries log-bin But the logs stop/starts of new files don't correspond to the lost connection errors at all.

Mysql Monitor output from perl

2002-10-24 Thread Eric
1900-01-01 00:00:00 | | 103412478307044002 | 1900-01-01 00:00:00 | | 103412403504111002 | 2001-07-08 17:29:58 | | 103412403507079002 | 2001-07-08 19:42:39 | | 103412403398044002 | 2001-07-10 21:09:40 | ++-+ Thank

Exciting new Replication Error

2002-11-14 Thread Eric
lave, it worked, removed both indexes on the slave and master... Then I copied the data back to the slave table. Now I get the above messages, and typing either slave start, or slave stop hangs endlessly. Thanks, Eric ---

Exciting new Replication Error -- more info

2002-11-14 Thread Eric
e master data was unique. I backed up the table on the slave, deleted the data from the master table, deleted the data from the slave table, restarted the slave, it worked, removed both indexes on the slave and master... Then I copied the data back to the slave table. Now I g

How to Verify Replication Status?

2006-04-19 Thread Robinson, Eric
, so transferring the whole database across the network is not an option. -- Eric Robinson Director of Information Technology Physician Select Management, LLC 775.720.2082

Re: How to Verify Replication Status?

2006-04-20 Thread Eric Braswell
nces are. But this won't help you if you can't transfer all the data to one place -- you could just do a checksum then on both sides and compare that. Would be pretty easy to script that and perform periodic checks. Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA R

RE: How to Verify Replication Status?

2006-04-20 Thread Robinson, Eric
ailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 5:31 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: How to Verify Replication Status? Never used it, but this might help: http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html James Harvard At 5:00 pm -0700 19/4/06, Robinson,

RE: How to Verify Replication Status?

2006-04-20 Thread Robinson, Eric
Eric, that is very helpful. Thanks. Assuming the master and slave are in sync, is there a reason the checksums would not match? I would rather not dump the database and run an external checksum unless I have to. -- Eric Robinson Director of Information Technology Physician Select Management

Re: How to Verify Replication Status?

2006-04-20 Thread Eric Braswell
You could have a shell script lock the tables, do an md5sum on the .MYD and maybe .frm files (for MyISAM), then unlock. I can't off-hand think of any reason this wouldn't work well as long as the slave and master are configured identically and are the same version. Eric -- Eric Bra

RE: How to Verify Replication Status?

2006-04-20 Thread Robinson, Eric
All excellent information. I have much to ponder. -Original Message- From: Eric Braswell [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:20 AM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: How to Verify Replication Status? You'll need to checksum them at the

Quick Replication Question

2006-04-28 Thread Robinson, Eric
When you have master-slave replication enabled, and something goes wrong with one of the tables on the master, and you have to run mysqlcheck -r to fix it, does the fix get written to the binlog and replicated to the slave? --Eric -- MySQL General Mailing List For list archives: http

RE: Quick Replication Question

2006-04-28 Thread Robinson, Eric
: Friday, April 28, 2006 9:05 AM To: Robinson, Eric; mysql@lists.mysql.com Subject: Re: Quick Replication Question no. - Original Message - From: "Robinson, Eric" <[EMAIL PROTECTED]> To: Sent: Friday, April 28, 2006 8:51 AM Subject: Quick Replication Question When you h

Fixing Databases When Replication Is Enabled?

2006-05-01 Thread Robinson, Eric
I ran mysqlcheck against a replication master database and it reported a problem with a table, which it corrected. Is the slave now out of sync? If so, how do I correct the problem without copying the whole database over a slow WAN link? --Eric -- MySQL General Mailing List For list archives

RE: Fixing Databases When Replication Is Enabled?

2006-05-01 Thread Robinson, Eric
I ran mysqlcheck, not myisamchk or REPAIR. Is what you said still true? -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Monday, May 01, 2006 1:56 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: Fixing Databases When Replication Is Enabled? On 5/1/06

RE: Fixing Databases When Replication Is Enabled?

2006-05-03 Thread Robinson, Eric
So, just to be clear, when I run: mysqlcheck -r -f Any fixes are recorded to the binlog and replicated to the slave? I want to be sure about this because someone in this forum said the opposite a couple of weeks ago. Thanks! --Eric -Original Message- From: Kishore Jalleda

Re: possible to select from multiple databases?

2006-05-05 Thread Eric Braswell
ojectID This is easy as long as the dbs are on the same machine: SELECT * from db1.table1, db2.table1... Eric -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqlcheck

2006-05-18 Thread Robinson, Eric
Does mysqlcheck sometimes repair problems that it does not report? I've seen a few instances where running mysqlcheck -r -f fixed application problems even though it reported all tables "OK." --Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: mysql4.0

2006-05-22 Thread Robinson, Eric
Does mysqlcheck sometimes repair problems that it does not report? I've seen a few instances where running mysqlcheck -r -f fixed application problems even though it reported all tables "OK." --Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

DB Export Character Encoding

2006-05-25 Thread Eric Butera
Greetings List, I need some help understanding what is happening with the following scenario I am going to explain. Please feel free to say RTFM and point me to a link that can clear this up for me. I have searched Google with all sorts of different keywords and haven't been able to figure out

MySQL Performance Question

2006-06-16 Thread Robinson, Eric
ew hundred MB/year. Database2: 50 tables. 3 tables sized 10-100MB. All other tables less than 10MB. No data growth. Database3: 179 tables. 10 tables sized 1-15MB. All other tables less than 1MB. No data growth. --Eric Disclaimer - June 16, 2006 This email and any files transmitted w

RE: MySQL Performance Question

2006-06-17 Thread Robinson, Eric
ersions of the application.) --Eric -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Saturday, June 17, 2006 12:14 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question So, you're looking at 150-300 databases and ~31-62k table

Server Load Question

2006-06-19 Thread Robinson, Eric
one instance of MySQL serving 300 databases? --Eric Disclaimer - June 19, 2006 This email and any files transmitted with it are confidential and intended solely for [EMAIL PROTECTED] If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any vi

RE: Server Load Question

2006-06-19 Thread Robinson, Eric
ided to do is create one instance of MySQL per version of the application. All clients running the same version of the application would use the same instance of MySQL. -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Monday, June 19, 2006 12:55 PM To: Robinson, Eric

RE: MySQL Performance Question

2006-06-19 Thread Robinson, Eric
node will be: 2 x Dual-core Xeon 2.8GHz (4 processor cores, total). 8GB RAM RAID 10 array (300GB (usable) I prefer RAID 10 to RAID 0+1 because the former can survive the loss of 2 drives and read/write performance is about the same as RAID 0+1. Thanks again for your input. --Eric Rob

several master for one slaveserver for backup purpose?

2006-06-20 Thread Eric Persson
is if its possible to have several masters share a combined slave, or really one slave acts as a slave/backup server for a bunch of masters? I can see the performance issues with all the updates, but apart from that, is there any other limitations? /eric -- MySQL General Mailing List For

Re: MySQL Read_only Mode

2006-06-28 Thread Eric Braswell
--read_only is probably what you are looking for. http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html -- Eric Braswell Web Manager MySQL AB Cupertino, USA Clyde Lewis wrote: The idea is to prevent all users from applying changes to the system. Not just a single user

Re: PHP connects in Latin1 when it should do it in UTF-8

2006-07-07 Thread Eric Butera
On 7/6/06, Santiago del Castillo <[EMAIL PROTECTED]> wrote: Hi, i'm having a bit of a headache with PHP and MySQL, i've some questions: 1) I've a database in UTF-8 and when i connect to it with mysql_connect, and exec a query with mysql_query, the results are in latin1. (i proved this with mysq

mysqld-nt 100% CPU Utilization?

2006-07-19 Thread Robinson, Eric
database, but it is still happening. Any ideas? -- Eric Robinson Disclaimer - July 19, 2006 This email and any files transmitted with it are confidential and intended solely for [EMAIL PROTECTED] If you are not the named addressee you should not disseminate, distribute, copy or alter this email

Re: udf configuration resources

2006-07-20 Thread Eric Bergen
UDF able to refer back to it everytime it is run. I know I could read a file in the _init function, but this seems very wasteful to read a file every time the function is being used. Any thoughts on this would be appreciated. thanks, Yong. -- Eric Bergen [EMAIL PROTECTED] http:/

Re: MySQL lock tables - bug or not?

2006-07-28 Thread Eric Braswell
+ 2 rows in set (0.00 sec) mysql> show databases; ++ | Database | ++ | information_schema | | dl | ++ 2 rows in set (0.00 sec) -- Eric Braswell Web Manager MyS

Re: Who's locking ?

2006-07-29 Thread Eric Bergen
somebody try to explain, how I can investigate, who's blocking the line ? -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Looking For How test database performans on different hardware

2006-07-29 Thread Eric Bergen
nt that virus or other forms of data corruption may not be present and we do not take any responsibility in any occurrence. -- Eric Bergen [EMAIL PROTECTED] http://www.provenscaling.com

Re: Crashing mysql Ver 14.7 Distrib 5.0.2-alpha, for pc-linux (i686)

2006-08-17 Thread Eric Braswell
Is there a reason you cannot upgrade from an early =alpha= version of 5.0 ? I think you fill find the release versions more stable. -- Eric Braswell Web Manager MySQL AB Cupertino, USA murthy gandikota wrote: Hi Can someone tell me where in the file system to look for the logs? Mysql

MERGE table problem

2006-08-24 Thread Eric Anderson
I've got a master (Master) with a MERGE table of foo_t (comprising of bar_a, bar_b, bar_c) in database 'Igloo'. There are 5 slaves that replicate the Igloo table, but ignore the Igloo.foo_t table. This setup was working fine. If the Master server crashed or had a prblem for some reason, I

Re: www/dev.mysql.com?

2006-08-31 Thread Eric Braswell
by tomorrow afternoon US pacific time. -- Eric Braswell Web Manager MySQL AB Cupertino, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: solaris build mysql from source using gcc

2006-09-01 Thread Eric Anderson
Well if you'd share your specific problem I'm sure someone can help, but more importantly why are you building from source anyway? There are binary builds for most Solaris platforms, including 2.10. Sorry I meant 10 theremy solaris experience comes from the 'old days' before they went and

Re: InnoDB Crash RECOVERY HELP (Urgent)

2006-09-21 Thread Eric Bergen
I add skip-innodb in my.cnf, it startsup but my innodb tables could not be accessed. How can I start MySQL server again? -- Sincerely, Hadi Rastgou A Google Account is the key that unlocks the world of Google. http://www.spreadfirefox.com/?q=affiliates&id=0&t=1";> Get Firefox!

Replication

2006-10-05 Thread Eric Anderson
AT http://casting.macandbumble.com - Eric Anderson Mac and Bumble Bumble Cash ICQ 3849549 http://www.macandbumble.com http://www.bumblecash.com San Diego, CA<[EMAIL PROTECTED]> <[EMAIL PROTECTED]>

Re: Replication

2006-10-06 Thread Eric Anderson
PPLY AT http://casting.macandbumble.com - Eric Anderson Mac and Bumble Bumble Cash ICQ 3849549 http://www.macandbumble.com http://www.bumblecash.com San Diego, CA<

Undelete a droped table

2006-11-07 Thread Eric Lommatsch
Hello, I have accidently droped a table from one of my database's. The table was an innodb table. Is there anyway that I can recover the table or is that information gone for good if I don't have a current backup of that table? Thank you Eric H. Lommatsch Programmer MICRONix, Inc.

Re: Subselect in an Update query

2005-06-17 Thread Eric Bergen
Could you accomplish this with an update and self join? Ed Reed wrote: Sorry, I thought it was easy to understand. I wanna update a field in a table with a value from the same field but from a different record of the same table. For example, using the query in my original message, +

Return REG Value

2005-06-20 Thread Eric Jensen
rs from these fields. I've looked at the mysql REGEXP type functions and they just return true or false. I have run into many situations where returning a regular expression modified value would be very handy. Only solution I have found so far is nested string replace functions. Eric Jensen

Getting first and last day of week

2005-07-13 Thread Eric Jensen
there is a more efficient way with MySQL. Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql crash due to page corruptions

2005-07-13 Thread Eric Bergen
Please upgrade to the newest 4.0 mysql binaries. Anil wrote: Hi, We are using mysql 4.0.20 on RHEL3.0 with circular replication setup A ->B ->C ->A . A is the master and all operations will be happening on A. We are facing frequent mysql crash on Master with page corruption errors. How to

Re: Getting first and last day of week

2005-07-13 Thread Eric Jensen
asy to calculate the >>first/last days in that calendar week. >> >> >> > > I can think of a lot of ways once I have the date, that's not really the problem. All I have is a week number, I.E. 23, 24, 25, etc. I need to find out some dates they correspond to

Remove Unique Key

2005-07-20 Thread Eric Jensen
droping it, then re-inserting everything? Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: table export problem

2005-07-20 Thread Eric Bergen
Which version of mysql are you exporting from and inserting into? [EMAIL PROTECTED] wrote: Hi all, I am trying to create a table on the remote server from a table I created on my local sever but it never seems to work CREATE TABLE `sheet1` ( `id` int(10) NOT NULL auto_increment, `title` v

Re: Doubt about query optimization

2005-07-27 Thread Eric Bergen
Can you send us the actual show indexes from table and explain output that isn't shortend? Ronan Lucio wrote: Hello, I´m using MySQL-4.1.7, and I have a query that seems, even using where clause, an specific table isn´t being optimized properly: I have four tables: real_state: cod, name, ci

Re: Insert with prefix

2005-07-27 Thread Eric Bergen
Try this: concat('UP', lpad(category_id, 6, '0')); Scott Purcell wrote: Hello, I have the following dilemma, that I do not know how to handle. I have the need for a table where I create a identifier. The identifier consists of a two character string, eg: "UP" + the next "AUTO_INCREMENT" Here

Re: Hour counts

2005-07-27 Thread Eric Bergen
This does make his code fall under the limitations of unix timestamps. In 30 years or so when we are all retired millionaires ;) some poor intern is going to have to figure out why the hour diff calculation is failing. [EMAIL PROTECTED] wrote: Gyurasits Zoltán <[EMAIL PROTECTED]> wrote on 0

Exporting a database from one PC to another using MySQL 5.0

2005-08-08 Thread Eric Dahlenburg
Internet Explorer for some reason. Thanks, Eric Eric Dahlenburg Spacecoastsales.net [EMAIL PROTECTED] 321-453-7627 Voice/ Fax 321-917-9098 Cell This communication is intended solely for the use of the person(s) to whom it is addressed. This communication may contain confidential information or

FULLTEXT search result requirement

2005-08-11 Thread Eric Jensen
this requirment? Or should I be looking in a totally different direction for something of this scale? Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't figure out how to get it running

2005-09-02 Thread Eric Mynes
The way I could tell that mysl is running is to (assuming that you are running windows): Click Start Click Run Type CMD Press Enter Type MYSQLADMIN PING Press Enter if you get the message "mysqld is alive", then it is running Thanks, Eric Network Administrator West Virginia Federal Cr

Re: Getting Record Count w/o doing 2 queries.

2005-09-07 Thread Eric McGrane
After you execute your select/limit statement you can execute select found_rows() It returns the number of rows thbat the previous query would have returned if the limit wasn't applied. See: http://dev.mysql.com/doc/mysql/en/information-functions.html. Regards, E Hi everyone, Im executing

Re: Optimizing query "WHERE date>0"

2005-09-08 Thread Eric Bergen
When you add that index are more than 30% of the rows in the table DateTimeNext>1126215680? Dan Baker wrote: I have lots of tables that are similar in nature: id int(11) PRI NULL auto_increment Name varchar(30) DateTimeNext int(11) The "DateTimeNext" field represents when this records needs

Re: Anyone knows what happens at mysqladmin startup time?

2005-09-08 Thread Eric Bergen
It appears that mysqld is not listening on /tmp/mysql.sock. Log into mysql and run show variables like 'socket'; This will tell you where mysqld is actually listening for socket connections. Then update your my.cnf files so they all have the same sock file location as the one that mysqld is li

Re: log event entry exceeded max_allowed_packet

2005-09-08 Thread Eric Bergen
"packet too big" errors in replication are often a sign of corrupt binary logs. If it's on a slave reading the relay log often times flushing it will temporarily solve the problem. The easiest way to flush the relay logs is to do a slave stop; change master to back to the current file name and p

Help with SQL Command

2005-09-09 Thread Eric Mynes
ally type it or open the MySQL Query Brower and re-run the command. Any help would be greatly appreciated, but remember I am still real new to this. Thanks, eric

Re: Drop Table Problem

2005-09-28 Thread Eric Bergen
Try running a flush tables in mysql to make sure that mysqld knows about all the tables on disk. xtcsuk wrote: Running the command: Drop table if exists table1 complaints of table1 does not exist (Error: 1051). However, if table1 is swapped with another table, irrespective of its existence it

Re: IP Resolution

2005-10-14 Thread Eric Bergen
MySQL 4.1.14 is the current version. You should always upgrade to the lastest release and test your problem before trying to report bugs. Ben Clewett wrote: Dear MySQL, My MySQL 4.1.9 has lost the ability to work out what IP address clients are connecting from. Eg: $ mysqladmin processl

delete with an offset?

2005-10-21 Thread Eric Persson
r, any clues on how to solve this? Best regards, Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: delete with an offset?

2005-10-21 Thread Eric Persson
like such and idea that someone might have thought about it before. ;) thanks, Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problem compiling 5.0.15

2005-10-26 Thread Stewart, Eric
ive] Error 1 make[3]: Leaving directory `/usr/local/src/mysql-5.0.15/sql' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/local/src/mysql-5.0.15/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-5.0.15' make: *** [all] Error 2

utf8_bin collation sorting incorrectly?

2005-11-07 Thread Eric Herrera
utf8_data from test order by utf8_data collate utf8_bin to generate the "EXPECTED ORDER" data section below. However, "TEST ORDER" is what gets generated. Am I correct in my assumption that this is not ordering according to utf8 binary? Anyone have experience wi

Re: utf8_bin collation sorting incorrectly?

2005-11-08 Thread Eric Herrera
also.. ascii characters(1-127) sort correctly using utf8_bin Eric Herrera wrote: I'm attempting to sort using utf8_bin and I don't think its sorting properly. I believe I have everything set correctly. I've appended all related data. I also have a small perl script below

Re: utf8_bin collation sorting incorrectly?

2005-11-08 Thread Eric Herrera
== == Paul DuBois wrote: At 19:05 -0500 11/7/05, Eric Herrera wrote: I'm attempting to sort using utf8_bin and I don't think its sorting properly. I believe I have everything set correctly. I've append

5.0.15 Compile error on Redhat EL4.0

2005-11-14 Thread Stewart, Eric
4]: Leaving directory `/usr/local/src/mysql-5.0.15/sql' make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/usr/local/src/mysql-5.0.15/sql' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/local/src/mysql-5.0.15/sql' make[1]: *** [all-recursive] Error 1 make[1]:

Re: recursive queries

2005-12-09 Thread Eric Bergen
I believe that some time in the future mysql will support oracle style connect by prior syntax but it's not implemented yet. Gleb Paharenko wrote: Hello. Though I haven't read this article, but its title looks promicing: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

Re: Optimize: 14 hours and still running!

2005-12-09 Thread Eric Bergen
Is the box swapping? Gleb Paharenko wrote: Hello. As was mentioned by other members without seeing your configuration settings it is difficult to say about InnoDB performance. You can indirectly monitor the OPTIMIZE speed by ROW OPERATIONS section of SHOW INNODB STATUS. For InnoDB it maps to A

Re: How can you tell if a table is corrupted?

2005-12-11 Thread Eric Bergen
y, is there a way to tell if a table has been corrupted? We're having some > weird things happening and the only thing I can think of is possible > corruption of a table, but is there anything you can do to find out? > > Jenifer > > -- Eric Bergen [EMAIL PROTECTED]

Re: Can foreign keys reference tables in another database?

2005-12-16 Thread Eric Grau
her database. Using your example databases and tables, you can create the foreign key by specifying the database name in the REFERENCES clause like this: ALTER TABLE Application.tblAddress ADD FOREIGN KEY (State) REFERENCES *Common*.tblState (State); Eric

Re: Can foreign keys reference tables in another database?

2005-12-16 Thread Eric Grau
Eric Grau wrote: JamesDR wrote: Scott Plumlee wrote: sol beach wrote: Why in the world are you trying to keep multiple copies of the data? Why can't you just access the 'master database'? On 12/16/05, Scott Plumlee <[EMAIL PROTECTED]> wrote: I am trying to mainta

Slave to multiple masters?

2005-12-28 Thread Eric Anderson
ad on the slave. -- - Eric Anderson Mac and Bumble Bumble Cash ICQ 3849549 http://www.macandbumble.com http://www.bumblecash.com San Diego, CA<[EMAIL PROTECTED]>

Re: key_buffer_size vs innodb_buffer_pool_size

2006-01-15 Thread Eric Bergen
> > > - > Yahoo! Photos > Got holiday prints? See all the ways to get quality prints in your hands > ASAP. > -- Eric Bergen [EMAIL PROTECTED] http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Change on LEFT JOIN ON syntax in 5.x?

2006-02-20 Thread Eric Persson
recognized for some reason. Does anyone have any hints about this? Thanks in advance, Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   5   6   7   8   9   >