Welcome to Geeklog, Anonymous Wednesday, November 27 2024 @ 05:40 pm EST

Geeklog Forums

mysqldump on a windows box


Status: offline

rszabbage

Forum User
Newbie
Registered: 07/18/06
Posts: 1
Server: WindowzXP - Apache2 - MySQL 4.01 - gl1.4.0sr5

On Windowz, by default, MySQLServer installs to a folder that includes _spaces_ in the name.

In order to shell an .exe in windowz, that includes _spaces_ in the path, you must enclose the entire path with quotes. i.e.
"C:/Program Files/MySQL/MySQL Server 4.1/bin/mysqldump.exe"

config.php doesn't properly handle $_DB_mysqldump_path = ' "C:/Program Files/MySQL/MySQL Server 4.1/bin/mysqldump.exe" '; and chokes with 'Backup Error: Bad path or mysqldump does not exist'

solution:
copy mysqldump.exe to a location that contains NO spaces in the path, i.e. M:/MySQLStuff

now you can declare in config.php
$_DB_mysqldump_path = 'M:/MySQLStuff/mysqldump.exe';
and the dump works as designed.

Razz
 Quote

All times are EST. The time is now 05:40 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content