Title: devlin85's Replies | WordPress.org

---

# devlin85

  [  ](https://wordpress.org/support/users/devlin85/)

 *   [Profile](https://wordpress.org/support/users/devlin85/)
 *   [Topics Started](https://wordpress.org/support/users/devlin85/topics/)
 *   [Replies Created](https://wordpress.org/support/users/devlin85/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/devlin85/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/devlin85/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/devlin85/engagements/)
 *   [Favorites](https://wordpress.org/support/users/devlin85/favorites/)

 Search replies:

## Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Migrating to VPS from Shared Hosting](https://wordpress.org/support/topic/migrating-to-vps-from-shared-hosting/)
 *  [devlin85](https://wordpress.org/support/users/devlin85/)
 * (@devlin85)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/migrating-to-vps-from-shared-hosting/#post-3850458)
 * **Update** another issue I ran into (when DNS finished populating) was on VPS&
   Dedicated Servers mod-rewrite tends to be disabled by default (and in a few ways),
   so any commands your .htaccess files have will be completely ignored, oh, and
   this also means ONLY YOUR MAIN PAGE will load. To fix this you just need to enable
   mod-rewrite on your apache server.
 * To make sure mod-rewrite is enabled:
 * – send command “a2enmod rewrite” to your server either through terminal or web
   interface to ensure it is enabled server-side
    – SCP/SSH/File Manager into your
   VPS and go to “/etc/apache2/sites-available/” – Edit either the “default” file
   which would make all changes sitewide or one specifically made for just your 
   wordpress install if there is one (if you used a script to install there would
   be) – Change any instances of “AllowOverride None” to “AllowOverride All” – Restart
   VPS or at a minimum restart Apache server
 * Your website should now be fully functional!
 *   Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
   
   In reply to: [Migrating to VPS from Shared Hosting](https://wordpress.org/support/topic/migrating-to-vps-from-shared-hosting/)
 *  [devlin85](https://wordpress.org/support/users/devlin85/)
 * (@devlin85)
 * [12 years, 2 months ago](https://wordpress.org/support/topic/migrating-to-vps-from-shared-hosting/#post-3850457)
 * Pretty much everything 2niner2niner said is true, but i ran into a few problems
   with SQL compatibility (ERROR 1062 (23000) at line XXX: Duplicate entry ‘XXX’
   for key ‘PRIMARY’); and rather than zipping/extracting and wasted steps you can:
 * – Login though FTP and download your wordpress directory
    – Backup your Database
   through myPhpAdmin to SQL (Required Settings: UNCHECK “AUTO_INCREMENT” under 
   create table options, and CHECK “Truncate Table before insert” and “INSERT IGNORE
   statements”. Optional: Select the datatbase system compatibility) – Install wordpress
   on new site – Upload your backed up wordpress directory over your new install–
   Update settings in wp-config.php (check wp from your new install, if installed
   through your server or script it might already have the settings you need) – 
   Import your SQL dump – Update your DNS settings to reflect your new site
 * Enjoy!

Viewing 2 replies - 1 through 2 (of 2 total)