this is like backuping database. how do i duplicate/ copy a database? a scenario is like this, I’d like to copy my database to another database before its Truncated (“Empty”). I use this statement
“INSERT INTO newDatabase.newTable SELECT * FROM Database.Table”
to move those data into another database(“newDatabase”). Another problem is I cant insert/ append another batch of data with the same statement I use to insert on newDatabase. Why?
hope received some feed'backs from you pepz
tanx in advanced...
cheerz!
Last edited by khaki_monster on Fri Mar 17, 2006 4:46 am, edited 1 time in total.
Here is a sample of the query generated by phpMyAdmin when it copies a database. You may want to look into installing that and using it to copy your database as that would be easier if you are able to.
“INSERT INTO newDatabase.newTable SELECT * FROM Database.Table”
how do you guyz duplicate a database and with each time appended/updated by new records?
i've been looking over google for some help... but no good results.
im gett'in prostrated already, more tips please...
NO... My CMS is running with two database, database1 is where all temporary records are to be stored. records are being "cached" then move those temporary records to database2("as an archieve/backup") witch can updated anytime...
cron job is not a problem. i just use cron job for dumping my database server with mysqldump utility every month...