Re: Use MySQL Backup Mod as transfer utility?
Thanks for the quick reply! phpMyAdmin always timed out - Fatal error blah blah blah - whenever I tried to restore any sql file over about 10-12 MB, which is why I wanted to use your mod instead. The db I'm trying to restore now is 17MB, and phpMyAdmin choked...again.
In the meantime, I installed the site files and your mod on my desktop's (Win2kPro) localhost (xampp), and got the same error as reported in the above post, so thought maybe the error isn't XP or Internet Guest Account related??? So, searched through the forums again, and found a new thread my earlier search didn't pick up which had this post from you:
To get around Windows' need to use quotes when handling paths that include spaces in the filename/path, simply edit line 23 from this:
Code:
define('OS_DELIM', '');
to this:
Code:
define('OS_DELIM', '"');
And that was the winner - restore worked perfectly!
So, anyone having similar problems as I described above, it seems to be an easy 2-step fix:
1. Correct the path for mysql.exe and mysqldump.exe in the /admin/includes/languages/english/backup_mysql.php file
2. Make the "define('OS_DELIM', '"');" change to /admin/backup_mysql.php file
Bingo!
Last edited by rbobzin; 3 Jan 2008 at 12:17 AM.
RAB
Why is it I'm always surprised when something actually works?