-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Sorry Heikki....Can you give me a few steps to obtain that...?
Thanks a lot.
Alvaro Avello.
Heikki Tuuri wrote:
|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----- |> |> | | | -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Netscape - http://enigmail.mozdev.org
iD8DBQE/FGZMR9NZaw5tbc0RAn6lAJ0filp6siUs+TBk7N2CP8Il6mgHvwCfV20j YBIWR33O86CMczdhleqvZKs= =iQu1 -----END PGP SIGNATURE-----
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]