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
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]
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
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
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
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.
>
>
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
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
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
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,
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
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
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
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
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
--
(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
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
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
? 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.
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
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
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
&
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
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)
>
>
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:
[
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.
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
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
---
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
, 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
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
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,
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
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
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
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
: 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
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
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
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
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]
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
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
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
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
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
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
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
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
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
--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
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
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
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:/
+
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
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]
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
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
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
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]
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
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!
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]>
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<
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.
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,
+
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
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]
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
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
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]
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
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
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
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
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
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]
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
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
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
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
"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
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
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
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
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]
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]
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_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
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
==
==
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
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]:
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
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
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]
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
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
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]>
>
>
> -
> 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]
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 - 100 of 809 matches
Mail list logo