Transfering a complete shop to another hosting company.

[joenmass]

I have a hosting company that quite frankly sucks ( my website has been down for hours on end for three days in a row)! I want to tranfer my complete shop to a more reliable hosting company. I have invested quite a bit of time modifying my shop.
Has anyone done a complete transfer to another hosting company just by transfering all their folders and files then importing their database backup file. I tried saving a copy of my database file through prestashop's backend but when I try to upload it into my other hosting company's database it throws an error. Looks like the format that prestashop saves the database files in is not recognized by MySQL.

[Balefire]

I have a hosting company that quite frankly sucks ( my website has been down for hours on end for three days in a row)! I want to tranfer my complete shop to a more reliable hosting company. I have invested quite a bit of time modifying my shop.
Has anyone done a complete transfer to another hosting company just by transfering all their folders and files then importing their database backup file. I tried saving a copy of my database file through prestashop's backend but when I try to upload it into my other hosting company's database it throws an error. Looks like the format that prestashop saves the database files in is not recognized by MySQL.

Do you have access to phpmyadmin? Use that to backup the database instead of PrestaShop. On my installation PrestaShop compresses the file with bz2 which is a unix compression format. Probably because it's hosted on Debian. If you are on windows, download 7zip which I seem to remember can extract files from bz2 format, then either upload the extracted file to your new host or recompress as a zip file.

Alternately, what' is the error message? Not telling us that is like asking your mechanic what is wrong with your car and not telling him what's happening!

HTH

[joenmass]

Do you have access to phpmyadmin? Use that to backup the database instead of PrestaShop. On my installation PrestaShop compresses the file with bz2 which is a unix compression format. Probably because it’s hosted on Debian. If you are on windows, download 7zip which I seem to remember can extract files from bz2 format, then either upload the extracted file to your new host or recompress as a zip file.

Alternately, what’ is the error message? Not telling us that is like asking your mechanic what is wrong with your car and not telling him what’s happening!

Thanks. Yes i have access to phpmyadmin. I will do a complete backup from phpmyadmin and see what will happen. The error message was that is just said something like unable to update database because of the file format. Like you said it must be because it is in a unix format.

[blaszta]

1. Copy all you files & directory (especially prestashop folder) from old hosting
2. Backup the database using phpmyadmin
3. Upload all the files to new host
4. Access the new host control panel to create a database for the shop (remember the name of the database, username, & password).
5. Run phpmyadmin in the newhost, choose the database you just created, and restore all the data from the old host
6. Edit /config/settings.inc.php and change _DB_NAME_, _DB_USER_, _DB_PASSWD_ using info from step no 4.

Good luck!