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

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

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 this

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 -p test

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

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

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 parameter so

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]

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

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: 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, are the

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

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 \

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: 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

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

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