On Thu, May 17, 2001 at 06:36:23AM -0700, mansoor spake thusly:
*] i m new to mysql, how i can convert a string 28-MAR-2001 to date
*]
In what language?
--
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
Peter L. Berghold[EMAIL PROTECTED]
"Linu
Joe:
AFAIR, as an ex NT4 sysadmin, system error 5 is access denied - you have a
permissions problem somewhere.
On NT4 these can be a swine to solve. Check out your NT system error logs
as a starting point.
HTH.
David
>By the way, I once first tried to set up the slave on a NT machine. But f
On Wed, May 09, 2001 at 11:18:14AM -0600, Joseph Chow wrote:
> Hi, Jeremy,
>
> It is very nice to talk to you. Thanks for your information. It's
> working now, but I did nothing but going over the procedure again.
> I may make some mistakes during my operations. But it is really a
> good idea
e
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 09, 2001 10:33 AM
To: Joseph Chow
Cc: [EMAIL PROTECTED]
Subject: Re: need help on "replication"
On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote:
> Hi, there,
>
> This is
On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote:
> Hi, there,
>
> This is my first try on this mailing list. I am a new user of mysql
> and need some help about "replication" on mysql 3.23.36. I had
> followed the manual to set up master/slave server. At the
> beginning, they are c
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
New Style MySQL Personnel wrote:
>
> >
> mysql> use lum
> 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 'users'
> Database changed
> mysql> select * from users;
> ERROR 1017:
>
mysql> use lum
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 'users'
Database changed
mysql> select * from users;
ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)
> >
On Mon, 23 Apr 2001, New Style MySQL Personnel wrote:
>
> Please anyone. I really need some ideas.
> I copied my database files made with 23.29 to 23.26 and now I get this. I
> chowned mysql.mysql and chmoded 660.
> The location of the databases is good because I have some other databases
> crea
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 'classe
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,
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 2
>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 copie
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
> appreciat
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 als
-Original 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 t
> Do you have an index on files that starts with dir_id and
> an index on dirs that stats with id and having date in the files
> index (after dir_id) might be helpful although I'm not sure.
Sorry, I don't understand exactly what you mean, but...
> you could provide the output of
> show keys from
> /* 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,
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.i
les, add:
key dir_id(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
> 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;
>
>
what 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 rea
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
LE
L. Clark
Cc: [EMAIL PROTECTED]
Subject: Re: Need help optimizing this (simple) query
> 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-u
> 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
--
> 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 t
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
This is a permissions issue. Check the directories mysql is located in
and grant executable permissions. Also verify ownership requirements for
each of these directories.
Charles Hagen
On Mon, 12 Mar 2001, Russ Heaton wrote:
>
> I just installed RH 7.0 selecting the 'install everything' optio
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 pos
No it's not possible but you can just read in all tables anyway and ignore
the columns you don't want.
- Original Message -
From: "David Jacobowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 7:33
Subject: Need help with select statement.
> Dear Sir,
>
>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 as
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 /dir/to/mysql.serve
There'll be a .err file in your ~mysql/var directory - have a
look at it, and it should give you a pointer as to the precise problem.
regards,
P
On
Fri, 9 Feb 2001, Matt Davis wrote:
> I am new to MySQL and have just installed the MySQL rpm files to my Linux
> box.
>
> I have run "mysql_insta
Brad Fitzpatrick writes:
> MySQL 3.23.32 has been crashing on me quite frequently, as well as the past
> several versions. At first I gave MySQL the benefit of the doubt and blamed
> it on the compilation. I've since tried 6 different builds, ranging from
> fully optimized with no debugging
You should ponder install mysql using
ports
eg
/usr/ports/database/mysql-server.xxx.xx
make install
make clean
This will put files in standard places for FreeBSD It will install any
dependencies for you automatically.
If you don't know how to insitall mysql using ports email me off the mysq
rror, 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: nee
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
-
On Tue, 23 Jan 2001, Alexei Sh. wrote:
|Ok I need help
|So i have table with primary key ID,
|it's fills with something like 1,2,4,5
|So and i have another table in which i would like to put data from first
|table from row ID
|how to do this
||| ||
|| test1 | |
501 - 540 of 540 matches
Mail list logo