Webmaster Forum


Go Back   Webmaster Forum > Web Development > Coding Forum

Coding Forum Problems with your code? Discuss coding issues, including JavaScript, PHP & MySQL, HTML & CSS, Flash & ActionScript, and more.


Reply
 
LinkBack Thread Tools Display Modes
Share |
  #1 (permalink)  
Old 08-21-2012, 05:48 AM
apostars's Avatar
Junior Member
 
Join Date: 03-29-10
Posts: 23
iTrader: 0 / 0%
mysql issue moving to vps

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
 
Reply With Quote
  #2 (permalink)  
Old 08-21-2012, 12:22 PM
Super Moderator
Latest Blog:
None

 
Join Date: 11-11-11
Location: Copenhagen, Denmark
Posts: 1,772
iTrader: 0 / 0%
Quote:
Originally Posted by apostars View Post
should i use innodb ? or MyISAM ?
Here is a link with informations about the different mysql storage engines:
Storage Engines

Quote:
Originally Posted by apostars View Post
also i dont know how to move db to the ssd any one can explain
Here is a link with a few different ways to copy a database from one server to another:
Moving an InnoDB Database to Another Machine
__________________
Need a break? EnterCave more than 40000 online games in 15 categories.
Search or browse through EnterCave Online Games Directory
 
Reply With Quote
Go Back   Webmaster Forum > Web Development > Coding Forum

Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving from XOOPS to a non-XOOPs issue? sonnextw Coding Forum 0 09-16-2010 11:40 PM
mysql query performance issue gilbertsavier Coding Forum 1 08-04-2009 06:59 AM
[MySQL] Order By Issue Leon Coding Forum 2 07-13-2009 02:35 PM
mySQL Issue Sketch Coding Forum 8 01-16-2007 11:09 PM


V7N Network
Get exposure! V7N I Love Photography V7N SEO Blog V7N Directory


All times are GMT -7. The time now is 12:32 AM.
Powered by vBulletin
Copyright © 2000-2013 Jelsoft Enterprises Limited.
Copyright © 2003 - 2013 Escalate Media LP




Search Engine Optimization by vBSEO 3.6.0 RC 2 ©2011, Crawlability, Inc.