Re: mysql dump help!

2007-07-24 Thread Red Hope
I cut and pasted what you typed and just altered the password. It didn't like it all. Same error again. If I put any command in without the ; at the end then I'll get locked into this - thingy unless I clear out. I can't guess why it won't take it. Lillian --- Ananda Kumar [EMAIL PROTECTED]

Re: mysql dump help!

2007-07-24 Thread Red Hope
I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian --- Carlos Proal [EMAIL PROTECTED] wrote: Yep, good for you, welcome to the real world You are changing the prompt but

Re: mysql dump help!

2007-07-24 Thread Ananda Kumar
did u try this mysqldump -u root -ppassword --database test test.sql On 7/24/07, Red Hope [EMAIL PROTECTED] wrote: I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian

innodb to be removed? and...

2007-07-24 Thread Christian Parpart
Hi all, recently someone said to know alot about mysql told us that InnoDB is about to be removed from the mySQL server. however, InnoDB seems to be the fastest storage engine in our case, as myisam take a hell longer to insert new rows e.g. so is it true, that innodb is to be removed?

Extract String only from varchar Field?

2007-07-24 Thread Lars Schwarz
hi all, i'm looking for a function to extract the string part of a varchar field only. like when you stored an street address in one field like foobar street 23 and i want everything except the numeric value of it. is it possible without a regexp? if not, anyone has a regexp for that purpose

Extract String only from varchar Field?

2007-07-24 Thread Lars Schwarz
hi all, i'm looking for a function to extract the string part of a varchar field only. like when you stored an street address in one field like foobar street 23 and i want everything except the numeric value of it. is it possible without a regexp? if not, anyone has a regexp for that purpose

Re: innodb to be removed? and...

2007-07-24 Thread Gary Josack
Christian Parpart wrote: Hi all, recently someone said to know alot about mysql told us that InnoDB is about to be removed from the mySQL server. however, InnoDB seems to be the fastest storage engine in our case, as myisam take a hell longer to insert new rows e.g. so is it true, that

Re: mysql dump help!

2007-07-24 Thread Gary Josack
Red Hope wrote: I'm curious about one thing. When I go into MySQL folder on the hard drive. I go into the 'bin' folder, should there be an .exe program called mysqldump? or not? Lillian --- Carlos Proal [EMAIL PROTECTED] wrote: Yep, good for you, welcome to the real world You are

RE: mysql dump help!

2007-07-24 Thread Benjamin Wiechman
Not to ask a perhaps silly question, but are you specifically trying to use mysqldump, or just get a backup copy of your databases? If you just want to back them up download MySQL Administrator - GUI = fun easy... :) http://dev.mysql.com/downloads/ (Download MySQL GUI Tools - about half way

Re: innodb to be removed? and...

2007-07-24 Thread B. Keith Murphy
Even if it is removed it would only be removed from future versions .. say 6.0. Even version 5.1 has been feature-frozen, if I am not mistaken, meaning that features will not be added or removed. But, as others have said, Falcon is what I think MySQL has in mind to replace Innodb This

Re: mysql dump help!

2007-07-24 Thread Red Hope
I did have some luck, y'all after several hours. Originally there wasn't a mysqldump.exe in the bin folder so I redid everything. I went through regular ole ms-dos and was able to run it through fine. I just needed it to get converted to a .sql file so I can upload it to my web server. I

Re: innodb to be removed? and...

2007-07-24 Thread Jim Winstead
On Tue, Jul 24, 2007 at 11:48:38AM +0200, Christian Parpart wrote: so is it true, that innodb is to be removed? No, not in the forseeable future. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: mysql dump help!

2007-07-24 Thread Ofer Inbar
On 7/24/07, Red Hope [EMAIL PROTECTED] wrote: mysql mysql \R shell PROMPT set to 'shell' shell It doesn't matter what the prompt says, it's still mysql you're running here. When people say the shell prompt they don't mean make your prompt say the word shell, they mean the prompt when

Re: innodb to be removed? and...

2007-07-24 Thread Les Schaffer
Jim Winstead wrote: No, not in the forseeable future. if you are going to use that kind of Orwellian newspeak, then expect the followup question to be, how far into the future does MySQL see? do you have a number in mind, like 1 year, 3 years, 3 months, 3 days? Les Schaffer -- MySQL General

mysqlcamp II

2007-07-24 Thread John Mancuso
Has any info been posted yet on mysqlcamp II in Brooklyn NY at Polytechnic University? I've looked all over mysqlcamp.org but haven't found any schedules, speakers, topics.. etc yet. I figured that 1 month away there would be some kind of buzz/discussion. I apologize ahead of time if this is on

Re: innodb to be removed? and...

2007-07-24 Thread Jim Winstead
On Tue, Jul 24, 2007 at 11:17:11AM -0400, Les Schaffer wrote: Jim Winstead wrote: No, not in the forseeable future. if you are going to use that kind of Orwellian newspeak, then expect the followup question to be, how far into the future does MySQL see? do you have a number in mind, like 1

Re: innodb to be removed? and...

2007-07-24 Thread mos
At 10:48 AM 7/24/2007, Jim Winstead wrote: On Tue, Jul 24, 2007 at 11:17:11AM -0400, Les Schaffer wrote: Jim Winstead wrote: No, not in the forseeable future. if you are going to use that kind of Orwellian newspeak, then expect the followup question to be, how far into the future does

Re: innodb to be removed? and...

2007-07-24 Thread Jim Winstead
On Tue, Jul 24, 2007 at 02:49:55PM -0500, mos wrote: Since you're here, maybe you can answer a question for me. Will Falcon eventually replace InnoDb? Or do you have another engine in mind? There is no effort underway to replace InnoDB. Last I heard, Oracle intends to keep developing

Table corruption: Incorrect key file for table

2007-07-24 Thread Mark Dalton
I am getting table corruption on one machine that I was testing a change to get better performance. This is using the C API to connect to the database. With the delete without the sort by id, I started getting the database key corruption. There were about 2.6 million rows matched to be

Re: Table corruption: Incorrect key file for table

2007-07-24 Thread Mark Dalton
I just changed back to the 'order by id LIMIT 5000' and I have not seen further corruption. I also wanted to mention the other details about the system: The system is running Linux 2.6.16.21-0.8-smp (SLES10) mysql-5.0.18-20.5 And I do grant that we probably need to change the key cache.

Multiple connections not happenning

2007-07-24 Thread Jean-Sebastien Pilon
Hello, I run a PHP/MySQL environment. This may be more of a PHP question, but I'll take my chance here. I have 3 different servers: - 1 running apache2 + php4 - 1 running mysql 5.0 - 1 running mysql 4.1 On the web server, I run multiple php applications which all connect to the MySQL

Re: su-like functionality

2007-07-24 Thread Pete Harlan
On Tue, Jul 24, 2007 at 02:18:21AM +0200, Mogens Melander wrote: On Mon, July 23, 2007 10:19, Carlo Sogono wrote: Is there a way for mysql to login as an administrator and su to a normal user? What I'd like to achieve is a way to log in to our clients' accounts (we are a web-hosting

MySQL migration from 4.0.27 to 5.0.37

2007-07-24 Thread Michael Lueck
Greetings List- I have heard that there are details to be worked out when backing up from MySQL 4.0.x and restoring to MySQL 5.0.x, specifically in the area of special characters. I know that at least one of my databases has special characters. Does anyone know the syntax and what commands I

RE: su-like functionality

2007-07-24 Thread Stein, Olaf
In that case you either need the users password or create a user with the same permissions and try with that user Olaf -Original Message- From: Pete Harlan [mailto:[EMAIL PROTECTED] Sent: Tue 7/24/2007 7:30 PM To: Mogens Melander Cc: Carlo Sogono; mysql@lists.mysql.com Subject: Re: