Re: mysqldump question

[Benjamin Pflugmann <benjamin-mysql@xxxxxxxxxxxx>]

Hi.

On Mon, Nov 26, 2001 at 05:39:57PM +0300, dannis@xxxxxxxxxxxxxxxxxxxx wrote:
[...]
> diff database_dump/Mtable.txt `mysqldump <appropriate options>
> --databases MYdatabase --tables MYtable`
> ...
> and make a conclusions depending of diff output.
> 
> But according to well known SQL standarts the order of stored records is undefined. However, using MySQL I note that the order of records output is the same as order of records input in the table and it isn't violates while queries like "SELECT * FROM table" are performed.
> 
> The question is: may I be sure I'll get absolutely identical dump result
> for unchanged table with mysqldump used at different times ?

No. For MyISAM tables, it will change on DELETE/UPDATES. For other
table types I don't know. Aside from that, you should not rely it
anyhow, because this is a implementation detail and it may change
without notice according to the SQL specification.

Regarding mysqldump, have a look at an earlier post from me:

http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:10037:lcmmfflncinfjoipdpmc

Bye,

	Benjamin.

-- 
benjamin-mysql@xxxxxxxxxxxx

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92429@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php