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
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: MySQL Error Number 1045 Access denied

2008-08-18 Thread Paul Choi
-- 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: CHANGE MYSQL DATADIR TO ANOTHER HARDISK

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

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

Upgrading from 4.1 to 5.0

2008-04-23 Thread Paul Choi
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 unsubscribe:http://lists.mysql.com/[EMAIL