too long

I've moved my live website drupal to windows localhost(xammp), but I'm getting lots of "The file could not be created" errors. If I log in to the site as an administrator, it fails to return any more pages at all. I can view it with errors if I don't log in.

Is there a way to change the temporary file location from an ini file or via mysql database rather than logging in through the interface.

NOTE: without login in admin panel and : admin/config/media/file-system

Thanks.

In the variable table exists a row with name = 'file_temporary_path'. Change it's value, using this SQL:

UPDATE 
    variable 
SET 
    variable.value = 's:5:"\\xammp\\temp";' 
WHERE
    variable.name='file_temporary_path';

If you are going to change the content of the variable database table, remember that every value in that value is serialized through serialize(); serialize("\\xammp\\temp") returns 's:11:"\xammp\temp";'.

If you installed Drush, you can use drush vset to set a Drupal variable.