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. Manual.

If you don't have shell access, setting up remote access through something like HeidiSQL 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/