On Sun, 11 Apr 2010 09:13:45 -0700 (PDT) john espiro <john_esp...@yahoo.com> wrote:
> Hi folks - > Hello John, > While upgrading my database to the 3.9 version, I was running: > > ALTER TABLE `dspam_token_data` > CHANGE `uid` `uid` INT UNSIGNED NOT NULL, > CHANGE `spam_hits` `spam_hits` BIGINT UNSIGNED NOT NULL, > CHANGE `innocent_hits` `innocent_hits` BIGINT UNSIGNED NOT NULL; > > After about 9 hours, my putty session crashed. Now, the DB is about 1.4GB. > How can I tell if I need to re-run this again? > > Advice? > To be on the secure side I would strongly suggest you to rerun the commands again. I would suggest to run the script in a screen session. Something like: --------------------------------- # screen -AdmS dspam_update # screen -rdS dspam_update # mysql --user=root -p --socket=/var/run/mysqld/mysqld.sock --batch -e "ALTER TABLE `dspam_token_data` CHANGE `uid` `uid` INT UNSIGNED NOT NULL, CHANGE `spam_hits` `spam_hits` BIGINT UNSIGNED NOT NULL, CHANGE `innocent_hits` `innocent_hits` BIGINT UNSIGNED NOT NULL;" --------------------------------- That way you can disconnect from the screen session (pressing CTRL + a , CTRL + d) and even disconnect from the host and let the script finish. 9 hours is a lot of time for a 1.4GB DB. What version of MySQL do you use? What database engine do you use? > Thanks, > John > -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
