Backup MySql database to localhost through PHP

[coder_learner]

I have a MySql database of about 3000 records with a hosting company. The mySql database has a php front-end support that uses forms to grab values.
And I need some ideas,comments,support etc. on the following 2 questions.

1. If I want to backup that database every month to a local(in my office) computer that has Linux OS with apache and MySql, how about I go and do that?
My office uses a router with a static IP address.

2. If I want to backup about 100 selected records out of that 3000 records from the hosting server to my local mySql database, how would I do that?

I want to use PHP to do these backup.
Thanks for your time.

[nemonoman]

What you're asking to do is tough: PUSHING records from the SERVER to your PC.

Much, much easier to PULL records FROM your server to your PC

If you are running PHP on your PC, you could just use PHPmyadmin freeware or something like it.

If you REALLY want to PUSH to your PC, you can set up PHP to exec(mysqldump...)

and then push the records to your PC via PHP FTP commands. Your PC will need to be set up to accept FTP, however.