Hi

I have tried to get this to work and read numerous posts about similar things...

I am leaving my old hosting server and coming to a new one. I am unable to get the survey to work on the new server. There is obviously some settings that I am missing.

I started off by installing 1.53 with fantastico and then upgrading to 1.7. No dramas there at all.

I now want to move the survey to another host.

I have upload the files and upload the database to the new host. I have amended the config.php to reflect the new $databasename and $databaseuser

It doesn't work - It seems too easy but I am not a mysql expert at all.

My error is Can't connect to LimeSurvey database. Reason: Access denied for user 'the49792_lime1'@'localhost' (using password: YES)

Are there any guides showing what has to be done for the upgrade to take place?

thanks

Glenn

Hi Glenn, you may need to check with your host. This error is most likely caused by either: (1) Incorrect username or password, or (2) the server is refusing permission to the user.

If it's (2) then someone with admin access to the mySql server is going to have to look at it.

It's really going to be nothing to do with upgrading or anything. This is a quite simple error message that is saying that LimeSurvey has tried to talk to the MySQL server, and the MySQL server is refusing to talk back.

Jason

Hi

Thanks Jason for the reply - It was a slow process as the domain was the same on both servers and when the nameservers were changed, the existing survey wouldn't let me into the admin area to make backups etc.

I changed name servers back to old host, backed up then set up from scratch on the new host.

Yay, the survey is working now I got import problems in which I need help - I'll ask in a new reply.

Glenn

Hi

I have changed host servers keeping the same domain name.

I have go to the stage where I have been able to import the questions OK, its just the answers are not coming across.

I have tried all of the tricks, tweaks, FAQ's I can find and have not had success.

I have the exported VV file -

When I import it looks like I get the first 3 or 4 columns up to ref url then the rest is just empty white space (after import).

Is someone able to make a simple 1.2.3 of how to import total questions and answers please.

The export/backup files I have exported and trying to import to the same version.

The other thing I do not understand is that you can make a backup of the mysql but you cannot restore it anywhere. Would it help to overwrite the database with the backup?

Please help if you can.......thanks

Glenn

Do not use LimeSurvey to transport the database.
Export your database with the old provider using the tools they normally provide, like phpMyADmin.
Then import the whole database on the new host.
That is the clean and only recommended way.

Thankyou so much - I copied/imported the mysql over the top and it worked a treat.