Hello, I have a base that weighs 29 GygaBytes and I want to know if there is a software like ACL, SQL, in which you can load a base of that size, I have the file in DBF or some way to split the base
Hello, I have a base that weighs 29 GygaBytes and I want to know if there is a software like ACL, SQL, in which you can load a base of that size, I have the file in DBF or some way to split the base
Actually 29 GB is nothing for any modern Databases handler. The limitations could come more easily from the operating system or server where the tables will be hosted. The MySQL Doc says that a MyISAM table can have a size of up to 256TB ... and even more, if you indicate it in CREATE TABLE , so 29GB ... that's nothing .
For example, MySQL says the following in its Documentation :
C.10.3 Limits on the size of the table
The maximum effective table size for MySQL databases is usually determined by operating system restrictions on the size of the files, not the internal limits of MySQL . For up-to-date information about operating system file size limits, see the documentation specific to your operating system.
Windows users, bear in mind that FAT and VFAT (FAT32) are not considered suitable for use in production with MySQL. Use NTFS instead.
If you find a complete table error, there are several reasons why this might have happened:
The disk may be full.
You are using InnoDB tables and you have run out of space in an InnoDB table space file. The maximum size of the table space is also the maximum size of a table. For the size limits of the table space, see the Section 15.8.8, "Limits of the InnoDB tables ".
Generally, we recommend the partitioning of tables in several table files for tables larger than 1 TB .
You have reached an operating system file size limit. For example, you are using MyISAM tables in an operating system that supports files up to 2 GB in size and has reached this limit for the data file or the index file.
You are using a MyISAM table and the space required for the table exceeds what is allowed by the size of the internal pointer. MyISAM allows data and index files to grow up to 256TB by default, but this limit can be changed to the maximum allowed size of 65,536TB (2567 - 1 bytes) .
If you need a MyISAM table that is larger than the default limit and your operating system supports large files, the CREATE TABLE statement supports the AVG_ROW_LENGTH and MAX_ROWS options. See Section 14.1.18, "Syntax of CREATE TABLE " . The server uses these options to determine the size that it should allow in a table.
This tutorial could be of help: Import DBF files to MySQL