shaddf Posted March 18, 2016 Share Posted March 18, 2016 how can I get the code of a function to a text file in mysql?how can i dump database with the stored functions too? Quote Link to comment https://forums.phpfreaks.com/topic/301039-how-to-dump-functions-in-mysql/ Share on other sites More sharing options...
requinix Posted March 18, 2016 Share Posted March 18, 2016 You can do SHOW CREATE for pretty much anything in the database. Like SHOW CREATE FUNCTION whateverfunction. It'll return a string with SQL. To dump the database I assume you're using mysqldump? Try its -R/--routines option. Quote Link to comment https://forums.phpfreaks.com/topic/301039-how-to-dump-functions-in-mysql/#findComment-1532189 Share on other sites More sharing options...
Jacques1 Posted March 18, 2016 Share Posted March 18, 2016 --routines Quote Link to comment https://forums.phpfreaks.com/topic/301039-how-to-dump-functions-in-mysql/#findComment-1532190 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.