RE: How can I dump and empty a table?

2003-12-09 Thread Vasoczki Ferenc 
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

RE: How can I dump and empty a table?

2003-12-09 Thread elimachi 

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




Para
[EMAIL PROTECTED]


cc



Asunto
RE: How can I dump and empty
a table?








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]