PHP Developers Network
http://forums.devnetwork.net/

Is there a limit to the "LIMIT" script in MySQL?
http://forums.devnetwork.net/viewtopic.php?f=2&t=141040
Page 1 of 1

Author:  simonmlewis [ Thu Mar 05, 2015 10:42 am ]
Post subject:  Is there a limit to the "LIMIT" script in MySQL?

Syntax: [ Download ] [ Hide ]
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.

Author:  Celauran [ Thu Mar 05, 2015 10:48 am ]
Post subject:  Re: Is there a limit to the "LIMIT" script in MySQL?

Can you not use something like mysqldump? Probably easier that way.

Author:  simonmlewis [ Thu Mar 05, 2015 10:54 am ]
Post subject:  Re: Is there a limit to the "LIMIT" script in MySQL?

never used that....?!

Author:  Celauran [ Thu Mar 05, 2015 11:35 am ]
Post subject:  Re: Is there a limit to the "LIMIT" script in MySQL?

If you've got shell access, it's probably the best approach. .

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

Author:  simonmlewis [ Thu Mar 05, 2015 11:39 am ]
Post subject:  Re: Is there a limit to the "LIMIT" script in MySQL?

OK ta. PS I'll reply to the other thread about the monitor..... bit of a joke!

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/