Hi there, Im working on a site that has really slow mysql so I want to set up a cron job to just update my local Mysql database once a day from a remote mysql database. The problem is, my local database has different table names then the remote database. Is there a way to make a script that dumps the remote database then allows me to assign which table and column I would like to insert the data into? All the replication scripts I have found require that each table,column be named exactly the same.

Thanks in advance

Why don't you just change the table names so that they match in both databases. Otherwise you can just write a PHP or PERL script to read the mysqldump file and insert into the backup table.

mySQL-replikation does not work with different table-names, because each query on the master is done on the slave.

Your source file is a .sql file right? Just edit the file to change the names - you may have to create a PHP script to edit the file for you if you want to add some automation to this process.

Replication is on the master all transactions are written to a log file which is sent to a file on the slave. The slave then processes those transactions. It normally is done quickly so if the master has a failure, you have all the information on a slave.

Using MySQL native replication, the table names will be the same. If you use a commercial product such as Golden Gate replication, you can have different table names on the master and slave.