Server Shutdown, Start & Restart

2006-01-25 Thread Joseph E. Maxwell
FreeBSD / UNIX platform, MySQL ver.4.0.16 Prob. of growing /tmp file, solved by introducing a cron job to clean up the folder intermittently. Prob.solve but new one created - mysql socket wiped out. Could not restart the server with all the standard methods. Complained of other running processes.

Where are warning messages redirected or logged to ?

2005-01-14 Thread Joseph E. Maxwell
A pain replying to digest in digest mode, change mode to normal Warning messages, as from a mysqlimport command, where are they to be found? Part of the construct from a cron job script file run at the command line interface $ /usr/local/bin/mysqlimport -v -l --fields-terminated-by="

Where are warning messages redirected or logged to ?

2005-01-12 Thread Joseph E. Maxwell
Warning messages, where are they to be found? Part of the construct from a cron job script file run at the command line interface $ /usr/local/bin/mysqlimport -v -l --fields-terminated-by="|" --local fisheries -L -u administr -p $CRONBASE/trawler.tmp Connecting to localhost

Re-installing db/tables from dumpfile

2004-08-21 Thread Joseph E. Maxwell
I am moving my database(s) from one server to another, did a full dump of the data and have a large file with all the create instruction sets etc. My question, what is the best way to recreate these db, tables etc. on the new server. MySQL is already installed & running. Thanks -- MySQL General