Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL DB Backup

Status
Not open for further replies.

chrigil

Programmer
Joined
Sep 23, 2003
Messages
178
Location
GB
I need to backup a MySQL database remotely via a link in a web page.
I am unable to have any sort of access to the command line and cannot therefore use mysqldump nor can I schedule it using Cron or any other such tool leaving me with the option of a remote backup as described above using a button or a link in a webpage.

My question is wha is the best way of doing it? Is the only practical way going to involve a mass select etc or is the a better way using PERL or something similar?

TIA, Chris.
 
use the mysqldump command
mysqldump

___________________________________________________________________

onpnt.com
SELECT * FROM programmers WHERE clue > 0
(0 row(s) affected) -->faq333-3811

 
You can only use this command from the command prompt or via a 3rd party piece of software such as MySQL Control Centre.

I'm trying to find a way of doing it so that when a site administrator clicks a button the database is backed up. For this reason it has to be done without access to the command prompt or a 3rd party application.


Thanks anyway,

Chris
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top