MarkMan

Here's a pretty good discussion that helped me in the past to feel more secure in how I connect to a MySQL DB: http://www.totalchoicehosting.com/forums/i...?showtopic=2399

Has anyone who's been using the automysqlbackup.sh script run into a problem recently? It is now throwing an error for me after having run with no problem for almost 2 months on server 109. I even grabbed the script file from an old site backup (when it ran no problem) and it is now throwing the error below. Tech support says it's probably a syntax error in the script and referred me here. But the script hasn't been touched and now it's failing? Note that the same script is running fine, and has been for 6 months, on Server 5 (same MySQL version 4.1.13-standard) Any suggestions, maybe a server-side change of some sort? -thanks >/home/<username>/etc/automysqlbackup.sh: line 32: : command not found /home/<username>/etc/automysqlbackup.sh: line 35: : command not found /home/<username>/etc/automysqlbackup.sh: line 38: : command not found /home/<username>/etc/automysqlbackup.sh: line 41: : command not found /home/<username>/etc/automysqlbackup.sh: line 45: : command not found /home/<username>/etc/automysqlbackup.sh: line 49: : command not found /home/<username>/etc/automysqlbackup.sh: line 57: : command not found /home/<username>/etc/automysqlbackup.sh: line 60: : command not found /home/<username>/etc/automysqlbackup.sh: line 63: : command not found /home/<username>/etc/automysqlbackup.sh: line 64: : command not found /home/<username>/etc/automysqlbackup.sh: line 68: : command not found /home/<username>/etc/automysqlbackup.sh: line 71: : command not found /home/<username>/etc/automysqlbackup.sh: line 74: : command not found /home/<username>/etc/automysqlbackup.sh: line 77: : command not found /home/<username>/etc/automysqlbackup.sh: line 80: : command not found /home/<username>/etc/automysqlbackup.sh: line 83: : command not found /home/<username>/etc/automysqlbackup.sh: line 86: : command not found /home/<username>/etc/automysqlbackup.sh: line 89: : command not found /home/<username>/etc/automysqlbackup.sh: line 92: : command not found /home/<username>/etc/automysqlbackup.sh: line 307: date: command not found /home/<username>/etc/automysqlbackup.sh: line 308: date: command not found /home/<username>/etc/automysqlbackup.sh: line 309: date: command not found /home/<username>/etc/automysqlbackup.sh: line 310: date: command not found /home/<username>/etc/automysqlbackup.sh: line 311: date: command not found /home/<username>/etc/automysqlbackup.sh: line 312: date: command not found /home/<username>/etc/automysqlbackup.sh: line 314: date: command not found /home/<username>/etc/automysqlbackup.sh: line 317: : command not found /home/<username>/etc/automysqlbackup.sh: line 350: syntax error near unexpected token `{ ' /home/<username>/etc/automysqlbackup.sh: line 350: `dbdump () { '

The overflow worked perfect for the first problem (it was added to the stylesheet) A "clear: both" did the trick for IE this time.

Yikes, another late night and another <probably> simple problem . I'm having the exact opposite issue now: Firefox renders as expected (which is usually the case) and IE is wacko. If anyone wants to take a quick look, it'd be great. Site's still under dev example of problem The pic should have some text to the right and a div under it with text, not text wrapping around it. - many thanks

Excellent, it works now. Thanks Bruce!

Sure, here's a link -- but the site is under construction at this time so it looks a little rough right now. div example Even if the code snippets above are placed on a basic html page, then the problem will still occur. Strange thing is, I have other pages with nested divs and pictures but there are no problems -- so, yes, it's probably buggy code

Both the code snippets below work fine in IE 6, but the image and/or text bleeds out of the container div when viewed with Firefox 1.5. Any suggestions?? ...using align="left" on the image: ><div style=" text-align: left; margin: 0px 2% 0px .5%; padding: 15px 10px 15px 10px; width: 94%; border-top: 1px; border-right: 1px; border-bottom: 1px; border-left: 1px; border-style: solid; border-color: #000000; background-color: #d9dffd;"> <a id="ace"></a> <span style="font-family: chiller, comic sans ms; font-size: 30px; color:#003399; font-weight: bold;">Ace of the Month</span> <br /> <img src="images/ace_month_2006_03.jpg" alt="" border="0" width="225" height="300" align="left" /> sajkdf sfl;kjsa fsdfj sfs dfsadj d sd f fsd fdsfds fd d d sd; sd dkfjsad fsdf sdsd fsd sdsd sd fsd fsdf sdf sdf sdf ds f sd dfs fd sfd sd f sd sdf sdf sad f sda fsd f ew we fv ew f ve ge v e ve vgvaasdfs ds f sda fsad fsda fas f sdf sda fsad f sadf sad f dsaf </div> ... or putting the image and text in separate divs: ><div style=" text-align: left; margin: 0px 2% 0px .5%; padding: 15px 10px 15px 10px; width: 94%; border-top: 1px; border-right: 1px; border-bottom: 1px; border-left: 1px; border-style: solid; border-color: #000000; background-color: #d9dffd;"> <a id="ace"></a> <span style="font-family: chiller, comic sans ms; font-size: 30px; color:#003399; font-weight: bold;">Ace of the Month</span> <br /> <div style="float: left; width: 40%"> <img src="images/ace_month_2006_03.jpg" alt="" border="0" width="225" height="300" /> </div> <div style="float: left; width: 20%"> sajkdf sfl;kjsa fsdfj sfs dfsadj d sd f fsd fdsfds fd d d sd; sd dkfjsad fsdf sdsd fsd sdsd sd fsd fsdf sdf sdf sdf ds f sd dfs fd sfd sd f sd sdf sdf sad f sda fsd f ew we fv ew f ve ge v e ve vgvaasdfs ds f sda fsad fsda fas f sdf sda fsad f sadf sad f dsaf </div> </div>

Thank you, Thank you, Thank you! I had tried so many combos that I stopped using the CGI script and just used phpMyAdmin to perform the testing. I was trying to narrow down the problem but, anyway... it's working great now with the SQL command string you posted above. Thanks so much. You da man, TweezerMan.

Yep, all lowercase on the file name. I'm really stumped. Maybe something in the line needs to be escaped? I've tried so many things.

I'm having the same problem in a PERL CGI script. I thought for sure that this post would solve my problem but unfortunately, no. Will someone give me a pointer? It seems I'm very close to getting this to work. Right now I'm just trying to get the command to work in phpMyAdmin but keep getting an error. I've tried sooo many combinations with the command. Here's one of the commands I thought would work from within phpMyAdmin: >LOAD DATA LOCAL INFILE '/home/<username>/public_html/cgi-bin/formdata.txt' INTO TABLE registered FIELDS TERMINATED BY ';' LINES TERMINATED BY '\\r\\n' Here's the error: >#13 - File '/home/<username>/public_html/cgi-bin/formdata.txt' not found (Errcode: 13) I've also tried it with the .txt file in the root directory, not the cgi-bin. .txt Files have full access CHMOD 777

I've found that running a batch file which FTPs the files from the webserver to my home computer is much easier. It can be automated to eliminate the need for user interaction and there's no need to fuss with email messages and attachments. I also have this setup for my site backup file. After FTPing it to my home computer it then deletes the file off the webserver to keep things clean.

Never mind, i just searched the DB for the old version number and manually changed it to .18 This is probably taboo, but it seemed to do the trick .... at least for the UI Your installation is up to date, no updates are available for your version of phpBB.

Weird, does anyone know why this is appearing on the administration panel, or how to have it reflect the correct version? I installed a fresh version of phpBB 2.0.18, linked it to an empty db, then restored a backup db (which was from a 2.0.17 install). I hope I don't have to install .17, restore the db, then update phpBB to .18 Your installation does not seem to be up to date. Updates are available for your version of phpBB, please visit http://www.phpbb.com/downloads.php to obtain the latest version. The latest available version is phpBB 2.0.18. You are running phpBB 2.0.17.

That worked, thanks One thing I noticed is that the same directory name must be used for the newly created forum so that it matches the old forum directory name from which the db backup came.

Sounds good, thanks for the info. I'll look into it.

Sorry for having to be spoonfed here... Any ideas on how to change the following line of code to use sendmail instead of mutt? Replacing mutt w/ sendmail did not seem to work either. mutt -s "MySQL Backup Log and SQL Files for $HOST - $DATE" $BACKUPFILES $MAILADDR < $LOGFILE #send via mutt

So I have a backup of a test forum db and would like to practice restoring it, in case something happens to my real forum. I deleted the BB the mySQL db. I know how to create a forum and am able to restore the db via Cpanel>Backup, but the forum only contains the generic initial install data. How do I recreate the BB and tie it to the correct mySQL db? -thanks

Whew! I am soooo close now. Thanks Bruce, i set the db name and user as you suggested then set my domain back to 'localhost'. It looks like the backup is being made now. So it appears the access error is fixed. There is still this 'mutt' issue. Does this have to do with some type of email notification? Error: /home/<TCH_username>/etc/automysqlbackup.sh: line 568: mutt: command not found Line 568 of the script: mutt -s "MySQL Backup Log and SQL Files for $HOST - $DATE" $BACKUPFILES $MAILADDR < $LOGFILE #send via mutt

Any idea when 2.0.18 will be available to upgrade via Cpanel? Currently my Cpanel is still showing 2.0.17. -thanks

Thanks Bruce, I gave that a try. I'm still getting the access denied error, but now it says something about 'mutt' as well? mysqldump: Got error: 1045: Access denied for user: '<cpanel_username>_BUuser@server5.totalchoicehosting.com' (Using password: YES) when trying to connect /home/cpanel_username/etc/automysqlbackup.sh: line 568: mutt: command not found FYI... line 568 of the script reads: mutt -s "MySQL Backup Log and SQL Files for $HOST - $DATE" $BACKUPFILES $MAILADDR < $LOGFILE #send via mutt

Thanks everyone for the warm welcome. BTW, i've been 'lurking' in these forums for a couple months and they've been of tremendous help. I think I have tried just about every combo, except the right one . Just the automysqlbackup.sh script was set to 777, so I changed it and the top the top folder to 755. Yep, my backup folder is created and set to 755. This seems to be ok because the script created sub-folders within. The DBNAME variable name has been both 'all' and the exact db name. I've tried all three of the mail options, it's now set back to 'files' Other threads said not to place the script in the public_html directory because it contains a password; the preferred directory seemed to be "etc". They also suggested to limit the permission to 700. I did give it a go in the public_html directory and received the same type error as before. I'm back to running it outside of the public_html dir and this is the error: mysqldump: Got error: 1045: Access denied for user: 'BUuser@server5.totalchoicehosting.com' (Using password: YES) when trying to connect /home/<username>/etc/automysqlbackup.sh: line 568: mutt: command not found Don, what do you have "DBHOST" set to? Does 'BUuser@server5.totalchoicehosting.com' look correct in the error output?

Excellent! I just got this thing working also. Suggestion: Edit the script at the beginning of this thread with the tweak above, so that one does not have to wade through this very long thread to get it running properly. Better yet, update the Help file listed waaaaaay above to access the final script so, again, one needn't get lost in this thread trying to figure out the correct script. Just trying to help out the next person that tries to get this set up, especially since it is worthy of being listed in 'Help'

I'm very new to this but I know I'm so close to making this work! There has been quite a bit documented on this topic and I've scoured these forums for hours trying to get this script running smoothly. Hope you don't mind one more... I set up a Cron job to run a MySQL backup script listed in these TCH forums. Here is the error I'm getting now: ERROR 1045: Access denied for user: 'BUuser@server5.totalchoicehosting.com' (Using password: YES) I have fiddled with different values for the different variables in the script, but keep getting errors. I've also set the script file to have full permissions at this point (777) Here is the part of the script where the variables are set. I'm thinking the host name is the value that is incorrect: (Thanks for any help you can give! ) __________________________________________________________ # Username to access the MySQL server e.g. dbuser USERNAME=BUuser (this is a legitmate user for the DB and it has full permissions) # Username to access the MySQL server e.g. password PASSWORD=<PW> (I put in the correct password for the user above... Note: comment seems to have a typo? --should be pw not username) # Host name (or IP address) of MySQL server e.g localhost DBHOST=localhost (I also tried my domain ---> mydomain.org ) # List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3" #DBNAMES="phpbb1" (tried the exact DB name also, ended up going with 'all' which is described in complete script) DBNAMES=all # Backup directory location e.g /backups BACKUPDIR=/home/username/BU/MySQL (sub'd in my username) # Mail setup # What would you like to be mailed to you? # - log : send only log file # - files : send log file and sql files as attachments (see docs) # - stdout : will simply output the log to the screen if run manually. MAILCONTENT="stdout" # Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs]) MAXATTSIZE="4000" # Email Address to send mail to? (user@domain.com) MAILADDR="username@domain.org" (put in my email)