Page 1 of 1

Is there a limit to the "LIMIT" script in MySQL?

Posted: Thu Mar 05, 2015 9:42 am
by simonmlewis

Code: Select all

SELECT * FROM `subscribed_upload` LIMIT 300000, 400000
We have a table with over 1.2M rows.
I need to import them all into another table on a completely separate database.
I think it will throw a fit if I try a full on import, so thought I would do it in stages.

But when I run this, it doesn't do anything . and if I run it as a CSV export, it exports nothing.

Re: Is there a limit to the "LIMIT" script in MySQL?

Posted: Thu Mar 05, 2015 9:48 am
by Celauran
Can you not use something like mysqldump? Probably easier that way.

Re: Is there a limit to the "LIMIT" script in MySQL?

Posted: Thu Mar 05, 2015 9:54 am
by simonmlewis
never used that....?!

Re: Is there a limit to the "LIMIT" script in MySQL?

Posted: Thu Mar 05, 2015 10:35 am
by Celauran
If you've got shell access, it's probably the best approach. Manual.

If you don't have shell access, setting up remote access through something like HeidiSQL might also be worth exploring.

Re: Is there a limit to the "LIMIT" script in MySQL?

Posted: Thu Mar 05, 2015 10:39 am
by simonmlewis
OK ta. PS I'll reply to the other thread about the monitor..... bit of a joke!