Compiling MySQL with SSL support

2003-11-23 Thread Adam Gent
Hi, I am attempting to install mySQL with SSL support but keep getting build errors. I have openSSL 0.9.7c install into /usr/local/ssl I am attempting to install mySQL 4.0.16 I am using the following configure options CFLAGS="-O3 -mcpu=pentiumpro -I/usr/local/ssl/include" CXX=gcc CXXFLAGS="-O3

Re: running sql-bench scripts redhat 8.0

2003-11-23 Thread Paul DuBois
At 9:13 -0500 11/23/03, Jason Steig wrote: I'am having trouble running all the scripts in sql-bench. It seems to be an issue with the location of my perl install. I tried to change the perl location at the start of the script to the location of my perl install /usr/bin but that didn't fix the

Re: How to reduce the size of IBDATA?

2003-11-23 Thread Paul DuBois
At 20:16 -0600 11/23/03, mos wrote: I have an IBDATA1 file that has grown to 2gb even though all Innodb tables have been either converted to MyISAM or dropped. (There are no InnoDb tables left) My question is how to I decrease the size of the IBData file? I tried shutting down the MySQL server

How to reduce the size of IBDATA?

2003-11-23 Thread mos
I have an IBDATA1 file that has grown to 2gb even though all Innodb tables have been either converted to MyISAM or dropped. (There are no InnoDb tables left) My question is how to I decrease the size of the IBData file? I tried shutting down the MySQL server and deleting the IBDATA1 file, then

Re: MySQL 4.0.16 on SCO OpenServer 5.0.6

2003-11-23 Thread Stephen Brownlow
Hello Stefaan, We have around 80 servers running MySQL 4.0.15 on SCO OpenServer 5.0.5 through 5.0.7. Here is my make: CC=gcc CFLAGS="-O3 -mpentium" LDFLAGS=-static CXX=gcc \ CXXFLAGS="-O3 -mpentium -felide-constructors" \ ./configure --prefix=/usr/local/mysql \ --enable-thread-safe-cl

Fw: Make a User Variable and assign a value Dinamicaly

2003-11-23 Thread Julio E. Salceda M.
Please I am very new in MySql and I am making tests to learn the best way to do the job. In this time I need to know how can create a User Variable whith a Dinamic name and assign a value to it. below put more or less what I need. Soy muy nuevo en MySql y estoy haciendo pruebas para aprender la m

Re: RedHat 9, MySQL RPM 4.0.16-0 and UDF...

2003-11-23 Thread Jason Pyeron
rpm -i MySQL-Max.rpm solved it On Sun, 23 Nov 2003, Jason Pyeron wrote: > Our old lcs.MYSQL.so from MySQL 3.23 give the same garbage out. > This has worked on many RedHat 7.3 / MySQL 3.23.xx boxes. > > On Sun, 23 Nov 2003, Jason Pyeron wrote: > > > > > I have never seen an error like this one,

running sql-bench scripts redhat 8.0

2003-11-23 Thread Jason Steig
I'am having trouble running all the scripts in sql-bench. It seems to be an issue with the location of my perl install. I tried to change the perl location at the start of the script to the location of my perl install /usr/bin but that didn't fix the issue. has anyone else had this issue? --

RE: restoring mysqldump ???

2003-11-23 Thread B. van Ouwerkerk
Hit the right button on the wrong moment... It should be: Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline in the form of -p'your_password' :( > -Oorspronkelijk bericht- > Van: B. van Ouwerkerk [mailto:[EMAIL

RE: restoring mysqldump ???

2003-11-23 Thread B. van Ouwerkerk
mysql -u user_name -p reporter < dumpfile Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline -p'your_password' but -u user_name B. > -Oorspronkelijk bericht- > Van: Mikael Fridh [mailto:[EMAIL PROTECTED] > Ver

Re: restoring mysqldump ???

2003-11-23 Thread Mikael Fridh
> but when i try to run : > % mysql -u root reporter < reporter-dump-Sat.sql mysql -uroot -p reporter < dumpfile > it says : > ERROR 1044: Access denied for user: '@localhost' to > database 'reporter'. think it's because of that extra space between the '-u' and 'root' you also need the -p parame

Re: restoring mysqldump ???

2003-11-23 Thread Nilesh Avalani
alright guys, here is the mistake i was making - sorry i'm a total fresher... i need to be in the same directory where the test-dump-Sat.sql file is located. so i simply copied the dump file to the root from where i was executing my commands and it was working. However now i need it to be restore

Re: restoring mysqldump ???

2003-11-23 Thread Nilesh Avalani
Hi Mikael, I've tried that but it says : test-dump-Sat.sql: No such file or directory. tell me something... when i type in this command where should my "test-dump-Sat.sql" file be located? as of now i've placed it in the test folder under mysql-2.23.58/var... is this right? or should it be somewh

Re: restoring mysqldump ???

2003-11-23 Thread Mikael Fridh
> i have a backup copy created using mysqldump called > "test-dump-Sat.sql". > i need to restore it into the "test" database on my > remote Solaris server. > after getting into mysql i gave command: > use test; > mysql test < test-dump-Sat.sql; try the same command from shell. shell> mysql -uUser

Re: FTP and MySQL

2003-11-23 Thread Joakim Ryden
Quoting Nate <[EMAIL PROTECTED]>: [...] > It would save me a great deal of time and effort if there were FTP software > that could read users from a mysql table. Is there anything like this out > there? There are several FTP servers with this capability; the two I most often hear mentioned in thi

FTP and MySQL

2003-11-23 Thread Nate
Hello, I'm curious if anyone knows of any FTP server software that can communicate with MySQL. For example, my client wants to be able to give his customers FTP access (each would need their own login/password) and allow them to upload images to their own directory. He also wants bandwidth and disk

Re: Errors with MySQL

2003-11-23 Thread Rob Snow
When I meant I deleted all the obvious files I meant I went to the mysql folder and deleted the folder, plus the mySQL sock file in temp/ I then ran ps from the prompt which stated there was a process running. What I really want to know is that are there files located anywhere else that are part