phpMyAdmin Bookmarks

[AlanDI1]

I just upgraded to MySQL 5.0.16, PHP 5.1.1 and phpMyAdmin 2.6.4-pl4. I had older versions running fine. They all run on a Windows 2003 standard server with IIS 6. All works fine sort of.

For the older version of phpMyAdmin I had a bunch of SQL Selects in text files that I would use the file picker in the SQL tab to select and execute to see the data in different tables. In 2.6.4 when I tried to open those text files in the same way all I got was an error that said "File could not be read(4)" but when I copied and pasted the Select into the query window the query produced the correct results. So the SQL Selects do work but the file could not be opened.

So I set up Bookmarks and put all the queries in bookmarks and they work fine.

I have a test server which I control and a production server which the ISP controls. I created the pmadb database with the bookmarks on my test server. But I cannot create the database or tables on the production server without at a minimum paying an additional monthly fee. So when I am accessing the data on the production server I want to use my Bookmarks in the pmadb database on the test server. Is there any way to do that?

Is there a way in the:

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

configuration command to also specify a server? How is that done?

Any help would be appreciated.

Thanks

 

[jpadie]

often ISP's limit the number of databases that you can have but i have never heard of them limiting the number of tables (other than by total db size). are you sure about this?

I believe that with phpmyadmin the pmadb needs to reside on the same server as the database(s) that it is working with. also, often ISP's deny db access from outside its servers.

however, if you can create tables then just point the pmadb config option at your current database and set the table options below the pmadb option to something with a suitable prefix so that you can easily distinguish them.

 

[AlanDI1]

Thanks jpadie for the response. That's what I ended up doing but my concern was about space, which they do charge for. It also meant recreating the queries (again) on the ISP's server. Just a little time consuming.

Seems like I am not the only one that might be in this situation, just thought there might be an out.

Thanks again.

 

[jpadie]

have you considered just customising the relevant page of phpmyadmin a little bit to show you a list text files with your sql queries in them? it would be bookmarks but would give you back the functionality and ISP's tend to be more friendly with the storage space than they are with the database space (although I can't understand why, space is space...)

 

[AlanDI1]

No, I hadn't but that is a thought.

Thanks

 

[jpadie]

sorry - meant "it would NOT be bookmarks"...