947740 Posted July 14, 2008 Share Posted July 14, 2008 Does anyone have a simple explanation for how to create a stored procedure that will back up a database? Link to comment https://forums.phpfreaks.com/topic/114673-stored-procedure-backing-up-a-database/ Share on other sites More sharing options...
fenway Posted July 14, 2008 Share Posted July 14, 2008 Does anyone have a simple explanation for how to create a stored procedure that will back up a database? Back up how/where? Link to comment https://forums.phpfreaks.com/topic/114673-stored-procedure-backing-up-a-database/#findComment-589769 Share on other sites More sharing options...
947740 Posted July 15, 2008 Author Share Posted July 15, 2008 Make a backup copy of the entire database. I know the code to back up a database, I just need to know how to make a stored procedure. Link to comment https://forums.phpfreaks.com/topic/114673-stored-procedure-backing-up-a-database/#findComment-590742 Share on other sites More sharing options...
fenway Posted July 15, 2008 Share Posted July 15, 2008 There are some excellent dev articles on the mysql site on SPs... not sure if you can use SELECT INTO OUTFILE in one, though, and INSERT INTO...SELECT WHERE is bound to be slow. Link to comment https://forums.phpfreaks.com/topic/114673-stored-procedure-backing-up-a-database/#findComment-590835 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.