Jump to content


Photo

Duplicate DB (Master-Slave)


  • Please log in to reply
3 replies to this topic

#1 vaibhavs

vaibhavs
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 08 October 2006 - 05:55 PM

Hi,

I am sure this question must have been asked a number of times, but I could not locate a suitable solution. I believe I am unable to find the exact query string for search :(

I have 2 Shared hosting accounts with 2 different hosting companies (Linux-MySQL-CPanel).
I wish to duplicate a DB (all tables) from Server-1 to Server-2 (Incremental mode to save on b/w).
Since it is a Shared Hosting, I have limited access rights (no Shell).

Is this possible? Please suggest some solution.

Thank you all.

With kind regards,
Vai

#2 printf

printf
  • Staff Alumni
  • Advanced Member
  • 889 posts

Posted 08 October 2006 - 06:33 PM

Sorry without direct access to the db server configuration, you can't do it!

me!

#3 vaibhavs

vaibhavs
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 09 October 2006 - 12:00 AM

Any other solution?
MysqlDump >> FTP >> Import data etc?
Thx
Vai

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 October 2006 - 05:53 AM

Any other solution?
MysqlDump >> FTP >> Import data etc?
Thx
Vai

Yup... if you can get the data off the first box, you're home free.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users