Alvaro, ----- Original Message ----- From: "Alvaro Avello" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 1:13 AM Subject: Re: innodb file won't shrink
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > There 's any chance that in the future every InnoDB table files from a > determinated database can be placed in the same directory of the mysql ( > MyISAM ) database ? . My point is that if you want to take a binary > backup of all databases in the mysql directory and you want to restore > just one of the databases , you could just copy the directory to the > correct place and thats all you have to do to restore a single > database...... I guess I'm getting tired to wait for the dump to > re-create all the indexes and stuff like that. it will not be straightforward. The undo logs used to purge old versions of rows and roll back uncommitted transaction will not be placed to those table files. But if you let the database to be silent and run purge to completion, then you will get clean tables you can restore later individually to the database. > Thanks In advance > > Saludos / Regards , > > Alvaro Avello. Regards, Heikki > walt wrote: > > |Heikki Tuuri wrote: > | > | > |>On September 15th, 2003 you will be able to put every InnoDB table > into its > |>own file. That should alleviate this kind of problem. > |> > |> > |>Best regards, > |> > |>Heikki Tuuri > |>Innobase Oy > |>http://www.innodb.com > |>Transactions, foreign keys, and a hot backup tool for MySQL > |>Order MySQL technical support from https://order.mysql.com/ > | > | > |That is great news! Will a single table be able to span several > |datafiles? > | > |Thanks! > |walt > | > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org > > iD8DBQE/EysJR9NZaw5tbc0RAnMHAJ4/ZxbE5sRwAjW8cDAcXOr6cbsiowCeJU14 > y/QT2dFY16n6L/OcJ0vCHyw= > =PCGI > -----END PGP SIGNATURE----- > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
