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:[EMAIL PROTECTED]]
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 [EMAIL PROTECTED]
>==================================
>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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
