Re: importing large dump

2002-08-30 Thread David Phillips
f the dump file and see if that solves the problem. -- David Phillips <[EMAIL PROTECTED]> http://david.acz.org/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Set up help needed

2002-02-13 Thread David Phillips
If you want to get the most out of MySQL, then you really need to learn to use the command line tools. MySQL has the easiest to use tools and language of any database I've used. SQL allows you to do really powerful things easily. Download the Windows version and install it. You can use the mys

Re: Errors that i can't see find in the help system on mysql

2002-02-12 Thread David Phillips
You probably either need to increase the ulimit on file descriptors for that process, or increase the total number of file descriptors for the kernel. > 020206 15:11:47 mysqld started > /usr/pkg/libexec/mysqld: ready for connections > 020207 1:02:00 Error in accept: Too many open files

Re: Errors that i can't see find in the help system on mysql

2002-02-07 Thread David Phillips
You probably either need to increase the ulimit on file descriptors for that process, or increase the total number of file descriptors for the kernel. > 020206 15:11:47 mysqld started > /usr/pkg/libexec/mysqld: ready for connections > 020207 1:02:00 Error in accept: Too many open files

Re: load data local ... security issue

2002-02-06 Thread David Phillips
But you could already read any file that the web server can read, if you can execute scripts which are run as the webserver. Only way to prevent that is suEXEC. How is this specific to MySQL? > 1) Webserver must be able to read HTML files of every WebUsers > 2) MySQL functions are called with u

Re: Set up help needed

2002-02-05 Thread David Phillips
If you want to get the most out of MySQL, then you really need to learn to use the command line tools. MySQL has the easiest to use tools and language of any database I've used. SQL allows you to do really powerful things easily. Download the Windows version and install it. You can use the mys

Re: PHP and pconnect

2002-02-05 Thread David Phillips
> - use of mysql_pconnect (introduced in Novemeber) > - use of fsockopen($Primary, 3306, &$errno,&$errstr,5) (closed by > fclose()) to test if connection possible before attempting connection > (introduced last week) > - much high web activity causing recycling of httpd processes You're putting m

Re: How to index Optimization on 20 million record

2002-02-04 Thread David Phillips
> PRIMARY KEY (`FIELD_1`), > KEY `FIELD_1` (`FIELD_1`), You don't need a second key on the column, as it is a duplicate of the primary key. > but, i do query sintax, just simple select count(*) from TABLE_1 where > FIELD_1 = "XXX_CC"; > But i got the result very long timemore 10 mi

Jailed MySQL for hosting customers

2002-02-03 Thread David Phillips
ng on it for the 3.23 branch? I would really like to have this feature, but I don't know the direction to take with this. Thanks, -- David Phillips <[EMAIL PROTECTED]> http://david.acz.org/ - Before posting, pleas