This assumes you have created a LAMP server and it is working correctly<\/p>\n
1. copy files using ftp client http:\/\/www.mediawiki.org\/wiki\/Manual:Running_MediaWiki_on_Ubuntu<\/a><\/p>\n http:\/\/codex.wordpress.org\/Moving_WordPress<\/a><\/p>\n http:\/\/www.debuntu.org\/how-to-create-a-mysql-database-and-set-privileges-to-a-user\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" This assumes you have created a LAMP server and it is working correctly 1. copy files using ftp client 2. Make Backup of sql (mysqldump -u root -p [databasename] > Backupfile.sql;) 3. on new server – upload files (\/var\/www\/[sitename]) 4. copy sql backup to directory to restore from 5. connect… Continue reading
\n2. Make Backup of sql (mysqldump -u root -p [databasename] > Backupfile.sql;)
\n3. on new server – upload files (\/var\/www\/[sitename])
\n4. copy sql backup to directory to restore from
\n5. connect to mysql (mysql -u root -p
\n6. create database (CREATE DATABASE databasename;)
\n7. Create user for database (GRANT ALL PRIVILEGES ON *.* TO ‘username’@’%’ IDENTIFIED BY ‘some_pass’ WITH GRANT OPTION;)
\n8.restore database (mysql -u root -p [DatabaseName] < SQLBackupFile.sql;)\n9. Change permissions on files (using ftp client)\n\t- For Directories - chmod 755;\n\t- For Files - chmod 644;\n10. Change owner on the files (chown [name:group] \/var\/www\/[website] -R) www-data:www-data for me (this is the user running apache2)\n11. Edit the wp-config.php file and change the database username, password and database name. (use VI instead of notepad)\n12. restart apache2 - (sudo \/etc\/init.d\/apache2 restart)\n13. Change dns to point to new server\n14. Test \n\nNote - i needed to edit the .htaccess file (which I did with VI)\nNote2 - if you want to change the site name, ie ... from www.site.com to test.site.com you need to change the reference in the sql backup before uploading and restoring\n\nFollowup:\nMake sure you add the proper routing to your \/etc\/apache2\/sites-available\/default\n[VirtualHost *:80]\nServerName SiteURL.com\nServerAlias www.siteURL.com\nDirectoryIndex index.php (or start page)\nDocumentRoot \/var\/www\/siteName (from #3 above)\n[\/VirtualHost]\n\nLinks I used and found some of this stuff:\nhttp:\/\/www.magentocommerce.com\/wiki\/groups\/227\/moving_magento_to_another_server<\/a><\/p>\n