Jump to content

Archived

This topic is now archived and is closed to further replies.

radar

Backup Database

Recommended Posts

Okay so working on my administration panel right now..  Server I am on doesnt have phpmyadmin so I can't export all my stuff that way so I need to come up with a way to back up my entire database through php on my site..

Any clue how to do this?

Share this post


Link to post
Share on other sites

[quote="mysql manual section 4.5.1"]
You can also do selective backups with SELECT * INTO OUTFILE 'file_name' FROM tbl_name and restore with LOAD DATA INFILE 'file_name' REPLACE ... To avoid duplicate records, you need a PRIMARY KEY or a UNIQUE key in the table. The REPLACE keyword causes old records to be replaced with new ones when a new record duplicates an old record on a unique key value.[/quote]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.