What command to restore MySQL DataBase ?
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. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cant start MySQL when used my-huge.cnf.
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 # required for replication' 030227 10:15:21 mysqld ended In my-huge.cnf have this line below that I think cause error. # Replication Master Server (default) log-bin # required for replication server-id = 1 # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted How to solve this problem ? thank you very much. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to convert Database ?
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. Anyone have tools or have another method to convert it ? Please let me know more detail. thank you very much. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't install mysql on Solaris-2.5.1.
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 --enable-assembler \ --with-charset=tis620 And then when I used command make, it has error messages below. ft_dump.o: In function `main': ft_dump.o(.text+0x26c): undefined reference to `snprintf' collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `ft_dump' Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /misc/mysql/mysql-4.0.1-alpha *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Please let me know how to solve this problem. thank you very much. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't install mysql on Solaris-2.5.1.
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 --enable-assembler \ --with-charset=tis620 And then when I used command make, it has error messages below. ft_dump.o: In function `main': ft_dump.o(.text+0x26c): undefined reference to `snprintf' collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `ft_dump' Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /misc/mysql/mysql-4.0.1-alpha *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Please let me know how to solve this problem. thank you very much. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't install mysql on Solaris-2.5.1.
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 --enable-assembler \ --with-charset=tis620 And then when I used command make, it has error messages below. ft_dump.o: In function `main': ft_dump.o(.text+0x26c): undefined reference to `snprintf' collect2: ld returned 1 exit status *** Error code 1 make: Fatal error: Command failed for target `ft_dump' Current working directory /misc/mysql/mysql-4.0.1-alpha/myisam *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /misc/mysql/mysql-4.0.1-alpha *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Please let me know how to solve this problem. thank you very much. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't run Apache-1.3.22 with MySql-4.0.1.
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 \ --with-mysql=/usr/local/mysql --with-imap=../imap-2001a --with-ldap=/usr/local/openldap ./configure at Apache-1.3.22 state shown below. SSL_BASE=/usr/local/ssl EAPI_MM=../mm-1.1.3 \ ./configure --enable-module=ssl \ --prefix=/usr/local/apache --enable-shared=ssl \ --activate-module=src/modules/php4/libphp4.a But when I used command apachectl startssl, it has error messages that show in file error_log show below. [Mon Dec 24 23:49:12 2001] [alert] (22)Invalid argument: setgid: unable to set group id to Group 4294967295 [Mon Dec 24 23:49:13 2001] [alert] Child 20962 returned a Fatal error... Apache is exiting! and error messages in file ssl_engine_log show below. [24/Dec/2001 23:49:12 20957] [warn] Init: (myhost.com:443) RSA server certificate CommonName (CN) `www.snakeoil.dom' does NOT match server name!? please let me know more detail how to solve this problem ? thank you very much. regards, Somsak. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php