On 10/02/11 4:33 PM, JAGANADH G wrote:
> Is it possible to quary and fetch data in one mysql db and store it in a
> second one .
If you can write a script in PHP/Perl/Python/Ruby or any other
language of your choice, you can open two database connections
- one to the source host and one to the destination host:
1. Execute the query 'SHOW CREATE TABLE `employee_details`'
on the source host to get the table structure.
2. Execute the resultset column (which should be a valid
CREATE TABLE statement) as a query on destination host.
3. Now fetch rows from the table on the source host and
insert the result-set as rows in the destination host.
Hope this helps.
Cheers,
Chandrashekar.
--
http://www.chandrashekar.info/
http://www.slashprog.com/
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
