Page 1 of 1

INSERT/ APPEND on a database. HOW? - Desperate for HELP

Posted: Tue Feb 28, 2006 1:11 am
by victhour
actually these is more likely backuping my database... for my Small CMS :wink: intend to our school campus("for News and Update").

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.Table
now, my confusion is how would i insert/ append another batch of data from "Database.Table" to "newDatabase.newTable"?
with 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...