Show tables with huge database

[CyberAlien]

I need to list all tables from database, I know that query for it is "SHOW TABLES", but there is a big problem: there are thousands of tables and I need to get it from a script that has an execution timeout, so I need to get that list in several sessions.

Is it possible to get list of tables in small chunks? Like tables 1-100 in one query, tables 101-200 in other query.

[r937]

sure -- just read the table names from the INFORMATION_SCHEMA database and do them in chunks (you'll need your programming language to do that, php or whatever)

[CyberAlien]

Thank you!

That's exactly what I was looking for.