gnawz Posted November 12, 2008 Share Posted November 12, 2008 Hi, I need a script that I can put in my admin panel to back up/restore, export/import a MySQL database. Something to use online, instead of PHPMyAdmin Somebody please help. Quote Link to comment https://forums.phpfreaks.com/topic/132418-php-mysql-database-export/ Share on other sites More sharing options...
Mchl Posted November 12, 2008 Share Posted November 12, 2008 Do you have access to mysqldump on your host? Quote Link to comment https://forums.phpfreaks.com/topic/132418-php-mysql-database-export/#findComment-688436 Share on other sites More sharing options...
gnawz Posted November 12, 2008 Author Share Posted November 12, 2008 Yes I do... Quote Link to comment https://forums.phpfreaks.com/topic/132418-php-mysql-database-export/#findComment-688451 Share on other sites More sharing options...
Mchl Posted November 12, 2008 Share Posted November 12, 2008 So you can use execution operator to execute mysqldump in shell and then download resulting file. Quote Link to comment https://forums.phpfreaks.com/topic/132418-php-mysql-database-export/#findComment-688453 Share on other sites More sharing options...
gnawz Posted November 12, 2008 Author Share Posted November 12, 2008 I need to do something like have a button or link that a user clicks then it opens a browse window for the user to select where to save the backup copy of the database... Quote Link to comment https://forums.phpfreaks.com/topic/132418-php-mysql-database-export/#findComment-688574 Share on other sites More sharing options...
premiso Posted November 12, 2008 Share Posted November 12, 2008 I would check online http://www.phpclasses.org/browse/package/1931.html I found that class that someone created, you should be able to get that to suit your needs. I know it only does it by table, but a loop of arrays of all your tables can solve that problem. There seems to be a bunch of other scripts online, most do not prompt to download, but that can be done by reading up on it. Hope that at least gets you started to find/resolve your problem. Quote Link to comment https://forums.phpfreaks.com/topic/132418-php-mysql-database-export/#findComment-688587 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.