Why should there be a problem restoring?
Mark Hennessy wrote:
>I'm using DBI/DBD with Perl 5.6.1 to send queries to this database.
>I'm a relative newbie to DB design, I have done some basic administration
>for clients. I ask:
>1) In the database I plan on migrating, I have a few simple tables which
>use "select _seq" to increment the index value for each table as insert
>queries are done. I looked at AUTO_INCREMENT in MySQL and couldn't see
>how one would restore from backup (backups made by mysqldump) the last
>AUTO_INCREMENT value for a table. I am thinking of using:
>select MAX('tablename_index')+1 from tablename
>instead of mucking around with AUTO_INCREMENT. I plan on making an
>insert query with the resulting value in the same session in DBI. Is it
>likely that I need to worry about locking the table for this process?
>I don't want to even think about backfilling, so MAX+1 seems fine for what
>If I understand correctly, as the field is designated as an index, MAX for
>it is a stored value and thus is selected very quickly.
>2) Are there any known problems in 3.23.51 stable that would muck with
>something as simple as described above?
> Mark P. Hennessy mark@stripped