On Tue, Aug 16, 2005 at 09:10:35AM +0530, Anil_Appala wrote: > Can u give me the commands for backup using mysqldump,how can I restore > the db?
Depends on a lot of factors, like what username to use and what host, but, mysqldump -u myusername -p myjffnmsdb > myjffnmsdb.sql should dump it, depening on your username, database name. It will prompt for a password. then to restore mysql myjffnmsdb < myjffnmsdb.sql The mysqldump manual page is pretty good, or section 21.2 of the mysql manual. - Craig -- Craig Small GnuPG:1C1B D893 1418 2AF4 45EE 95CB C76C E5AC 12CA DFA5 Eye-Net Consulting http://www.enc.com.au/ MIEE Debian developer csmall at : enc.com.au ieee.org debian.org ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
