Easier Way To Modify/create Mysql Databases?

[Jezuit]

First of all, I'm sorry if this is the wrong forum for this particular question, but I wasn't sure at any rate. With that said, let me proceed with my question:

 

cPanel is a great way to manage most everything that goes on with my website. I only recently joined TCH, but the support and service is outstanding to date.

 

The only thing I have actually found that quite bugs me is handling all MySQL functions (creating databases, tables, rows, etc. etc.). I do understand how to do it using cPanel, but I need to create a database that is quite large with many tables, and needs to be updated daily because of constantly changing information. Using the tool that cPanel provides, I could be spending a few hours a day doing what should only take about half an hour maximum. With this in mind, my question:

 

Is there any way at all to use a tool (such as MySQL Control Center, or regular old telnet) that connects to a specific database for editing?

 

- Jez

[Digirunt]

Theres a lot of scripts on Hotscripts that give a gui interface to creating tables and managing mySQL db's.

 

I have tried a few but alas phpMyAdmin is still the daddy.

 

Might be worth checking them out though incase one does something that is beneficial for you.

 

If there is a quick work around I'd also be interested in knowing because this is all uncharted territory for me and is provnig a bit complicated.

 

[Jezuit]

Well, I don't mean a GUI editor or a PHP editor for MySQL necessarily, I mean being able to connect to the server from my work directly and edit it through good 'ol telnet. So basically, a way to access the host remotely, instead of using third party software to act as an unecessary intermediary.

[surefire]

and needs to be updated daily because of constantly changing information.

 

This part will best be done by a php, cgi, or some other server side script and then set up to run automatically using cron job.

 

As to the rest of your question, I'm not sure I understand.

 

I have a huge database with many tables running a ten thousand page site at TCH... phpAdmin seems to work just fine.

[Lianna]

I recently posted here about using MyODBC to create a channel from Access running on my local PC to a MySQL db. With the exception of having to set the indices on the tables, it works just dandy. Do a search of the forums here for MyODBC to find my post.

 

What it IS good for:

populating data in the tables from an Access built front end for users

exporting basic table designs and data from Access to MySQL

 

What it's not good for:

changing the table/field properties after created in MySQL

 

Hope that helps.