/**
* Moving Magento, Config Folder and Database
*
*/
//Database config
/app/etc/local.xml
//Also
rm -Rf magento/var/session;
rm -Rf magento/var/cache;
//Database stuff

UPDATE core_config_data SET value = "http://127.0.0.1:8888/New_Place/" WHERE path="web/unsecure/base_url";
UPDATE core_config_data SET value = "http://127.0.0.1:8888/New_Place/" WHERE path="web/secure/base_url";

TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;

#
# Magento Database import SQL Files
#

#Export with mysql_dump or phpMyAdmin

#Header
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';
SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0;

#...this on the Footer
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;
SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;
SET SQL_NOTES=@OLD_SQL_NOTES;

/**
* Magento Folder Settings and Permissions
*
*/
find . -type d -exec chmod 777 {} \;
find . -type f -exec chmod 644 {} \;
chmod 777 -R downloader
chmod 777 -R app/etc
//Also running Apache
find . -exec chown apache {} \;
find . -exec chgrp apache {} \;

Force the modules to upgrade the MySQL Version
To make sure that magento is using the scripts: Module_name/sql/mysql-upgrade*
1) Disable module
2) Delete cache
3) change the version number of the modules in
core_resource
doing
UPDATE `core_resource` SET `version` = ‘1.4′ WHERE `core_resource`.`code` = ‘Orderpreparation_setup’ LIMIT 1 ;
4) Enable module