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:<br /><br />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.<br /><br />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:<br /><br />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?<br /><br />- Jez<!--content-->
Theres a lot of scripts on Hotscripts that give a gui interface to creating tables and managing mySQL db's.<br /><br />I have tried a few but alas phpMyAdmin is still the daddy.<br /><br />Might be worth checking them out though incase one does something that is beneficial for you.<br /><br />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.<br /><br /><img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->
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.<!--content-->
<!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->and needs to be updated daily because of constantly changing information.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />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.<br /><br />As to the rest of your question, I'm not sure I understand.<br /><br />I have a huge database with many tables running a ten thousand page site at TCH... phpAdmin seems to work just fine.<!--content-->
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. <br /><br />What it IS good for:<br />populating data in the tables from an Access built front end for users<br />exporting basic table designs and data from Access to MySQL<br /><br />What it's not good for:<br />changing the table/field properties after created in MySQL<br /><br />Hope that helps.<!--content-->
Theres a lot of scripts on Hotscripts that give a gui interface to creating tables and managing mySQL db's.<br /><br />I have tried a few but alas phpMyAdmin is still the daddy.<br /><br />Might be worth checking them out though incase one does something that is beneficial for you.<br /><br />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.<br /><br /><img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><!--content-->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.<!--content-->
<!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->and needs to be updated daily because of constantly changing information.<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />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.<br /><br />As to the rest of your question, I'm not sure I understand.<br /><br />I have a huge database with many tables running a ten thousand page site at TCH... phpAdmin seems to work just fine.<!--content-->
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. <br /><br />What it IS good for:<br />populating data in the tables from an Access built front end for users<br />exporting basic table designs and data from Access to MySQL<br /><br />What it's not good for:<br />changing the table/field properties after created in MySQL<br /><br />Hope that helps.<!--content-->