Got a wild hair this A.M. and decided to inundate my two brain cells. "Man yum" includes this:
update If run without any packages, update will update every currently installed package. ... assumed to be a shell glob and any matches are then installed.
If the --obsoletes flag is present yum will include package obsoletes in its calculations - this makes it better for distro- version changes, for example: upgrading from somelinux 8.0 to somelinux 9.
Hmmm. Cell number 2 doesn't forget much. I recall several admonitions that major upgrade should take the form of a new install. E.g. CentOS 3* to CentOS 4*. The paragraph above *seems* to indicate that a major upgrade might be doable? Moreover, it prompts the questions:
1) "What are the downsides, if any?" 2) "Has anybody tried it recently?" 3) "Have any results to report?"
No pressing need, just curious.
TIA
William L. Maltby wrote:
Got a wild hair this A.M. and decided to inundate my two brain cells. "Man yum" includes this:
update If run without any packages, update will update every currently installed package. ... assumed to be a shell glob and any matches are then installed.
If the --obsoletes flag is present yum will include package obsoletes in its calculations - this makes it better for distro- version changes, for example: upgrading from somelinux 8.0 to somelinux 9.Hmmm. Cell number 2 doesn't forget much. I recall several admonitions that major upgrade should take the form of a new install. E.g. CentOS 3* to CentOS 4*. The paragraph above *seems* to indicate that a major upgrade might be doable? Moreover, it prompts the questions:
- "What are the downsides, if any?"
- "Has anybody tried it recently?"
- "Have any results to report?"
No pressing need, just curious.
yum will upgrade pkgs, but not all pkgs like that - eg. moving from kernel2.4 to 2.6 the 'centos way' - moving from devfs to udev, major python + rpm upgrade in itself.
check list history from early 2005, this move from centos3 -> centos4 was documented and thrashed out a few times.
plus, packages change - not everything from el3 made it to el4 - and what about non core installed pkgs and install from source pkgs!
On Thu, 2006-04-27 at 14:12 +0100, Karanbir Singh wrote:
William L. Maltby wrote:
<snip>
If the --obsoletes flag is present yum will include package obsoletes in its calculations - this makes it better for distro- version changes, for example: upgrading from somelinux 8.0 to somelinux 9.Hmmm. Cell number 2 doesn't forget much. I recall several admonitions that major upgrade should take the form of a new install. E.g. CentOS 3* to CentOS 4*. The paragraph above *seems* to indicate that a major upgrade might be doable? Moreover, it prompts the questions:
- "What are the downsides, if any?"
- "Has anybody tried it recently?"
- "Have any results to report?"
No pressing need, just curious.
yum will upgrade pkgs, but not all pkgs like that - eg. moving from kernel2.4 to 2.6 the 'centos way' - moving from devfs to udev, major python + rpm upgrade in itself.
check list history from early 2005, this move from centos3 -> centos4 was documented and thrashed out a few times.
plus, packages change - not everything from el3 made it to el4 - and what about non core installed pkgs and install from source pkgs!
Thanks for taking the time. I had forgotten about those. I was mostly hoping that use of plugins, yum improvements... might have resolved some of the issues and maybe someone had tried more recently.
On Thu, 2006-04-27 at 09:29 -0400, William L. Maltby wrote:
On Thu, 2006-04-27 at 14:12 +0100, Karanbir Singh wrote:
William L. Maltby wrote:
<snip>
If the --obsoletes flag is present yum will include package obsoletes in its calculations - this makes it better for distro- version changes, for example: upgrading from somelinux 8.0 to somelinux 9.Hmmm. Cell number 2 doesn't forget much. I recall several admonitions that major upgrade should take the form of a new install. E.g. CentOS 3* to CentOS 4*. The paragraph above *seems* to indicate that a major upgrade might be doable? Moreover, it prompts the questions:
- "What are the downsides, if any?"
- "Has anybody tried it recently?"
- "Have any results to report?"
No pressing need, just curious.
yum will upgrade pkgs, but not all pkgs like that - eg. moving from kernel2.4 to 2.6 the 'centos way' - moving from devfs to udev, major python + rpm upgrade in itself.
check list history from early 2005, this move from centos3 -> centos4 was documented and thrashed out a few times.
plus, packages change - not everything from el3 made it to el4 - and what about non core installed pkgs and install from source pkgs!
Thanks for taking the time. I had forgotten about those. I was mostly hoping that use of plugins, yum improvements... might have resolved some of the issues and maybe someone had tried more recently.
NOPE ... one should NEVER (IMHO) upgrade from EL3 to EL4 ... Even using the CDs and "linux upgradeany" is not really recommended.
See this link: http://www.centos.org/modules/smartfaq/faq.php?faqid=27
Does anyone know the syntax for deleting a MYSQL database? I created one and messed up something in a config.inc.php on myphpadmin and now im locked out when I tried to access the http authentication for myphpadmin.
I want to delete the database, recreate all and take better notes on passwords etc..
Thanks for the reply.
-- Gateway Anti-Spam Anti-Virus Network Designs Inc --
On Tue, 2 May 2006 13:24:21 -0700 "Chris Heiner" cheiner@networkdesignsinc.net wrote:
Does anyone know the syntax for deleting a MYSQL database? I created one and messed up something in a config.inc.php on myphpadmin and now im locked out when I tried to access the http authentication for myphpadmin.
I want to delete the database, recreate all and take better notes on passwords etc..
# in mysql :
drop database database-name;
where database-name is the name of the database you want to remove
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Chris Heiner Sent: May 2, 2006 2:24 PM To: 'CentOS mailing list' Subject: [CentOS] Deleting a MYSQL database
Does anyone know the syntax for deleting a MYSQL database? I created one and messed up something in a config.inc.php on myphpadmin and now im locked out when I tried to access the http authentication for myphpadmin.
drop database databasename; or drop databasename;
if im not mistaken :)
James Gagnon
Works great.
Thanks!
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of James Gagnon Sent: Tuesday, May 02, 2006 1:23 PM To: 'CentOS mailing list' Subject: RE: [CentOS] Deleting a MYSQL database
-----Original Message----- From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On Behalf Of Chris Heiner Sent: May 2, 2006 2:24 PM To: 'CentOS mailing list' Subject: [CentOS] Deleting a MYSQL database
Does anyone know the syntax for deleting a MYSQL database? I created one and messed up something in a config.inc.php on myphpadmin and now im locked out when I tried to access the http authentication for myphpadmin.
drop database databasename; or drop databasename;
if im not mistaken :)
James Gagnon
_______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-- Gateway Anti-Spam Anti-Virus Protection by Network Designs Inc. 949-727-3393 --
-- Gateway Anti-Spam Anti-Virus Network Designs Inc --
Chris Heiner wrote:
Does anyone know the syntax for deleting a MYSQL database? I created one and messed up something in a config.inc.php on myphpadmin and now im locked out when I tried to access the http authentication for myphpadmin.
I want to delete the database, recreate all and take better notes on passwords etc..
Thanks for the reply.
http://dev.mysql.com/ -> Documentation
Please don't steal the thread.
-
albi -
Chris Heiner -
James Gagnon -
Johnny Hughes -
Karanbir Singh -
Kari Salovaara -
William L. Maltby