Jump to content

Copy tables between databases automatically and regularly?


seany

Recommended Posts

Hey everyone, it's my first time posting here but I've been a lurker for a while. Anyway, I couldn't find the answer to my problem after searching so I decided to register and ask myself.

 

What I'm trying to do is copy a table from one database to another database on the same server (same user/pass as well), with one condition. table.row needs to be < 5 in order for it to be copied to the other database.

 

This operation (without the condition) can be done through the Operations tab in phpMyAdmin, but what I want to do is execute this operation every 2 minutes (for example) automatically.

 

How can I do this? Thanks for the help!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.