Download Database
Moderator: General Moderators
-
SidewinderX
- Forum Contributor
- Posts: 407
- Joined: Fri Jul 16, 2004 9:04 pm
- Location: NY
Download Database
I'm working on the backend of a small CMS I created, and I want to give the user the ability to click a "Download" button and allow the database's SQL file to be downloaded. I was wondering how I go about creating the sql file from the database.
Do you have access to the command line? If so, mysqldump is easy to use. http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
If you have a control panel like phpMysqlAdmin, you should be able to create a text file with the Dump data in it, then that's what you have your users download.
Is it critical that the dump contain all the latest data? If so, you may need to find a way to dump it dynamically, in real time.
If you have a control panel like phpMysqlAdmin, you should be able to create a text file with the Dump data in it, then that's what you have your users download.
Is it critical that the dump contain all the latest data? If so, you may need to find a way to dump it dynamically, in real time.
-
SidewinderX
- Forum Contributor
- Posts: 407
- Joined: Fri Jul 16, 2004 9:04 pm
- Location: NY