Brian Hanna wrote:
> No, that's not quite it. Yes, auto_increment is limited by the field
> size, but even with a bigint(20), max_rows is still stuck at 4294967295.
> Even on tables in a 64-bit mysql installation.
>
> This has something to do with mysql's myisam default data row pointer
> size myisam_data_pointer_size, I think [1].
>
> To correct this, I'd have to increase the data pointer size, restart the
> database, and dump and reload the table?
From what I've found, no, you should be able to modify the existing table in
place
http://wiki.bacula.org/doku.php?id=faq#why_does_mysql_say_my_file_table_is_full
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|