MySQL table export and import
Posted on 2009-02-19
I have a large table 'term' in MySQL 5.0 Db in database 'prod'. Access to Db is password protected. I want to be able to export this table from my Win XP PC, copy to my flash drive, insert the flash drive in another Fedora Linux PC. Then run the script, so that the exactly same table data gets imported in the MySQL 5.0 Db on the Linux PC in the same 'prod' database. It should also take care that if the table already exists in Linux PC, insert the new rows that are not already on the Linux PC. This operation would be done on regular basis.
Please provide the script (both versions - one that need to run on Win XP, and another that need to run on Linux) that would achieve above task.
Suppose I also have a remote Linux server to which I can log in as root from my Linux local PC. On this server I also have MySQL 5.0 Db running. Please provide the script
that needs to run to import the table into the remote server in 'prod' Db.