MySQL 3.23.33 mysqldump of mysql database has syntax errors in table creation

2002-04-25 Thread Tony . Wells
>Description: When dumping the 'mysql' database, the dump file contains syntax errors, and I can't find where this has been rectified in later releases. Example dump using 'mysqldump -cl mysql': [snip]# # Table structure for table 'db' # CREATE TABLE db ( Host char(60) NOT NULL default '',

Re: Installing PHP with MySQL

2001-10-04 Thread Tony Wells
"Ralf R. Kotowski" wrote: > > I did install all RPM's exept the benchmark. What is the name of the > header files? > > On 3 Oct 2001, at 14:20, Carl Troein wrote: > > > > > Ralf R. Kotowski writes: > > > > > I got Red Hat 6.2 and the Mysql 3.23.36-1 RPM packages installed, > > > when I try to c

Re: PHP/MySQL question - need help with fputs, mysql statements

2001-10-01 Thread Tony Wells
Dave Lake wrote: > > Hi Folks > > I have used MySQL for some time and am just getting my head around PHP. I > looked across a number of PHP sites for some input on this but failing to > find an answer thought I would ask some MySQL users (surely many of you are > using PHP right? ;-) ) for help.

Re: Host 'ip adddress'' is not allowed to connect to this MySQL server

2001-09-24 Thread Tony Wells
Harpreet wrote: > > I am trying to use MYSQL CLIENT for the first time. I have setup the mysql > server and connect to it from my machine using Telnet. > But everytime i try to connect using mysql client or through access 2000 i > get the following error: > > Host 'ip address' is not allowed to

Re: mysql_connect () and mysql_pconnect are not recognized ! Pls help.

2001-08-31 Thread Tony Wells
It sounds like the PHP module was compiled without MySQL support. root wrote: > > Hi, > > I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from > an RPM. > My problem is whenever I try to call mysql_connect (), from a php3 > script, I got the error function not found or misco

A couple of questions about connections

2001-08-21 Thread Tony Wells
base, use mysqladmin flush-hosts ...' or something to that effect. (It's been awhile since it's happened.) Flushing the hosts solves the problem but I was wanting to do garbage collection on these connections to p