-1

I have my MYSQL server running in my google instance. My server have vesta control panel where I'm currently managing servers.. I would like to migrate my database to Amazon RDS. How I can do it through google instance SSH.

Some of info that may help for answer:

I already created database instance in RDS where I allowed all IP to access (for now)

If you know way to do it through Mysql workspace , please share .

Dhilip
  • 1
  • 2
  • Possible duplicate of [Saving MySQL databases without mysqldump](http://serverfault.com/questions/384100/saving-mysql-databases-without-mysqldump) – user9517 Oct 25 '15 at 18:04
  • Also take a look at this Servr Fault search which has plenty of other seful information. https://www.google.co.uk/search?q=site%3Aserverfault.com+%2Fvar%2Flib%2Fmysql&oq=site%3Aserverfault.com+%2Fvar%2Flib%2Fmysql&aqs=chrome..69i57j69i58.16203j0j1&sourceid=chrome&es_sm=122&ie=UTF-8#q=site:serverfault.com+copy+%2Fvar%2Flib%2Fmysql – user9517 Oct 25 '15 at 18:05

1 Answers1

3

Working with RDS is no different than any other MySQL instance.

Run mysqldump to back up your database, transfer that file to a host that has access to your RDS instance, and then load that dump into RDS as you would normally do.

EEAA
  • 109,363
  • 18
  • 175
  • 245
  • True, except that RDS is a bit trickier, lacking the `SUPER` privilege. http://serverfault.com/questions/555953/first-attempt-to-migrate-ec2-mysql-to-amazon-rds-no-going-well-super-privilege – Michael - sqlbot Oct 25 '15 at 18:07
  • Could you please explain as steps , where I can run on google ssh (not on workspace) – Dhilip Oct 26 '15 at 11:07
  • There are many tutorials online that walk you through this. We don't give out tutorials on Server Fault. – EEAA Oct 26 '15 at 12:14