Jump to content


Photo

transferring data from one mysql database to another


  • Please log in to reply
1 reply to this topic

#1 san2san

san2san
  • Members
  • Pip
  • Newbie
  • 3 posts
  • LocationIndia

Posted 10 November 2003 - 02:09 PM

How do I transfer particular records (say 10 records out of 100) which are updated in one database(say DB1, or DB2) to another one(say DBMain).

The DBMain database contains data from DB1, DB2 and DB3. The rest of the data should not affected.

I tried phpMyAdmin, but it does not solve my problems.
Any project can be done in timely and in less.

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 10 November 2003 - 05:59 PM

insert into DBMAIN select * from DB1 where....
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users