[saggi_sam]

thnks…a ton….ritesh/shadow…

it has worked…..

http://dev.mysql.com/doc/mysql/en/Blocked_host.html

was great and 'flush hosts' has done the job.

But i would like to know that is there any difference between

'mysqladmin flush-host'

and

'flush hosts'

commands. These two commands were written in the above given link. i have used 'flush hosts'

[saggi_sam]

no what i meant was that what if even database is not existing….i.e. i am making a new local machine which will have replica of remote database. So then how do i go??

[saggi_sam]

this is fine, ritesh.

one more doubt. What if i don't have database structure existing on my local machine, and i want to bring entire copy of remote mysql database to the local server. How to achieve that?? So i want entire copy of database to bring down from remote to the local. Once this entire database copy is avilable at local machine then i can apply the data sync tool of SQLyog.

Pls. guide for the above.

thanx in anticipation

[Author]

Posts