Hi, everybody, I have a couple of quesitons 1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set autocommit=0' and this only applies to a session. So, when I want to back up data using 'shell>mysql datablse < data.sql', do I need to add 'set autocommit=0' at the begining of data.sql? 2. Is there a way to change the default value of 'autocommit' whenever mysql starts? Like 'set-variable = autocommit = 0' in 'my.cnf'. Also, how can I know the mysql is using 'autocommit=0 or 1' since there is no mysql command that shows that particular info, or since 'set autocommit=0 or 1' is session based, we reset the 'autocommit' at each session. Yours Ryu