I have a MYSQL DB hosted on a Win 2003 server on my LAN
and a Mysql DB on a dedicated (linux) server at our ISP.
I would like to dump a few tables to a .sql file and ftp it to the server and then import the .sql file automatically via a cron job.
I can do the FTP etc. But I am unable to get the exporting and importing to work, not sure why.
I would really appreciate some assistance