Admin Linux ... MySQL DBA

nohup command if added in front of any command will continue running the command or process even if you shut down your terminal or close your session to machine nohup command-name & Where, * command-name : is name of shell script or command name. You can pass argument to command or a shell script. * & : nohup does not automatically put the command it runs in the background; you must do that explicitly, by ending the command line with an & symbol. examples: # nohup mysql -q -uUSER1 -pPASS1 < dump.sql > dump.log 2> error.log & source: http://www.idevelopment.info/data/Unix/General_UNIX/GENERAL_RunningUNIXCommandsImmunetoHangups_nohup.shtml http://www.cyberciti.biz/tips/nohup-execute-commands-after-you-exit-from-a-shell-prompt.html

Recently,I created tables using auto increment number as the Primary Key. As name say, the number will increase every time I insert new record into the table. At some point I wanted to delete the whole dummy data I inserted. ALTER TABLE tablename AUTO_INCREMENT = value; eg. If I had a items table and I created a few new items and then deleted them, to set the auto increment value back to ‘100′ i would simply: ALTER TABLE items AUTO_INCREMENT = 100;