mysql and php, copy data from one database to another

[sneeuwvlok]

hi everyone

I'm trying to find out how you can copy data from one mysql database to another,
I can't do it manually because it needs run automatic every day. Does anyone know how to do it, and how i can run it automatic at a specific time?

Thanks for your help

[godwheel]

You can do it with a CRON job (assuming you are using Linux)

http://www.unixgeeks.org/security/newbie/unix/cron-1.html

Check out that link for more info on CRON jobs.