Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

Organizational Research By

Surprising Reserch Topic

how to copy a table from one mysql database to another mysql database using -'php,sql,mysql,linux,shell'


how to copy a table from one mysql database to another mysql database  using -'php,sql,mysql,linux,shell'

I need to copy a table from one database to another. This will be a cronjob. Which one is the best way to do it? PHP script or Shell Script. The problem with PHP, both databases has different usernames and passwords so I can't do it like this.

CREATE TABLE db1.table1 SELECT * FROM db2.table1


Should I just connect first DB get all records and insert all to new database using WHILE loop or there is a better way?

I prefer a shell script to do this instead of PHP script.

Thanks
    

asked Sep 7, 2015 by rajesh
0 votes
13 views



Related Hot Questions



Government Jobs Opening


...