SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
Thread: Show tables with huge database
-
Jun 2, 2009, 10:40 #1
- Join Date
- Jun 2004
- Posts
- 422
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Show tables with huge database
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.
-
Jun 2, 2009, 11:28 #2
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
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)
-
Jun 2, 2009, 11:34 #3
- Join Date
- Jun 2004
- Posts
- 422
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Thank you!
That's exactly what I was looking for.
Bookmarks