...

View Full Version : saving Database to file



jeromepelletier
09-03-2006, 06:48 PM
How would you go abouts saving all data in the mysql to a file and download it? I know how to retreive the data and write it (dont know how to make a download button) but how do i record the table data, such as make them inserts like you would in phpmyadmin. Then with a click of the button in mysqlsave.php, it retrieves the information, saves it to mysqlDATA.doc and then downloads it to your hard drive?

googleit
09-03-2006, 07:21 PM
edit// sorry miss read the question

guelphdad
09-10-2006, 02:54 PM
you would have to write your mysqlsave php file as one that calls a script. that script would run a mysqldump call. you would have to write a separate script for the reload.

jeromepelletier
09-13-2006, 11:59 AM
you would have to write your mysqlsave php file as one that calls a script. that script would run a mysqldump call. you would have to write a separate script for the reload.

mysqldump as in a command or me calling every row

guelphdad
09-13-2006, 03:15 PM
mysqldump is a command you can run from the command prompt or shell. you can run it in a script with a cron job.

mysqldump dumps your entire database with all tables and inserts for all rows of every table. you can also specify with options that you only want certain tables from the database, or the table structure only without data etc.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum