RE: [PHP-DB] How do I backup my MySQL database? asks a Newbie.

I run different mySQL servers and frequently use them to back up the others (i.e. I'll use ServerTwo to hold a backup of ServerOne's data in case ServerOne goes down), so I wrote a few functions to help copying databases between servers for backups, and to manage databases and tables on single servers, as well. That might help you. It's all in a single function library I called dbUtils. Just open up the file in a text editor, define as many servers as you want, and run the function you need. You can get it by going to http://www.hotscripts.com/Detailed/10533.html - Jonathan -----Original Message----- From: Andre P. [mailto:drowser@zoom.co.uk] Sent: Thursday, June 21, 2001 8:07 AM To: Dan Eskildsen Cc: Subject: Re: [PHP-DB] How do I backup my MySQL database? asks a Newbie. Install phpMyAdmin and this will give you a web interface to manage your DB. You can do a dump of your database using it. Andre Dan Eskildsen wrote: >*************** >NEWBIE ALERT! >*************** > >I am only new at this, but I have discovered one thing: I love php and >mysql! > >I now have a couple of tables of information in a MySQL database. The site >is run by my ISP so I don't have control of the server. > >My question is: how do I via php/mysql make a backup of the entire database >so that I can restore it again should the worst happen and the server goes >down? > >I would really appreciate your comments on this! > >Dan > > >================================== >Regards from Denmark, Europe >Please cc your reply to dan@eskildsen.net >================================== >I haven't lost my mind, I've got it backed up on TAPE somewhere....... > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net