I am trying to relocate MySQL and a database to another hard drive on the
same system. According to this page,
http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html, I get the
impression that I should be able to do this by copying the data files to the
new MySQL installation. However, th
Greetings all, I am trying to track down the cause of some issues I'm
having. I am doing this from the mysql prompt:
start transaction;
source c:/queries.sql;
rollback;
When I examine the db though, it appears that the changes from the sourced
queries have been committed.
--
MySQL General Ma
""João Cândido de Souza Neto"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Could you try to put the start transaction into your .sql file.
Ok, I tried that -- same result. I even tried including the rollback in the
.sql file as well, but the changes are still committed afterwa
I have a puzzling situation where a query works, but only outside of a
function. If I try to abstract away some of the complexity by placing the
subquery inside a function, the db seems to get stuck in an infinite query
and the entire system becomes unresponsive (from the MySQL console I can
ctrl-c
