using php to export from one db to another?

[optikalefx]

I need to write a cron job that will sync 2 databases.

Is there a quick way to write an export from one database for import into another?

Or do i manually have to write the select statements per table, format them as insert ignore strings, then execute them on the other database?

 

Thanks guys!

[trq]

You wouldn't use php for this. Simply execute the commands directly from your crontab.

 

Export:

 

mysqldump -uYOURUSERNAME -pYOURPASS DBNAME > dump.sql

 

Import:

 

mysql -uYOURUSERNAME -pYOURPASSWORD DBNAME < dump.sql