Dump from big table in MySQL

2003-02-12 Thread Grover Cussi N.
machine?? I have a machine with 1.7 G, 256 MB, using Red Hat. Grover Cussi N www.cs.umss.edu.bo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Problems with INNODB in MySQL 4.0.6-gamma

2003-02-04 Thread Grover Cussi N.
Hello! I have a problem with the innodb files, Well I have a database with a big table with more than 3 milon of register, beside I have other databases that haz different size. My innodb file grow up to 1 G, I make a sql sentence, delete from from big_table, and the size of the innodb

Re: Innodb: Limited creation of tables

2003-02-04 Thread Grover Cussi N.
On Tue, 4 Feb 2003, Shomal Bafna wrote: The box is running a MySQL 3.23-47 Max rpm based version on a Mandrake 8.2 Linux with Duron processor and 256MB Ram. Thera are 10 InnoDb type tables created and several MyISAM types too (approx 30 more.). On adding the 11 table of InnoDb type the

Problems with INNODB table

2003-02-01 Thread Grover Cussi N.
Hello!! I have various databases, one with a table with more than 3 millions of registers, and other has 250 MB, 50MB. My ibdata1 grow to more than 1 G, well I do not want my big database, I drop the database but the size of the ibdata continues with the same size, what can I do?? I waant my