radar Posted September 3, 2006 Share Posted September 3, 2006 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? Quote Link to comment Share on other sites More sharing options...
Barand Posted September 3, 2006 Share Posted September 3, 2006 [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] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.