topic Problem backing up MySQL on WinSvr 2003 x64 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/problem-backing-up-mysql-on-winsvr-2003-x64/m-p/255179#M208309 <HTML><HEAD></HEAD><BODY><SPAN>ok.. I've tried the works here.. spent hours on end.. hoping I can find some help. <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN><BR /><BR /><SPAN>Alfresco is running great. No install issues, but I could't find the topic just relating to backup configuration..</SPAN><BR /><BR /><SPAN>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 :</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Usage: mysqldump [OPTIONS] database [tables]<BR />OR&nbsp;&nbsp;&nbsp;&nbsp; mysqldump [OPTIONS] –databases [OPTIONS] DB1 [DB2 DB3…]<BR />OR&nbsp;&nbsp;&nbsp;&nbsp; mysqldump [OPTIONS] –all-databases [OPTIONS]<BR />For more options, use mysqldump –help</BLOCKQUOTE><BR /><SPAN>my command line is as follows :</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">mysqldump -u root -p ******** -A -c -f&gt; alf_bkup.sql</BLOCKQUOTE><BR /><SPAN>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. </SPAN><BR /><BR /><SPAN>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. </SPAN><BR /><BR /><SPAN>Installed Alfresco from the Windows Installer. Version 3.2c (community version)</SPAN><BR /><BR /><SPAN>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. </SPAN><BR /><BR /><SPAN>Can anyone help? This is mission critical. Thank you so much!</SPAN></BODY></HTML> Tue, 19 Apr 2011 07:49:05 GMT gbrann 2011-04-19T07:49:05Z Problem backing up MySQL on WinSvr 2003 x64 https://connect.hyland.com/t5/alfresco-archive/problem-backing-up-mysql-on-winsvr-2003-x64/m-p/255179#M208309 ok.. I've tried the works here.. spent hours on end.. hoping I can find some help. <IMG id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" />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 Tue, 19 Apr 2011 07:49:05 GMT https://connect.hyland.com/t5/alfresco-archive/problem-backing-up-mysql-on-winsvr-2003-x64/m-p/255179#M208309 gbrann 2011-04-19T07:49:05Z Re: Problem backing up MySQL on WinSvr 2003 x64 https://connect.hyland.com/t5/alfresco-archive/problem-backing-up-mysql-on-winsvr-2003-x64/m-p/255180#M208310 <HTML><HEAD></HEAD><BODY><SPAN>In the end this is a reminder to us all that syntax is king.</SPAN><BR /><BR /><SPAN>I fixed the error. It was insanely simple. I had the following mysqldump command - </SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">mysqldump -u root -p password -A -N -f&gt; alf_bkup.sql</BLOCKQUOTE><BR /><SPAN>however.. the CORRECT command should look this this</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">mysqldump -uroot -ppassword -A -N -f&gt; alf_bkup.sql</BLOCKQUOTE><BR /><SPAN>I'm posting this so anyone else who had this problem or has this problem can find the solution faster then I did.</SPAN></BODY></HTML> Tue, 19 Apr 2011 15:46:47 GMT https://connect.hyland.com/t5/alfresco-archive/problem-backing-up-mysql-on-winsvr-2003-x64/m-p/255180#M208310 gbrann 2011-04-19T15:46:47Z