I currently have a few tables stored on a local database on a Linux server that I’d like to append to a table stored on DreamHost’s database automatically every night. Is there a script out there that can help me accomplish this goal?
Maybe someone with more DBA experience can clarify, but wouldn’t a dump of the table from home, then a mysql < dumpfile append the data? That’s assuming the tables have the same name.
If that’s all true, then you’d have to run a cronjob on your home Linux machine to do the dump, then import. You can add your home’s IP address to the DB User in the Panel under Manage MySQL so you can access the DB from home.