A Few Basic Questions

Please pardon the list of newbie questions. Programming is a bit foreign to me.

Preface: I have a local MySQL database.

1) Is there a (hopefully easy) way to transfer that on a daily basis to a hosted MySQL database?

2) Is it possible, instead, to transfer that local MySQL data to a hosted SQL database on a daily basis?

3) When generating MS Excel files (not just a .csv) as part of a web application, do you have to have Windows hosting? Do you need a special kind of hosting account or special version of Excel? Can you create a .xls file from an apache server?

Thanks!

 

1.) yes you can by using cronjob
2.) yes it is possible to do that. What you need to do is to setup cronjob in your localhost, and then make a connection to your server
3.) Im not very sure, but I beleive no, you dont need to use window hosting to output .csv! But you will need windows hosting when you want to draw graphics for excel

 

http://www.google.com/search?q=php+to+excel

 

Thanks David and Dave.