Problem backing up MySQL on WinSvr 2003 x64

[gbrann]

ok.. I've tried the works here.. spent hours on end.. hoping I can find some help.

Alfresco is running great. No install issues, but I could't find the topic just relating to backup configuration..

I don't think you need all 162 lines of my backup procedure for the server.. the issue is backing up mysql. mysqldump gives no errors but my output .sql files is 1kb.. it simply states :

Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3…]
OR     mysqldump [OPTIONS] –all-databases [OPTIONS]
For more options, use mysqldump –help

my command line is as follows :

mysqldump -u root -p ******** -A -c -f> alf_bkup.sql

The dump creates the outfile.. but no tables or data. I'm going crazy here looking all over the place and trying so many things.

I also found that mysqldump will not run is the SQL server is shut down, so we are only shutting down Tomcat. We don't have the openoffice service.

Installed Alfresco from the Windows Installer. Version 3.2c (community version)

I also found that we have no alfresco-global.properties files.. just the sample file. But this hasn't created any issues. It runs great.. backup seems to the issue on hand.

Can anyone help? This is mission critical. Thank you so much!

[gbrann]

In the end this is a reminder to us all that syntax is king.

I fixed the error. It was insanely simple. I had the following mysqldump command -

mysqldump -u root -p password -A -N -f> alf_bkup.sql

however.. the CORRECT command should look this this

mysqldump -uroot -ppassword -A -N -f> alf_bkup.sql

I'm posting this so anyone else who had this problem or has this problem can find the solution faster then I did.