i'd like to copy a table contents from one database to another database like the statement below. given all connection are working.
Code: Select all
INSERT INTO newDatabase.newTable SELECT * FROM Database.Tablewith accurate and quick process. coz i think the above SQL statement is a bit sloppy and slow. though im not sure with that theory
any other tips or technique aside from mysqldump and mysqlhotcopy for backuping are also appreciated.
tanx in advanced...