Hi Sergey, Thanks for the quick response.
Destination side clear now. Coming to Source side what is the command to take the backup of all database and tables. please paste the command here. And also before taking dump need to take any precautions. Regards, Venkatesh.k On Sat, Feb 4, 2017 at 10:42 AM, Sergey Levitskiy < [email protected]> wrote: > Easiest way to first create cloud user at the destination server and then > import the backup > > GRANT ALL ON cloud.* to cloud@`localhost` identified by 'complex_password > '; > GRANT ALL ON cloud.* to cloud@`%` identified by 'complex_password'; > GRANT ALL ON cloud_usage.* to cloud@`localhost`; > GRANT ALL ON cloud_usage.* to cloud@`%`; > GRANT process ON *.* TO cloud@`localhost`; > GRANT process ON *.* TO cloud@`%`; > FLUSH PRIVILEGES; > > > > >
