I have written a mysql statement as below:
Code:
mysqldump –h localhost –u root –password=password –t --tz-utc=false database table2, table3, table4 –w"WhenCreated > LastSynchedDateTime” > filelocation/filename
All of a sudden it is fetching...
pkul3003
Last Activity: Dec 9 '11, 06:15 PM
Joined: Nov 8 '11
Location:
-
Mysqldump extracts unwanted tables
Hi Experts,
I have written a mysql statement as below:
This statement used to fetch correct rows as from table2, table3 & table4 per the where caluse.
All of a sudden it is fetching... -
Yes I am doing same.. Creating database connection variable for each database server and trying to use these connections in a query..
It is not allowing to use two database server connections in single query.. -
Hi Dormilich,
Can you please suggest how to do this in one script? If not single query, is this possible with more queries?
As written above we have a requirement to connect multiple databases & many tables in each database from one host server and transmit data to different server tables. In this process we want to pass database names & table names dynamically.
Any suggestions or pointers to achieve...Leave a comment:
-
hi Altugo,
I actually liked your solution.. but its not exactly working out in my case...
Like you, I am also connecting to 2 mySQL databaes on 2 different servers..but in my Query, I need to Select from one database and insert into another using the below SQL
REPLACE INTO db1.table1 SELECT * FROM db2.table2 WHERE table2.WhenCrea ted > table2.LastSync hedTimeStamp ;
but when I am running my PHP, its...Leave a comment:
No activity results to display
Leave a comment: