Hi,
I don't know what Linux distro you're using, but I'd make a backup of
/var/lib/mysql dir before you do anything (in case the mysql package
decides to nuke your stuff). If you have a dump of your dbs, that's fine
too. And maybe a backup of your my.cnf.
Just install the new mysql package,
should work the same
way with LVM.
-Paul Choi
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
gt; Hi all,
> >
> > On my debian system, i have two hardisk. I want to change the mysql datadir
> > to another hardisk (/dev/cciss/c0d1p1 /data ). Please tell me how to do
> > this.
> >
> > /dev/cciss/c0d0p1 34G /
> > /dev/cciss/c0d1p1 68G /data
> >
> > --
> > Krishna Chandra Prajapati
> >
--
Paul Choi <[EMAIL PROTECTED]>
--
> Andy Shellam
> Business Systems Architect
>
> Network Mail
> NetServe Support
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
> --
> Jim Lyons
> Web developer / Database administrator
> http://www.weblyons.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Paul Choi <[EMAIL PROTECTED]>
k/?6875772)
> >
> >
> > This email and any attached files are confidential and copyright protected.
> > If you are not the addressee, any dissemination of this communication is
> > strictly prohibited. Unless otherwise expressly agreed in writing, nothing
> > stated in this communication shall be legally binding.
> >
> > The ultimate parent company of the Atkins Group is WS Atkins plc.
> > Registered in England No. 1885586. Registered Office Woodcote Grove,
> > Ashley Road, Epsom, Surrey KT18 5BW. A list of wholly owned Atkins Group
> > companies registered in the United Kingdom can be found at
> > http://www.atkinsglobal.com/terms_and_conditions/index.aspx
> >
> > Consider the environment. Please don't print this e-mail unless you really
> > need to.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
>
--
Paul Choi <[EMAIL PROTECTED]>
I think what we need to know is more stuff about the database itself.
How big is it? I assume if you were able to serve it from a Mac Mini it
can't be all that big.
16GB should be big enough to contain all the data and serve it up quickly.
And while 4-disk RAID 5 isn't all that great, it's cert
. Run mysql_upgrade
Copies to TMP table. Takes forever... This is unacceptable for us.
What is the recommended way to upgrade from 4.1 to 5.0? Or are we stuck
using 4.1 forever?
-Paul Choi
Plaxo, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib