next »

[jelv1]

I actually find running MySQLAdministrator on my own PC considerably more convenient and a lot quicker than using phpmyadmin.

(For anyone trying it, you put the server names in as rumpus.plus.net or humbug.plus.net)

[phugoid]

Another useful tool for editing your MySQL database from your own PC is Navicat – has a nice table editor with foreign key support and allows remote admin via SSH tunnelling.

[petervaughan]

A lot of people will be familiar with phpMyAdmin compared to the others so I for one would prefer that to remain. Or you could offer more than one alternative.

[kitz]

>> Did people like phpmyadmin?

I'm happy with it.  Its a long time since I actually did SQL, therefore as someone who dabbles but isnt an expert I find it pretty easy to understand. It is very widely used therefore theres plenty of help associated with it.  

The main thing though that I feel you should bear in mind is that if you install any software on ccgi [forums, blogs etc] and you want to make any changes - quite often the instructions will be in the format of go to phpmyadmin and do 'blah blah'.
Removal of phpmyadmin would therefore complicate things for many users.


I'm not averse to trying something else if its as a choice and both can be available?

[Penny]

For anyone who needs to do administration of their database can I suggest they download MySQL Administrator or MySQL Query Browser from http://www.mysql.com/products/tools/

We're currently looking at the patches that are required to phpmyadmin, but at the same time are looking at various alternative tools.  If anyone would like to make any recommendations then we'll try to look at those too.  Did people like phpmyadmin?  Do you want to use something else?  Please let us know.
Regards,
Dan Kirkland
Software Platform Manager

I can only say pleeeeease keep the present mysql set-up (I assume that's what phpmyadmin refers to) usable as it is (whatever security changes you need to make).  It took me what seemed like forever and a day to fathom out how to make it all work in the first place, and I'm likely to have several different language databases to process (for output of dual-language worksheets) over the next few weeks.

I really don't feel like I can quite deal with having to learn a whole new mysql set-up as well   

[jelv1]

Penny, there are two parts to what you see as MySQL, the database itself and the tools you use to manipulate it. There are many different ways of doing the second (like you can use many different programs for reading your emails from POP3 or editing text files). phpmyadmin is the second part. The database isn't going to change so what you put in your php programs on ccgi will not be affected.

[Penny]

Penny, there are two parts to what you see as MySQL, the database itself and the tools you use to manipulate it. There are many different ways of doing the second (like you can use many different programs for reading your emails from POP3 or editing text files). phpmyadmin is the second part. The database isn't going to change so what you put in your php programs on ccgi will not be affected.

Yes, I understand that (sort of).  But what about things like setting up a new run for a language db (or a parallel db in another language), or emptying a db whilst retaining the structure, or modifying an existing structure. I'm relatively comfortable with the processes of doing those things (finally) in the existing admin program, but I don't anticipate a replacement program operating in exactly the same way (or would it?) 

Bear in mind these things take me *so* much longer to take on board than the rest of you, seemingly.

[jelv1]

Those would change, but programs of this nature do tend to be very similar in operation.

However, the only suggestions made so far are for programs which can be installed and run on your local PC while phpmyAdmin is offline, not alternatives that Plusnet could consider so it doesn't at this stage look like it will change.

[Penny]

Those would change, but programs of this nature do tend to be very similar in operation.
However, the only suggestions made so far are for programs which can be installed and run on your local PC while phpmyAdmin is offline, not alternatives that Plusnet could consider so it doesn't at this stage look like it will change.

Well good   it's not that I don't recognise that alternatives might well (eventually) make the admin process easier, but right now I'm at that saturation point (seemingly too much to do, too little time) where realism requires just seeing through what must be done, without adding to the load if I don't absolutely have to.

Temporary phase I trust! just one where I'm not best equipped to deal with moving goalposts, perhaps.

[mr_chris]

I say it's a no brainer to keep phpMyAdmin to be honest... just keep it up to date

It's THE standard interface for administering MySQL databases, it's easy, no software to download, no messing about - it's just there, from any PC on the internet.

If you removed phpMyAdmin, I reckon there would be loads of copies being installed into users home directories, simply for the convenience of web-based database management for little tweaks and changes.

My 2p anyway.

[bpullen]

Hi all,

We should be bringing phpMyAdmin back on line shortly. I've just posted a Service Status.

Edit: It's back now.