1
asche
database administration tool - alternative for phpadmin?
  • 2005/5/20 12:13

  • asche

  • Not too shy to talk

  • Posts: 116

  • Since: 2004/4/5 9


I would like to use a better tool for database administration (remote "web-administration" would be great, but I suppose it is not allowed by host provider, so I am also interested in tools working locally).

requirements:
- db-export
- table-export
- query-result-export (do a query and export result in - window or in file -< that would be great).
- possibility to work in more than one window (phpadmin allows only one active window for querying!?) with queries against database (nice would be to work on ten different "query-windows").

Anybody knows a good db-admin tool?

2
bluenova
Re: database administration tool - alternative for phpadmin?

EMS?? If your host will let you connect remotely

3
asche
Re: database administration tool - alternative for phpadmin?
  • 2005/5/20 14:04

  • asche

  • Not too shy to talk

  • Posts: 116

  • Since: 2004/4/5 9


thanks for info about EMS.

I posted this question at my host surpass.
http://www.surmunity.com/showthread.php?p=118675#post118675

Looking for a possibility of remote administration of the MySQL database [URL=https://xoops.org/modules/newbb/viewtopic.php?topic_id=20137&forum=13&post_id=152734#forumpost152734]for a long time already[/URL] I found EMS MySQL Manager:
http://sqlmanager.net/products/mysql/manager/download

Now I would like to know if I can use this tool for my online database at surpass as well? I very much hope so, because I need alternatives to being limited to only one "query-window" (like in phpadmin).

So my requirements - as posted [URL=https://xoops.org/modules/newbb/viewtopic.php?post_id=157690&topic_id=36284&forum=20#forumpost157690] in http://www.XOOPS.org Forum as well[/URL] in http://www.xooops.org - are:
- db-export
- table-export
- query-result-export (do a query and export result in - window or in file -< that would be great).
- possibility to work in more than one window (phpadmin allows only one active window for querying!?) with queries against database (nice would be to work on ten different "query-windows").

So hopefully surpass thinks EMS is beautiful ))

best regards asche

4
asche
Re: database administration tool - alternative for phpadmin?
  • 2005/5/20 20:44

  • asche

  • Not too shy to talk

  • Posts: 116

  • Since: 2004/4/5 9


All right, somebody in surpass forum repeplied, that it is possible to use EMS at the host.
http://www.surmunity.com/showthread.php?p=118704#post118704

But now, having installed EMS locally, I can only register databases locally (It does not offer a web connection to my host).

my question:
Can I use the advantages of EMS also on my host (how dow I have to congigure/install ?) or is it tool for running locally.

Where is the button for the remoteconnection? If I know where the button is, I can ask my host for the service.

Looking forward for more advice for "pushing queries against database remotely".

Best regards

asche

5
asche
Re: database administration tool - alternative for phpadmin?
  • 2005/5/26 11:28

  • asche

  • Not too shy to talk

  • Posts: 116

  • Since: 2004/4/5 9


looking for possibilities to export and import resultsets
from my database host I try to install EMS MySql Manager:

http://sqlmanager.net/products/mysql/manager/download

Following problems occured trying to connect to the remote database:
I can connect with EMS (http-tunneling ?) with url
http://...ip...:2082/3rdparty/phpMyAdmin/index.php all right,
but I receive error http: mailformed responce < doctype html public ..."

I use the same connection parameters as in links below with following exeptions:
port: 2082, http address, user: user_name, db: db_name:

1.
http://sqlmanager.net/products/mysql/manager/documentation/hs1480.html
Edit Database Registration Info
-> Question: Port 3306 is default -> must I set port 2082 like in url (I tried both, but error is the same "mailformed responce")
http://...ip...:2082/3rdparty/phpMyAdmin/index.php?

2.
http://sqlmanager.net/products/mysql/manager/documentation/hs1540.html
Setting HTTP tunnel options


These questions I asked at surpass hosting and basically got the answer:
"The program will not be installed on the server since it is not supported by cpanel. You will need to make sure when connecting this software that you add your local ip address to the MySQL section of your cpanel. You may also need to add new users to your database if this program requires a username and password".

Can anybody put together the pieces how I con conect to my remote database with EMS MySql Manager?

6
tedsmith
Re: database administration tool - alternative for phpadmin?
  • 2005/5/26 13:07

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


The best tool I've ever encountered is the fairly new 'MySQL Administrator'. It is superb! I'm not sure if it can connect remotely - never needed to to use it for that. I'm sure it could but it's whether your web host would allow it. As a local tool though - it rocks! We use it on our Server to maintain our internal Intranet MySQL database. It also has backup and restore options using various encoding and stuff.

Check out this beautfiul piece of free software here :

http://www.mysql.com/products/administrator/index.html

7
asche
Re: database administration tool - alternative for phpadmin?
  • 2005/5/26 13:52

  • asche

  • Not too shy to talk

  • Posts: 116

  • Since: 2004/4/5 9


thanks tedsmith,

I tried MySQL administrator in the meantime and I can ping the db server allright (parameters seem to be allright).

But I receive error:
Could not connect to the specified instance
mySQL error number 1045
access denied for user ...

So I would be able to establish the remote connection, but I lack privileges. Is anybody administering his remote database with tools other then phpadmin in a shared hosting environment? Or is it the same company policy everywhere and I must look for dedicated hosting then?

Is there any better remote alternative for phpadmin possible?

8
bluenova
Re: database administration tool - alternative for phpadmin?

EMS works fine on surpass, I use it on surpass. You just have to setup an Access Host (your local ip address) in cpanel (under databases, near the phpmyadmin link), and then use the ip address of the server you are on with your cpanel username to connect to the database like:
100.100.100.100/~cpanelusername/
I think that is correct, I'll check when I get home tonight and correct if it's wrong.

9
bluenova
Re: database administration tool - alternative for phpadmin?

Just read your above post regarding MySQL administrator, it's not letting you access it, because you havn't setup the access host in cpanel, as described in my above post.

10
mlynch
Re: database administration tool - alternative for phpadmin?
  • 2005/5/26 15:58

  • mlynch

  • Just popping in

  • Posts: 3

  • Since: 2005/5/25


Well, if you know what you're doing with MySQL, you can make your own web based MySQL command line. I found the following article VERY helpful.

http://www.sitepoint.com/article/give-back-mysql-command-line

Login

Who's Online

252 user(s) are online (58 user(s) are browsing Support Forums)


Members: 0


Guests: 252


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits