Commands to export MySQL database schema, database with data, selective tables, ignoring tables
I have already listed the PHP script to generate backup of database in one of my earlier post. I am listing here the PHP script to restore database from mysql database file.
I am listing here the PHP script to generate backup of database. For saving the file with ‘sql’ extension replace the code as specified below at specified line numbers in the above code (Although ‘zip’ file will take less space). You can also set cron jobs for dumping databdase in the cpanel of your site. […]