What command to restore MySQL DataBase ?

2003-02-27 Thread Somsak RAKTHAI
Dear sir, I used mysql-4.0.10-gamma on RedHat-8.0. I used my.cnf from support-files/my-large.cnf. When I backup all DataBases I used command below. mysqldump --all-databases all_databases.sql I want to know what command to restore Database ? thank you very much.

Cant start MySQL when used my-huge.cnf.

2003-02-27 Thread Somsak RAKTHAI
Dear sir, I used mysql-4.0.10-gamma on RedHat-8.0. My system have memory 1G therefore I used my.cnf from support-files/my-huge.cnf. But I cant start MySQL. It has error messages below. 030227 10:15:21 mysqld started /usr/local/mysql/libexec/mysqld: ERROR: unknown option '--log-bin

How to convert Database ?

2002-03-05 Thread Somsak RAKTHAI
Dear sir, I use MySQL-3.23.35 before that running on FreeBSD-4.2. Now I use MySQL-4.0.1 running on FreeBSD-4.5. I want to convert Database ... from MySQL-3.23.35 that store at /usr/local/mysql/data to MySQL-4.0.1 that store at /usr/local/mysql/var.

Can't install mysql on Solaris-2.5.1.

2002-01-30 Thread Somsak RAKTHAI
Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory

Can't install mysql on Solaris-2.5.1.

2002-01-28 Thread Somsak RAKTHAI
Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory

Can't install mysql on Solaris-2.5.1.

2002-01-20 Thread Somsak RAKTHAI
Dear sir, I used mysql-4.0.1 running on Solaris-2.5.1 and compile with Gcc-2.95.3. (package from www.sunfreeware.com) I used command below. CC=gcc CFLAGS=-O3 \ CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory

Can't run Apache-1.3.22 with MySql-4.0.1.

2001-12-24 Thread Somsak RAKTHAI
Dear sir, I used Slackware 7.1. Now I can compile Apache-1.3.22 with MySql-4.0.1. But I can't run Apache-1.3.22 with Mysql-4.0.1. I think this problem may cause from Mysql-4.0.1. ./configue at Php-4.0.1 state shown below. ./configure --with-apache=../apache_1.3.22 \