Please allow me to broaden this thread to include backup for mySQL users who have accounts with ISPs.
In my case I have mySQL access on a Web server where I have NO access to the server-level options. What is my best option of making a backup of the database and tables that I use? Also, what is my best option if I want to move this database and its tables from one ISP to another? Thanks for the help. --- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On Mon, Mar 04, 2002 at 10:05:50AM +0530, Chetan Lavti wrote: > > > > I am using MySQL 3.23.47 and InnoDB table type on Linux7.1 > platform. > > Now,for this database backup and recovery procedures are given as > : > > > > 1. Taking 'binary' backup of the database. > > 2. Using the mysqldump utility > > > > In the first method we do the following things : > > > > · Shut down your MySQL database and make sure it shuts down > > without errors. > > · Copy all your data files into a safe place. > > · Copy all your InnoDB log files to a safe place. > > · Copy your `my.cnf' configuration file(s) to a safe place. > > · Copy all the `.frm' files for your InnoDB tables into a safe > > place > > Yes, in fact, it looks like you grabbed that right out of the > InnoDB > docs. :-) > > > And the second method is just a utility which is to run without > > shutting down the server.(with the disadvantage of slower speed > of > > the Backup and recovery) > > > > Am I right ?? > > Yes. > > > Actually I am new to this field and I want that this is to be > done > > through the Web. How should I do that.?? > > What does "through the web" mean? You want to initiate the backups > via a web page? You want to be able download the backup files that > way? Something else? > > Tell us what you're trying to do and we'll try to help. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 24 days, processed 812,615,871 queries > (382/sec. avg) > > --------------------------------------------------------------------- > 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 > __________________________________________________ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com --------------------------------------------------------------------- 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
