needs_upgrade Posted March 15, 2010 Share Posted March 15, 2010 Hi guys... Im just wondering how can i make remote database back-up. For example, upon logging out of a user, a .sql or .txt file will be saved in his/her workstation. Ofcourse, the user will be asked where the file will be saved. Please help me where to start. Thanks so much in advance. Quote Link to comment https://forums.phpfreaks.com/topic/195307-remote-database-backup/ Share on other sites More sharing options...
o3d Posted March 24, 2010 Share Posted March 24, 2010 You could use this in php's shell exec function in the logout process: mysqldump db-name > filename.dump Remember the login, password, etc parameters. Quote Link to comment https://forums.phpfreaks.com/topic/195307-remote-database-backup/#findComment-1031310 Share on other sites More sharing options...
needs_upgrade Posted April 9, 2010 Author Share Posted April 9, 2010 thanks o3d. Quote Link to comment https://forums.phpfreaks.com/topic/195307-remote-database-backup/#findComment-1039368 Share on other sites More sharing options...
ignace Posted April 9, 2010 Share Posted April 9, 2010 The suggested will save the dump file to the location in which mysqldump was called. You will need to set the correct headers and readfile to display the file as a download. Quote Link to comment https://forums.phpfreaks.com/topic/195307-remote-database-backup/#findComment-1039404 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.