Hi, first congratulation for this module, it's easier than phpmyadmin.

I have a small annoyance:
- i made a backup of 1 server, and restore on a other server
- 1 server is windows, the other Mac OS X
- the php temporary file is different (on is \\xampplite\\tmp, the other /myhost/xxxxx/tmp)
- this path is store in the VARIABLE table in drupal, name=file_directory_temp
- The first restore is ok
- but, the second restore failed during the upload ...

In the module "Backup and Migrate", when I try to "Upload a backup file" (in the "Restore/Import DB" tab), I got an error because drupal cannot save the temporary uploaded file in it temporary path (the varialbe file_directory_temp corresponding to the other server)

# warning: move_uploaded_file(/myhost/xxx/tmp/yyyy-2008-08-15T14-45-.sql) [function.move-uploaded-file]: failed to open stream: No such file or directory in C:\xampplite\htdocs\pgvl\includes\file.inc on line 572.
# warning: move_uploaded_file() [function.move-uploaded-file]: Unable to move '\xampplite\tmp\php367.tmp' to '/GizServer/ChaudiereWebServerProd/tmp/yyyy-2008-08-15T14-45-.sql' in C:\xampplite\htdocs\pgvl\includes\file.inc on line 572.

My work around now, is to copy my sql file directly in
\sites\default\files\backup_migrate\manual
and use the tab "saved backup" instead (to avoid the upload processus ...)

But my variable "file_directory_temp" won't be set properly on one of my server (which will cause other problem to other module who need upload)

Is there a way to avoid the inclusion of some data (if I exclude the "variable" table i could have other probleme ....)

Regards.

Comments

ronan’s picture

ronan commented

Hi there,

at some point I may include the option to exclude certain variables from the dump for this very reason. In the mean time, I'd recommend using the $config array in your settings.php file to store variables which you do not want to get wiped out when the database is restored (instructions are in the settings file itself). This can also be useful for google maps api keys and other info that is server specific.

Hope this helps
Ronan

nico059’s picture

nico059 commented

Thanx Ronan for the trick !

I didn't knew this setting ... what a long learning curve .... (or I'm too slow ;-) ....
So I will adjust the settings.php on my 2 servers like this:

$conf = array(
   'file_directory_temp' => 'THE_PATH_ON_MY_SERVER'
 )

Hope I could help futur developpement (test, review, code ?) of your module

ronan’s picture

ronan commented
Status: Active » Closed (fixed)

Glad I could help. Let me know if you have any more questions, and if you're looking to help out. Stay tuned, an early draft of version 2 will be released soon, and I'll need lots of testers.

Thanks
Ronan