Ahmed, > 1. How can i trigger a database archive when a certain data base limit > is reached in a table. > Ex: when 1,00,000 records is reached, archive to file and clean table.
You will have to wait for MySQL 5.0. This version will have SQL triggers. > 2. How can i restore multiple files into database ? I am not sure if I get you right. If you mean how to restore backups, it's easy with MySQL: 1. Make the backups using mysqldump, e.g. mysqldump --all-databases > backupfile 2. Restore what's in "backupfile": mysql < backupfile Have a look at http://www.mysql.com/doc/en/mysqldump.html for details. Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Ahmed S K Anis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 2:00 PM Subject: Archive and retrieval in MySQL > HI, > I have a few questions related to DB archving / restore capability of > MySQL. Most of them are design issues but have a lot to do with what > MySQL provides. > PLease share your view on them. > > 1. How can i trigger a database archive when a certain data base limit > is reached in a table. > Ex: when 1,00,000 records is reached, archive to file and clean table. > > 2. How can i restore multiple files into database ? > > 3.When i try to view data through my application, how can i trigger > the restore the data from Archive file on demand ? > > Regards > Anis > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
