Dump from big table in MySQL

2003-02-12 Thread Grover Cussi N.
Hello!! when I do mysqldump of a big table, the process is killed, and it is not posible make the dump. I read in the list of somebody who did a dump of database with 4G size. Which variable it is necessary to modify for making a dump using mysqldump, or it is necessary to move a better

Big table and Mysql

2002-06-03 Thread bewel bewel
Hi all, I would like to ask if is possible create and use this table size with MySQL. So, I have 15 columns in 1 row and it contain 100B of data. I have in plane insert cca 30 000 000 rows per year - 3 GB/year * 4 years = 12 GB of data (120 000 000 rows and 1 800 000 000 ). HW configuration is: