re: copy data between very large tables
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 \wait on cond\ status. You could always look at chunking the data by using progressive LIMIT clauses. INSERT INTO TBL1 SELECT * FROM TBL2 LIMIT 100; INSERT INTO TBL1 SELECT * FROM TBL2 LIMIT 100,100; and so on... Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: First Time Install Leads To Slight Confusion
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 should come up the first time you run it. 2) Do you need the server running in order to use the Database from Java? Yes, without the server running Java has nothing to query. 3) What is the proper way to start the gt;mysql prompt. I want to ensure that I am secure. Proper way is, from the mysql\\bin directory, to type: mysql -u root -p Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: SQL Injections
\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 risk in ANY MySQL version. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]