Re: optimising for 100000 entries

2011-09-15 Thread mos
Doc, When the user clicks on the Category on the left, it is not changing the URL. If I change the url manually to "Path=2" etc. and press enter, the page loads correctly with that category. So it looks like your problem is the PHP code not executing the SQL query at all or it is not req

Re: optimising for 100000 entries

2011-09-15 Thread Wm Mussatto
On Thu, September 15, 2011 11:27, The Doctor wrote: > On Thu, Sep 15, 2011 at 08:55:16AM -0400, Shawn Green (MySQL) wrote: >> On 9/14/2011 15:26, The Doctor wrote: >>> On Wed, Sep 14, 2011 at 09:49:34PM +0530, Ananda Kumar wrote: So, You want to have 100,000 buttons for 100,000 entries or

Re: optimising for 100000 entries

2011-09-15 Thread The Doctor
On Thu, Sep 15, 2011 at 08:55:16AM -0400, Shawn Green (MySQL) wrote: > On 9/14/2011 15:26, The Doctor wrote: >> On Wed, Sep 14, 2011 at 09:49:34PM +0530, Ananda Kumar wrote: >>> So, >>> You want to have 100,000 buttons for 100,000 entries or just have one filter >>> column, which allows you to spec

Re: Questions about Mysqldump

2011-09-15 Thread Ananda Kumar
or u can use "for loop", have only the database to be exported and use that variable in --database and do mysqldump of each database. On Thu, Sep 15, 2011 at 6:27 PM, Carsten Pedersen wrote: > On 15-09-2011 10:31, Chris Tate-Davies wrote: > >> Adarsh, >> >> 1) >> >> When restoring a mysqldump you

Re: Questions about Mysqldump

2011-09-15 Thread Carsten Pedersen
On 15-09-2011 10:31, Chris Tate-Davies wrote: Adarsh, 1) When restoring a mysqldump you have the option of which database to restore. mysql database1 < backup.sql Admittedly, it's been a few years since I last used mysqldump, but I suspect that it will contain USE commands - as such, it wil

Re: Questions about Mysqldump

2011-09-15 Thread Chris Tate-Davies
Adarsh, 1) When restoring a mysqldump you have the option of which database to restore. mysql database1 < backup.sql 2) You might be able to use the --ignore-table command. I'm not sure if this would work mysqldump --all-databases -q --single-transaction --ignore-table=databasetoignore.*