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? Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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. 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.