moving large db from dedicated to vps

Discussion in 'MySQL' started by exclink, Aug 21, 2012.

0
  1. #1
    Hello i run 4 forum abt 3-6GB db each i start them in 2008

    i have a dedicated with 256 GB SSD for mysql and 2TB for storage ram 12GB i was using innodb

    now after google update i lose 90% of my traffic

    so for that i dont see a reason why should i continue using this dedicated that cost me 350$ per month i am moving to a vps

    i did buy a vps with 50GB SSD and 200GB space

    i wanna move my database to vps

    should i use innodb ? or MyISAM ?

    also i dont know how to move db to the ssd any one can explain
     
    exclink, Aug 21, 2012 IP
  2. afstanislav

    afstanislav Greenhorn

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    1
    Trophy Points:
    16
    #2
    Fow MySQL backup and import i use sypex dumper, great php script which can backup more that 1.5 GB tables and works great.

    I don't really understand why you need change DB engine on new server?? Your forums used Some types of tables (MyIsam, InnoDB or maybe something else), it's different MySQL engines and i think you need read first about this.
     
    afstanislav, Aug 21, 2012 IP