RE: Upgrading help please

[Andrew Rothwell]

 Yup that worked - 
I rebooted my machine - and I was allowed in - 

Thank you very much

Andrew

-Original Message-
From: Brian Snyder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 05, 2003 3:30 PM
Cc: MySQL
Subject: Re: Upgrading help please

Andrew,
I had the same problem and had to stop and restart the servers. Give that a
shot.

brian

On Wed, 2003-11-05 at 17:19, Andrew wrote:
 Good day List,
 I have just upgraded from 3.23 -4.0.16
 
 I downloaded all the RPM's and then ran rpm -U *.rpm
 
 It did all that it was supposed to do, and then told me to use the 
 /usr/bin/mysql_fix_privilege_tables script
 
 which I did got horrid errors
 ERROR 2002: Can't connect to local MySQL server through socket 
 '/var/lib/mysql/mysql.sock' (2)
 
 So I specified
 mysql_fix_privilege_tables root_password
 
 Same Errors (2002)
 
 Tried the other method that is on the mysql manual 
 mysql_fix_privilege_tables --password=root_password
 
 Same error 2002.
 
 now Unfortunately I am unable to even connect to mysql with either 
 mysqladmin or the client.
 
 MySQL-bench-4.0.16-0.i386.rpm
 MySQL-client-4.0.16-0.i386.rpm
 MySQL-devel-4.0.16-0.i386.rpm
 MySQL-embedded-4.0.16-0.i386.rpm
 MySQL-Max-4.0.16-0.i386.rpm
 MySQL-server-4.0.16-0.i386.rpm
 MySQL-shared-4.0.16-0.i386.rpm
 MySQL-shared-compat-4.0.16-0.i386.rpm
 
 is a list of the RPMS that I downloaded and ran.
 
 Any ideas and help would be most appreciated.
 
 Thank you
 Andrew
 
 
 Message sent using UebiMiau 2.7.2
 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: A final Windows MySQL PHP plea

[Andrew Rothwell]

I think that if Apache did that - then it would certainly not be one of
(Bthe most widely used Webservers in use today, and it would not be
(Breviewed as extremely stable, IIS on the hand *smirks*
(B
(BAndrew
(B
(B-Original Message-
(BFrom: Martin Gainty [mailto:[EMAIL PROTECTED] 
(BSent: Wednesday, August 13, 2003 11:00 PM
(BTo: Nils Valentin; Andrew Rothwell
(BCc: [EMAIL PROTECTED]
(BSubject: Re: A final Windows MySQL PHP plea
(B
(B
(BI have heard Apache croaks after 130 connections..
(B-M
(B- Original Message -
(BFrom: "Nils Valentin" [EMAIL PROTECTED]
(BTo: "Andrew Rothwell" [EMAIL PROTECTED]
(BCc: [EMAIL PROTECTED]
(BSent: Wednesday, August 13, 2003 6:34 PM
(BSubject: Re: A final Windows MySQL PHP plea
(B
(B
(BHi Andrew,
(B
(BI guess your reply was meant for Gary (the original poster of this
(Be-mail).
(B
(BI will foward your request to the mailing  list.
(B
(BBest regards
(B
(BNils Valentin
(BTokyo/Japan
(B
(B
(B
(B
(B WOW!!!
(B That kind of System Power and you are wasting it on Windows and IIS 
(B E!
(B
(B Sorry - but Dual Proc Support, with 2gigs of RAM would Love Redhat 9.0
(B
(B like a kid loves chocolate.
(B
(B I don$B!G(Bt know about the more than 100 concurrent users, but bear in 
(B mind (as I understand it) that means that you can have up to 100 
(B queries at 1 time, as soon as the query is over, the next user is 
(B available for his query.
(B
(B Linux itself can support 1000's of users at one time -
(B You might be surprised.
(B
(B Andrew
(B
(B -Original Message-
(B From: Nils Valentin [mailto:[EMAIL PROTECTED]
(B Sent: Tuesday, August 12, 2003 10:04 PM
(B To: Gary Broughton; [EMAIL PROTECTED]
(B Subject: Re: A final Windows MySQL PHP plea
(B
(B
(B Hi Gary,
(B
(B I understood that the packages provided by MySQL are set to 100 
(B concurrent users by default, so what you ae asking is actually if 
(B somebody successfully
(B compiled a version for more than 100 concurrent users and was able to
(B use it
(B in a production environment ?
(B
(B Do I understand that correct ?
(B
(B My guess would be that you are more likely to find Linux users having 
(B done such a setup. Unfortunately I haven'Tt had such an experience 
(B yet, but as you
(B probably now Dell has made a study (which is also announced on
(Bwww.mysq.
(B com)
(B which describes their experience, perhaps it contains the one or the
(B other
(B useful tip.
(B
(B http://www.dell.com/us/en/biz/topics/power_ps2q03-jaffe.htm
(B
(B Best regards
(B
(B Nils Valentin
(B Tokyo/Japan
(B
(B 2003$BG/(B 8$B7n(B 13$BF|(B $B?eMKF|(B 01:21$B!"(BGary Broughton 
(B $B$5$s$O=q$-$^$7$?(B:
(B  Hi all
(B 
(B  Is there anybody out there who has managed to successfully configure
(B
(B  Win2000, IIS5, MySQL 4.0.14 and PHP 4.3.2 (ISAPI) to work with a 
(B  couple of hundred users at any one time?  I have chucked absolutely 
(B  everything I can think of at this, but the MySQL (it seems) simply 
(B  eats all the available CPU within a short space of time (regardless 
(B  of
(B 
(B  users) and brings the site to a halt.  My last throw of the dice 
(B  today
(B 
(B  was to install all on a new Dual 1.8Ghz Pentium, with three hard 
(B  disks
(B 
(B  in a RAID array, and 2GB memory, but it's achieved pretty much 
(B  nothing.  I am now desperate, and if anyone has any flash of 
(B  inspiration for me, I'm all ears.  The previous ASP version of the 
(B  site runs like a dream, but there's something I'm either doing 
(B  wrong, or this new combination of software simply doesn't like.
(B 
(B  Many thanks
(B 
(B  Stressed Gary
(B
(B --
(B ---
(B Valentin Nils
(B Internet Technology
(B
(B  E-Mail: [EMAIL PROTECTED]
(B  URL: http://www.knowd.co.jp
(B  Personal URL: http://www.knowd.co.jp/staff/nils
(B
(B--
(B---
(BValentin Nils
(BInternet Technology
(B
(B E-Mail: [EMAIL PROTECTED]
(B URL: http://www.knowd.co.jp
(B Personal URL: http://www.knowd.co.jp/staff/nils
(B
(B
(B--
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:
(Bhttp://lists.mysql.com/[EMAIL PROTECTED]
(B
(B
(B
(B-- 
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:
(Bhttp://lists.mysql.com/[EMAIL PROTECTED]
(B
(B
(B
(B
(B
(B--
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fixing autoincrement

[Andrew Rothwell]

Hello List,
I have a movies database, that I had an autoincrementing field for
counting purposes.What I did though was remove some of the rows out of
the table, now my table is reporting an incorrect number of movies
listed.What I am trying to do is after is have done the following
command

Mysql delete from movies where movie_number = 74 limit 1;
Query OK, 1 row affected (0.00 sec)
I get the following using mysqldump:

INSERT INTO movies VALUES ('Six feet under','Drama','Peter
Krause','Michael C. Hall','Frances Conroy','Alan Ball','A drama series
that takes a darkly comical look at members of a dysfunctional Pasadena
family that runs an independent funeral
home.','http://us.imdb.com/Title?0248654',73);
INSERT INTO movies VALUES ('Tomb Raider','Action','Angelina Jolie','Jon
Voight','Iain Glen','Simon West','A member of a rich British
aristocratic family, Lara Croft is a \tomb raider\ who enjoys
collecting ancient artifacts from ruins of temples, cities, etc.
worldwide, and doesn\'t mind going through death-defying dangers to get
them. She is skilled in hand-to-hand combat, weapons training, and
foreign languages - and does them all in tight
outfits.','http://us.imdb.com/Title?0146316',75);

There is no 74 Is there a way to force the DB upon removal of a row (74)
to renumber the autoincremented fields?

I have tried to flush tables, but that did not work - 

btw I am using the last stable 3 release - but I will be updating to the
latest stable 4 release in the next day or so. THank you 
Andrew



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Adding and filling a new column

[Andrew Rothwell]

Good day list,
 
I hope that this is an easy one for you guys to help me with, I am
relatively new to DB design, and I realized that I have left out a few
very important Indexing and counting columns.
 
So my question is this,
 
What do I need to do to fill in new column, I would like to have it
auto_increment, and adding that field is easy, however I have about 200
or so entries in the DB already.
 
So I can add the column, and I can set it to have an auto_increment, but
will that start out at 201? or will it start at 1 and propogate through?
 
I hope this makes sense.
 
THank you in advance for you time.
 
Andrew