Move your store to a new host
Database
-
Goto your new host and open phpMyAdmin (or similar)
-
Add a new user to this database
Run the SQL file you created during the backup in phpMyAdmin
Store
FTP your store files from your local machine to your new host
Now in order to get your store to work on your new host you will need to edit the configure.php files within osCMax to match your new server settings.
Please note there are 2 configure.php files - one in admin/includes/ and one in includes/
2 Gotchas to look out for
When you move your store don't forget to go into cPanel (or similar) and redo your .htaccess file otherwise you will get a 500 HTTP error when you try and get into your admin panel.
When you install your database through phpMyAdmin and you add your database user - you need to remember to go to cPanel > Databases >
MySql databases > Add a User to a Database > Click Add > Grant All Privileges. Otherwise you will get an annoying error that looks like this:
1046 - No database selected select value from sessions where sesskey
Changes to be made
define('HTTP_SERVER', 'http://www.yourservername.com');
define('HTTPS_SERVER', 'https://www.yourservername.com');
define('ENABLE_SSL', false);
define('HTTP_COOKIE_DOMAIN', 'www.yourservername.com');
define('HTTPS_COOKIE_DOMAIN', 'www.yourservername.com');
...
define('DIR_FS_CATALOG', '/home/sites/yourservername.com/public_html/');
...
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'your_user_name');
define('DB_SERVER_PASSWORD', 'your_password');
define('DB_DATABASE', 'database_name');
define('USE_PCONNECT', 'false');
define('STORE_SESSIONS', 'mysql');