Hi i have created a website for my client using PHP and mysql . The client need to backup a table in database as excel file every day. Well he had no idea about coding and all ... He need to backup using a simple way. Please anyone let me know how can i do it using php script or any easy software for that.....

Please help me

9 Years
Discussion Span
Last Post by verruckt24

This is karthi from chennai . u need excel format table report , U write a program poi or mysql cronjob coding .. otherwise u have table
go to mysql gui tool and select browser select table and execute and then choose file --> export --> which format ui wand excel , pdf, html click it ...


Instead of taking the lengthy route of a backup through a script, you could just as well use the 'SELECT...INTO OUTFILE' query to backup the data to a CSV file. You could put this command into a file and then use the crontab to run this daily. This would be much easier than writing a script.


Well he had no idea about coding and all ... He need to backup using a simple way.

Never tell to such clients to use MySQL GUI, most of the time they destroy things :-)


@karthik1983 : Read what the OP wants and try to understand it before posting stuff and

9894153527 call me if u any doubt

avoid this nonsense, if you have something to share, share it with all. It's just one of those forum's rules that you agreed to while registering as a member here.


You can simply go to export option and there you can save data in required file format

Read the previous posts, a poster has already been adviced about this. And tell me how is he going to do this activity on a daily basis ?
Open the GUI program daily and do it ?

The previous poster was making the same mistake. Think for a while before posting stuff like this.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.