Re: Converting password to old format.

AFAIK, PASSWORD() or OLD_PASSWORD() is one way function, it means in math if you do f(x) = y, you never know x, all you now is the result of f(x) ~ y Moreover, do you have a problem with new password format? Eugene Kosov wrote: Hi, everyone! I have transfer user's database and grants

Re: Converting password to old format.

Yes I know restoring plain password from it's hash is impossible (at least in theory ;)) but I don't need password itself. I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we possibly can get such f(x) that will make expression f2(x) = f(f1(x)) truth for every x. I haven't

Re: Converting password to old format.

Sorry, I have no idea about that :) Eugene Kosov wrote: Yes I know restoring plain password from it's hash is impossible (at least in theory ;)) but I don't need password itself. I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we possibly can get such f(x) that will make

Re: mysqld_safe and timezone settings

or what I although could do to start my Server in another than the SYSTEM timezone? I use the MySQL 5.0.18 Server on a Suse Linux 10.0 From: http://dev.mysql.com/doc/refman/5.0/en/timezone-problems.html You can set the time zone for the server with the --timezone=timezone_name option to

Information schema for pages ?

All, I've searched the help and even found this very useful link http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html regarding all the Information schemas. What I can find is information regarding some way to retrieve the number of pages used to store an index. Perhaps this is because

Foreign keys

Hello everybody. I'm using php 4.4 and mysql 5.0 and i'm having the bellow issue: I've a group table and a system table, bellow this i have a group_system table that has a foreign key to group table and to system table. When a tried to delete one register in the group_system table, it gives me

How to take dump of a query instead of table / database

Dear Friends, I need to take the backup of a query, is it possible. If yes how. -- Regards Abhishek jain www.smsengine.co.uk

Re: How to take dump of a query instead of table / database

I need to take the backup of a query, is it possible. If yes how. man mysqldump: -w|--where= dump only selected records; QUOTES mandatory! Regards, Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to take dump of a query instead of table / database

you can manipulate mysqldump using the where clause (check the man) You might find the following usefull, but would not be so good for restoring. from the command line mysql --database=db_name --execute=select * from users -u username -ppassword output.file Pure Web Solution

Is there anyway to return an array?

This is not a typically thing that anyone would expect Mysql to do, however with the application I am writing it would be helpful. Here goes: The application stores raw data from a satellite, along with a configuration of how to read the data. So of the data types are Int Arrays and Float

Re: Foreign keys

I had that problem as well and a quick search revealed this: A) Whole databases are not handled by InnoDB. The individual tables are. Check the results of SHOW CREATE TABLE table_name_here for each table you are linking from and linking to. You should see ENGINE = InnoDB after the last ) but

Stored procedures and views

Howdy folks, I'm trying to create a flatfile dump from our database which requires some functionality that's not possible with raw sql. Up to now we've been using PHP tied to mySql to do all the work and get the data in the correct format. We would like to switch this functionality over to

Re: Stored procedures and views

Chriss, I'm trying to create a flatfile dump from our database which requires some functionality that's not possible with raw sql. Up to now we've been using PHP tied to mySql to do all the work and get the data in the correct format. We would like to switch this functionality over to stored

InnDB disabbled on 5.1.7

We are running 2.6.15-gentoo Linux and downloaded the max binaries for 5.1.7. With the following my.cnf I thought we should have InnoDB. All of the InnoDB files got created but show variables like 'have%'; displays have_innodb DISABLED. Exactly the same my.cnf {except the skip bdb is not

RE: Stored procedures and views

I just mean is it possible to hook a set of stored procedures to a view as opposed to a temporary table that we'd have to explicitly update? Chris -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 10:26 AM To: mysql@lists.mysql.com Subject:

4.1 x 5.0 INSERT Performance issues

Hi, My software use to run with mySQL 4.1, but now i have to use some of the new features of mySQL 5.0 i did dump all databases, uninistalled mysql4.1, installed the mysql5.0 and start loading the .sql file. This operation use to take about 4 hours but know it is taking 1day!!! Did anything

Re: Stored procedures and views

I just mean is it possible to hook a set of stored procedures to a view as opposed to a temporary table that we'd have to explicitly update? hook? If you mean: using the views in select statements inside a procedure: sure it. Did you try? Martijn Tonies Database Workbench - development tool

RE: Stored procedures and views

If the features available in stored procedures {i.e. looping etc.} are required, have you tried having the procedure 1st write/edit the data in a temporary table and at the end select the values you want from that table. I think I might write 2 procedures. One that does the data manipulation

/var/log/mysql.000001 Not Found?

I just tried upgrading from MySQL 4.0 to 5.0 on my Slackware Linux system, but whenever I try to start the new service it immediately exits and the only error it logs is: /usr/libexec/mysqld: File '/var/log/mysql.01' not found (Errcode: 13) [ERROR] Could not use /var/log/mysql for loggins

Host denied errors

Little confused, can not seem to locate the docs on this. Trying to set up mysql to allow a remote webserver to talk to it, using a user/pass/host setting with host set to allow anything, of course works. If the IP I am connecting from has a valid PTR, I can use the hostname as well, and that

Comparing x.x.x.x strings

Hi all. I have a problem: When I compare two strings in mask (x.x.x.x) the comparation is not true (for my question :D)... look: select '3.2.0.13' '3.2.0.2'- FALSE I want this command return TRUE, but it is returning FALSE. But, if I put a space first into the smaller string the

Re: Comparing x.x.x.x strings

I don't know the answer to your question but I know that this issue has been discussed in this mailing list before. Look in the MySQL archives and I'm sure you will find an answer on the best way to compare IP addresses. -- Rhino - Original Message - From: Lucas Vendramin [EMAIL

RE: Host denied errors

IP should work just fine. However, if the source webserver is behind a firewall or otherwise NAT'd, your mysql server may see them coming from an in between IP instead of the actual webserver. The quickest way to figure it out is to have the webserver host try to connect and send you the error

Re: Comparing x.x.x.x strings

Take a look at the MySQL function INET_ATON and it's counterpart (I don't remember what it's counterpart is but it should be easy to find once you find INET_ATON). I know in PHP there is a function that will convert x.x.x.x to an int and then you just put that int into a field in your database

Re: Comparing x.x.x.x strings

In the last episode (Mar 24), Lucas Vendramin said: Hi all. I have a problem: When I compare two strings in mask (x.x.x.x) the comparation is not true (for my question :D)... look: select '3.2.0.13' '3.2.0.2'- FALSE I want this command return TRUE, but it is returning FALSE.

Re: Is there anyway to return an array?

David Godsey [EMAIL PROTECTED] wrote on 03/24/2006 12:55:29 PM: This is not a typically thing that anyone would expect Mysql to do, however with the application I am writing it would be helpful. Here goes: The application stores raw data from a satellite, along with a configuration of how

problem with encoding utf8 in text field

Hi all. In my apps I use two languages: english and my national polish. Translates i keep in MySQL 5.0 in text field (MyISAM engine) with utf8 encodings. I don't know why but i can get polish translates from databes properly, my national character are seen from webb like sign ?. I connect to

DBD::mysql::st execute failed: MySQL server has gone away

Hi. I'm getting the following error running apache2 with modperl, mysql 4.1.18 and RT 3.4.5 *error:* DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/stow/perl-5.8.7/lib/site_perl/5.8.7/Apache/Session/Lock/MySQL.pm line 70. *context:* *...* *66:* if

Re: Comparing x.x.x.x strings

When I compare two strings in mask (x.x.x.x) the comparation is not true (for my question :D)... look: select '3.2.0.13' '3.2.0.2'- FALSE I want this command return TRUE, but it is returning FALSE. select inet_aton('3.2.0.13') inet_aton('3.2.0.2');