COuld try a mysqldump to backup and restore the tables on the new/other
machine. This should get you past the problems you found earlier.
Remember to add the propriate users to the new machine..
Bye,
B.
mysql use lum
Reading table information for completion of table and column names
You
I copied my database files made with 23.29 to 23.26 and now I get this. I
chowned mysql.mysql and chmoded 660. What's wrong?
Perhaps or.. the location of your database is different.. or.. you
didn't copy everything.. including subdirectories.
Solution: check the location and if you copied
The location is good because I have some other databases created with 36
and they work fine. I copied ALL the database's files to /var/lib/mysql
where the others are and I get this error. Any idea?
On Mon, 23 Apr 2001, B. van Ouwerkerk wrote:
I copied my database files made with 23.29 to
chown -R mysql /var/lib/mysql
New Style MySQL Personnel wrote:
The location is good because I have some other databases created with 36
and they work fine. I copied ALL the database's files to /var/lib/mysql
where the others are and I get this error. Any idea?
On Mon, 23 Apr 2001, B.
Hi,
mysql use lumina;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'absences'
Didn't find any fields in table 'admins'
Didn't find any fields in table 'classes'
Larry, if you haven't resolved this yet - you might want to install from the
sources, like I do. I am also running FreeBSD 4.2, here is what I did, and
it seems to work like a champ.
1) get the source from
www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.37.tar.gz
2) put this file in some directory
I have not been able to figure this out, yet. I found the file
/usr/share/mysql/make_binary_distribution and tried a make on it; no
luck. I scoured the documentation on the web and in my own distribution
and have not been able to find out what to do next. See Below. I would
appreciate
Hi,
Ok, I'm out of ideas. The additional index should have sped things up,
not
slowed them down. I've got some tables with 26,000 rows in it and I do 4
joins (using a WHERE clause) with smaller tables without a hitch.
Sorry I can't help.
But thanks a lot for trying. :) And thanks also to
A .03 sec left join PREVENTS you from using MySQL.
This must be a troll.
You have no where clause, so no index is used.
Jordan Russell wrote:
Hi everyone,
I'm stuck on one issue which is preventing me from using MySQL in production
on one particular database. (This is similar to my last
A .03 sec left join PREVENTS you from using MySQL.
This must be a troll.
Sigh...
I guess I failed to mention this was a deliberately simplified example in
order to pose my question in a easy-to-understand manner. In reality, there
are much more records, and a more complex query, where the
You have no where clause, so no index is used.
Oops, missed this part.
Where exactly do I need a WHERE clause, and for what? The first query
doesn't have a WHERE clause and yet it appears to be using the "date" index.
Jordan Russell
Hi,
Thanks for the reply.
Hve you read
http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L
EFT_JOIN_optimization
?
Yes, many times, as well as just about everything else in the Performance
chapter. Am I missing something totally obvious? Should I even be using a
LEFT
were your results?
Cal
http://www.calevans.com
-Original Message-
From: Jordan Russell [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 2:27 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: Re: Need help optimizing this (simple) query
Hi,
Thanks for the reply.
Hve you read
http
Everything I've seen on this list indicates that using LEFT JOIN negates
using an index. (WARNING: This is 3rd hand info and as such should be
viewed
skeptically!)
Have you tried:
SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
ORDER BY files.date DESC LIMIT 1;
If so,
(dir_id),
to the above.
Cal
http://www.calevans.com
-Original Message-
From: Jordan Russell [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 2:48 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: Re: Need help optimizing this (simple) query
Everything I've seen on this list indicates
Jordan Russell wrote:
Everything I've seen on this list indicates that using LEFT JOIN negates
using an index. (WARNING: This is 3rd hand info and as such should be
viewed
skeptically!)
Have you tried:
SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
ORDER BY
/* This table has 5000 rows */
CREATE TABLE files (
id int(11) NOT NULL auto_increment,
dir_id int(11) NOT NULL default '0',
name varchar(100) NOT NULL default '',
date datetime default NULL,
PRIMARY KEY (id),
KEY date (date)
) TYPE=MyISAM;
for grins and giggles, add:
key
Message-
From: Jordan Russell [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 3:07 PM
To: Steve Ruby
Cc: Cal Evans; [EMAIL PROTECTED]
Subject: Re: Need help optimizing this (simple) query
Do you have an index on files that starts with dir_id and
an index on dirs that stats with id
Thanks Rolf
From: "Rolf Hopkins" [EMAIL PROTECTED]
To: "David Jacobowitz" [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: Need help with select statement.
Date: Tue, 27 Feb 2001 09:21:57 +0800
No it's not possible but you can just read in all tables anyway and ignore
t
From what you've written, I'm guessing that you're using windoze so,
firstly, are you sure you downloaded the Windoze version and not the Unix
version? The other is, mysql has a very good manual on their website which
describes how to install.
- Original Message -
From: "Mehmet agar"
I am new to MySQL and have just installed the MySQL rpm files to my Linux
box.
I have run "mysql_install_db" with no problems and I have then run
"safe_mysqld " this comes up with the messsage
"starting mysql daemon with databses from /var/lib/mysql
mysqld daemon ended"
I assumed that
Matt, I'm fairly new to MySQL myself, but it sounds like your
mysqld is not starting up when you issue safe_mysqld. Instead
of invoking safe_mysqld directly, find the "mysql.server" file that
got installed with mysql, and start mysqld with that by doing
something like:
cd
Right, I trying to compile MySQL latest stable on FreeBSD 4.2 but I
get stuck sql_yacc.cc ..
Any pointers?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
414-5359
got error, then say what error you've got.
Good luck!
- Original Message -
From: "System Administrator a.k.a. The Root of the Problem"
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, January 26, 2001 10:00 PM
Subject: Re: need help
Right, I trying to
501 - 524 of 524 matches
Mail list logo