hi,
We can take backup for the subject above by two ways, One way is by
mysqldump ( Which I am using ..)
Now, I the second method
1. Shut down your MySQL database and make sure it shuts
down without errors.
2. Copy all your data files into a safe place.
3. Copy all your InnoDB log files to a safe place.
4. Copy your `my.cnf' configuration file(s) to a safe
place.
5. Copy all the `.frm' files for your InnoDB tables into
a safe place.
How to know which are the data files and InnoDB log files, can we
distinguish these file simply by name. I mean to say that if I want to
list out log file and data files one time at a time!! can I do it simply
by name !! ( I know the path for this specified in the my.cnf file )
Which is the procedure of backup in which I don't need to shutdown the
MySQL Server.
Thanks and regards,
Chetan Lavti
---------------------------------------------------------------------
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
