radiations3 Posted July 19, 2011 Share Posted July 19, 2011 Can we create a backup of database entered data in PHPMYADMIN? As you know if we are using locally any database through php then in case of system crash or the like our all the enterred saved data in the database will gonna be lost i want to know that is it possible to create a back up for our saved data in the database and if is it possible then how can we do it???? Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/ Share on other sites More sharing options...
Psycho Posted July 19, 2011 Share Posted July 19, 2011 Launch PHPMyAdmin, select the database, select the "Export" tab. Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244452 Share on other sites More sharing options...
cunoodle2 Posted July 19, 2011 Share Posted July 19, 2011 I was trying to get something like this that would automatically email out the backup but I could never get it to work. You can see my post on that item here.. http://www.phpfreaks.com/forums/index.php?topic=338431 Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244455 Share on other sites More sharing options...
radiations3 Posted July 19, 2011 Author Share Posted July 19, 2011 well i know about this exporting thing but its drawback is its manual and i want it to be done auotmatically How can we do that like exported files gets saved in our specified folder Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244457 Share on other sites More sharing options...
TeNDoLLA Posted July 19, 2011 Share Posted July 19, 2011 http://tinyurl.com/2aayujp Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244459 Share on other sites More sharing options...
Psycho Posted July 19, 2011 Share Posted July 19, 2011 well i know about this exporting thing but its drawback is its manual and i want it to be done auotmatically How can we do that No where in your original request did you mention anything about an automated process. You simply asked whether a backup could be made. You waste your time and ours when you don't ask for what you really want. For an automated solution you can either do a scheduled task (windows) or a cron job (Linux) to run a backup script at a specified time interval Or, if you coded your project in such a way that all the database scripts are in a consolidated location you could even build something into all those processes to do the backup based upon what data is being created/changed. Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244464 Share on other sites More sharing options...
radiations3 Posted July 19, 2011 Author Share Posted July 19, 2011 With all due repect when we talk about back up its really obvious that automated function is required. who on earth does manual back ups lolxx... Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244470 Share on other sites More sharing options...
Psycho Posted July 19, 2011 Share Posted July 19, 2011 Manual backups are just as commonplace as automated ones. They both have their purposes in the software industry. Before deploying a new build to the production environment a manual backup is generated in case the deployment goes south and the environment needs to be restored to its original state. A manual backup could also be run right before an import or migration is done. If you relied only on automated backups you would either lose all the data that changed since the last automated backup and the process you wanted to protect yourself against or you would have to lock all users out of the application until the next automated backup occurred. As my sig atates The quality of the responses received is directly proportional to the quality of the question asked. If you ask an imprecise question, you will get an imprecise response. Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244475 Share on other sites More sharing options...
radiations3 Posted July 19, 2011 Author Share Posted July 19, 2011 ok Got that!! thanx alot for helping me out Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1244498 Share on other sites More sharing options...
radiations3 Posted December 5, 2011 Author Share Posted December 5, 2011 Solved it by cron jobs!!! Solution is in attached files 17145_.zip Quote Link to comment https://forums.phpfreaks.com/topic/242303-backup-of-database-php-mysql-help-required/#findComment-1294713 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.