Re: Upgrade Mysql

2009-05-20 Thread Paul Choi
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,

Re: Setup a replication slave without stopping master

2009-01-06 Thread Paul Choi
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

Re: CHANGE MYSQL DATADIR TO ANOTHER HARDISK

2008-08-18 Thread Paul Choi
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]>

Re: MySQL Error Number 1045 Access denied

2008-08-18 Thread Paul Choi
-- > 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]>

Re: MYSQL PROCESS

2008-08-15 Thread Paul Choi
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]>

Re: Dismal performance on a 16G memory/8 core server - my.cnf settings?

2008-04-24 Thread Paul Choi
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

Upgrading from 4.1 to 5.0

2008-04-23 Thread Paul Choi
. 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