UBB.Developers Forums UBB.threads 7 Development How Do I? MYSQL path so you can backup

Hey I think this might be a bug but we shall see. On a windows server the path to MYSQL would be say for instance

c:\mysql

However if you try and enter that in the config file and update your forums it breaks everything to hell. I have tried it with and without the trailing slash. Any ideas on why it won't let me set the mysql setting when I know it is correct.

I was helping someone install a forum and thats the only thing left to do. I double checked with the server people and that is where mysql is at?

Have you tried c:/mysql or c:\\mysql?

I have tried

c:\mysql and c:\\mysql and c:/mysql

In all cases the file is 0 bytes that it creates. I know on my unix server that was called by a wrong path. I had usr/bin when it was usr/local/bin. Now on this windows server I know the path to mysql is indeed the path above.

Chuck,

I have an NT system and my installation was inside the Program Files folder. Hence my config.inc.php file contains:

$config['mysqlpath'] = "C:/Progra~1/mysql/bin";
$config['mysqldumppath'] = "C:/Progra~1/mysql/bin";

I don't know how the unix MySQL installation folders are but the executable on the Windows installation is in the bin subfolder.

I hope this helps.

Thanks I am getting him to double check the executables path.

Yep the path is c:\mysql\bin

I have tried every combination of slashes every which way and all files are being backup up as 0 bytes.

I think I might post this over at Infopop as a bug. HMM

The path I know is correct and have tried all combo of slashes. I was beggining to think it might be cause Lock table permissions where not given so I made sure grant all privelidges was run on the server by mysql. Pain in the butt.

If is on a dedicated server why not just setup an AT job to do the backups every day? Easier and automatic, don't have rely on memory.

Chuck,

Another idea that came to me is permissions on the output folder. You need to have Everyone with Write and Read access otherwise you will not be able to create the files.

Check this with the network guys and try it again. I often found out this to be a problem on my server.

on this subject, sorry to thread drift a tad... does the backup use the system() command?

nikos the file passes the test it is indeed writeable.

What happens if you run the command manually from the prompt or from a script that you have created (I don't know if you can RAdmin to the box or if you have telnet).

The site this is on they will be switching servers. Nope no telnet access.

Sorry run out of suggestions.... The only that I can think of is to ensure that mysqldump works and this can be done only via telnet or direct access to the box.