MySQL Forums
Forum List  »  MyISAM

Re: System Table definitions for MyISAM
Posted by: Jan Theodore Galkowski
Date: April 20, 2005 08:19AM

Thanks Ulf!

INFORMATION_SCHEMA is the kind of thing I was looking for. I don't think it's worth it to switch a table to MaxDB 5+ solely to get it, though. I do look forward to MySQL 5 being more widely supported by the hosting services.

>I don't get what you're trying to do.

What I was working on was a smarter Restore capability for a companion custom database Backup. This is a Backup which the client can run themselves and end up with a .gz to save. A lot of hosting services restrict what PHP scripts can do in terms of running shell, including mysqldump. In this case, I was working on doing a Restore to an occupied database from an earlier Backup and trying to work out integrating the saved results with data in the existing tables.

The basic idea was while restoring to create scratchpad tables which had new and old values for keys and arrange the Backup so it saves tables in a dependency order. Then, in theory, you could load the least dependent first, populating the scratchpad tables, and then the more dependent by refering to the scratchpad tables.

My question about interrogating whether a table had an AUTO_INCREMENT or not and, in general, about things like INFORMATION_SCHEMA was to know more about MySQL so I could build smarter tools for managing it using PHP and SQL itself. In this case, knowing whether a table had AUTO_INCREMENT or not indicated if it had fields which needed to be coordinated through the scratchpads.

Thanks again.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: System Table definitions for MyISAM
2600
April 20, 2005 08:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.