how to move prestashop to new host ?

[SiamaK]

Dear friends , could you tell me how i can move my shop ( prestashop ) to a new host ?!
i tired from searching about this matter on the forum ..

[Martin C]

1. Backup and restore your database on the new host.
2. Copy directory and files to the new host and check your config/settings.inc.php

But this issue is covered more then once on the forum use the search to find more information

[SiamaK]

I can't import my old DB back up to new DB , i have this error :

Table structure for table `access`
--
CREATE TABLE IF NOT EXISTS `access` (
`id_profile` int( 10 ) unsigned NOT NULL ,
`id_tab` int( 10 ) unsigned NOT NULL ,
`view` int( 11 ) NOT NULL ,
`add` int( 11 ) NOT NULL ,
`edit` int( 11 ) NOT NULL ,
`delete` int( 11 ) NOT NULL ,
PRIMARY KEY ( `id_profile` , `id_tab` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8;

????? MySQL :???????
#1046 - No database selected

[Martin C]

Proberly create database is not in your script

[SiamaK]

Perhaps ..., now could you tell me how i cant set my website that can work with New DB .../

i imported new DB's Info into settings.inc.php , but when i enter to my website address i have this one error :
Invalid loadConfiguration() SQL query!


i confused.. :-(

[theme_designer]

If the version of Mysql between your old webhosting and new webhosting is different, it will occur error when importing SQL file.

[SiamaK]

now what i should to do ?

[SiamaK]

Hey Friends any one can't help me ?