re: copy data between very large tables

2003-10-16 Thread mhlists
gt;We copy data from one table to another using: gt;insert into TBL1 select * from TBL 2; gt;The current database hangs and the process never finish when copying gt;huge gt;tables (around 25million rows). Looking at the processlist it states that gt;the process stays in \closing table\ or

re: First Time Install Leads To Slight Confusion

2003-10-14 Thread mhlists
1) After I did the above is the server running or not? I believe I need to do a NET START MySql And if so, is there a way to make this a service that starts up when my box comes up? You do need to do a NET START MYSQL, but since you are using NET commands mysql IS installed as a service and

Re: SQL Injections

2003-10-09 Thread mhlists
\As I understand it, and I confess I am not totally sure I do, sql injection is more of a problem in your page code than what database (/version) you run.\ Absolutely. As I show at http://www.vbmysql.com/articles/sqlinjection.html SQL Injection is a flaw in the front-end code, and you are at