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? Link to comment https://forums.phpfreaks.com/topic/19556-backup-database/ 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] Link to comment https://forums.phpfreaks.com/topic/19556-backup-database/#findComment-85069 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.