Lets do this: mysqldump -u user -p [database_name] [tablename] > ./thefilewhatyouwouldliketocreate.dmp Check that file.
VAso -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:25 PM To: [EMAIL PROTECTED] Subject: How can I dump and empty a table? Dear list: I apologize post this question, but I`m newbie with MySQL. I have a database called "tacacs", it has many tables and one of them is called "accounting". This table has many data stored since 2 month ago and it is very big and it increases frequently everyday. I`d like to know how can I dump (backup) the data from this table and left it empty periodically, because I have to do some queries from a Web UI? I`ll be very greateful if someone could give me some suggestions with this issue? Thank you, EDWIN LIMACHI N. DATACOM - Instalaciones Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975