MySQL install problems on OSX 10.4

I've just installed MySQL 4 4.1.12_1 +server using darwinports but I can't seem to get past this error. After installing it tells me that it cold not resolve my IP. Mattys-iMac-G5:/opt/local/bin matty$ sudo -u mysql ./mysql_install_db Password: WARNING: The host 'Mattys-iMac-G5' could not be

Which License of MySQL Should We Buy?

hi, I'm working in a company which wants to have a client/server application on MySQL DBMS. our company uses MyODBC and MySQL Connector/.Net. We want to sell our application which license should we buy? Should we buy MySQL Network license? or there are seperate licenses for connectors? and

Oddity with data pointer size

I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as we're starting to encounter quite a few tables that are larger than 4 GB. However, the create table statements used by the software application using the DB don't seem to be creating tables with pointers 4 bytes. Recent

Re: Replication started but not running

Hello. Check your error log. Have a look here: http://bugs.mysql.com/bug.php?id=12216 Jeff [EMAIL PROTECTED] wrote: Hey all, Just brought up a new RH EL3 server and updated MySQL to ver 4.1.13-standard I'm trying to get replication from an older server running version

Re: Oddity with data pointer size

Hello. Looks like it is a bug. See: http://bugs.mysql.com/bug.php?id=7883 Duncan Hill [EMAIL PROTECTED] wrote: I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as we're starting to encounter quite a few tables that are larger than 4 GB. However, the create

Re: MySQL install problems on OSX 10.4

Hello. /opt/local/var/Mattys-iMac-G5.err: Operation not permitted Check the permissions on /opt/local/var directory. Have a look here as well: http://dev.mysql.com/doc/mysql/en/starting-server.html Matt Scales [EMAIL PROTECTED] wrote: I've just installed MySQL 4 4.1.12_1 +server

Re: stop loading when error

Hello. Maybe STRICT_ALL_TABLES sql mode is that you want? See: http://dev.mysql.com/doc/mysql/en/server-sql-mode.html Use 'SHOW WARNINGS' to find out the problems. See: http://dev.mysql.com/doc/mysql/en/show-warnings.html Example: mysql set @@sql_mode='STRICT_ALL_TABLES'; Query

Re: How to save graphs in a table?

Hello. This is a frequently asked question. Search in Google and in the archives at: http://lists.mysql.com/mysql Pay attention to the mysql_real_escape and LOAD_FILE. See: http://dev.mysql.com/doc/mysql/en/mysql-real-escape-string.html

Re: Which License of MySQL Should We Buy?

Hello. The complete answer could only be obtained from [EMAIL PROTECTED] Shaghayegh Sahebie [EMAIL PROTECTED] wrote: [-- text/plain, encoding 8bit, charset: iso-8859-1, 15 lines --] hi, I'm working in a company which wants to have a client/server application on MySQL DBMS.

Re: default my.cnf vs huge.cnf nearly same performance with

Hello. huge.cnf example. What about that thread_concurrency setting in huge.cnf.. it doesn't seem to show up in a 'show variables' when using it.. is it deprecated? In the manual it is meant that thead_concurrency is used on Solaris. In the source files I've seen that

Re: default my.cnf vs huge.cnf nearly same performance with

- Original Message - From: Gleb Paharenko [EMAIL PROTECTED] Hello. huge.cnf example. What about that thread_concurrency setting in huge.cnf.. it doesn't seem to show up in a 'show variables' when using it.. is it deprecated? In the manual it is meant that thead_concurrency is used

searching through a mysql db/tbl

hi... i'm trying to figure out how to approach/solve a few issues. looking through google hasn't made the light shine!! 1) i'm trying to figure out how to allow a user to search through a query/tbl for a given string. ie, if i have the following as the result of a query: name email

Re: searching through a mysql db/tbl

bruce wrote: 1) i'm trying to figure out how to allow a user to search through a query/tbl for a given string. ie, if i have the following as the result of a query: Why wouldn't you simply create the query that would produce only the rows you want (where name = '%aa%' OR email = '%aa%'

dynamic value like excel

i want to put a value in a column that is the date of today . IS there a solution to do that in sql way ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: dynamic value like excel

this may help you test create table d ( - date date ); Query OK, 0 rows affected (0.45 sec) test insert into d values(now()); Query OK, 1 row affected (0.12 sec) test select * from d; ++ | date | ++ | 2005-09-10 | ++ 1 row in set (0.00 sec) On

MySQLHotCopy Error

We're having a problem with MySQLHotCopy. It has worked flawlessly in the past but now we're getting an error message similar to this: Dumping database... DBD::mysql::db do failed: Can't find file: './file.frm' (errno: 24) at /usr/local/mysql/bin/mysqlhotcopy line 468. Deleting