MySQL Forums
Forum List  »  Other Migration

AIX 5.3 Filesize Problems
Posted by: Tom Melly
Date: February 12, 2012 10:17PM

Hi,

Hope this is the right forum for this...

I'm trying to restore a large db onto an AIX 5.3 server (mysqldump from WinXP).

This is failing during the restore due to an O/S file size issue on the target server.

One option is to break the dumped database into smaller chunks, and restore each chunk one at a time. However, this won't really help me if I still run into file size issues for the target DB (the current file size issue LOOKS like it relates to temporary files).

So, my question is - does mysql adapt to file-size limits? i.e. will it break table-files down into acceptable sizes or will it hit this issue irrespective of how I handle the restore?

I should add that at this point I am unsure whether the file-size limit is due to user-set limits or O/S physical limits (AIX 5.3 iirc has to have large file size support configured when the file-system is created).

Many thanks for any advice or observations anyone can offer...

Options: ReplyQuote


Subject
Views
Written By
Posted
AIX 5.3 Filesize Problems
3478
February 12, 2012 10:17PM


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.