Re: source compilatio or install precompiled packages

2006-10-24 Thread Rocco Di Leo
Hi Jose, there are only a few reasons why you should NOT use a pre-compiled package: 1. The version of MySQL you want to use (e.g. Alpha-Version) does not exist for your machine 2. You want to use features not available in the pre-compiled version. On the other hand there are some very good rea

Re: Moving DB to another System

2006-10-12 Thread Rocco Di Leo
Hello Ow Mun, there are various ways to backup InnoDB tables 1. SELECT ... INTO OUTFILE statement for your tables and reimport them 2. ibbackup (a commercial tool to copy InnoDB Databases while the server is running 3. Stop the server, copy the innodb tablespace files and logfiles to the new loc

Re: Trying to run two mysql instances on one server

2006-10-12 Thread Rocco Di Leo
Hello Low Kian, first, you cannot attach files to this mailing list, however from the error, i assume that you have not specified different socks and ports for each MySQL instance. You need to put that information into your configuration file for each server , e.g.: #server 1 option file port=33