Hi Vaso:
I tried with your suggestion, it works fine. I have the backup now. I have two questions:
How can I erase the actual data from my table? and How can I restore them from my backup file?
Thank you and best regards,
EDWIN
"Vasoczki Ferenc"
<[EMAIL PROTECTED]>
09/12/2003 12:28 |
|
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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]