Hi Matthew, Before I started using phpMyAdmin, I didn't want anything to do with it. :-) But now I find it to be nice for quick things like browsing tables, quick edits, table statistics, etc. For queries that return large amounts of text, it's MUCH more legible than the command line. :-)
Keep in mind though that it totally *SUCKS* for backing up and restoring any but the smallest databases -- because of PHP time-outs, memory limits, file upload limits, etc. The only [reliable] way to go is using mysqldump and mysql from the command line -- through the shell. So yeah, it's really a good idea to have shell access for backup/restore. Else you'll have to ask the host to do it. A pain, if they'll even do it. :-) Matt ----- Original Message ----- From: "Matthew K. Gold" Sent: Thursday, September 04, 2003 6:32 PM Subject: web hosting/PHP MyAdmin > Hi, > > I need to move my site to a host that supports PHP and MySQL. I found a > nice deal that provides a lot of good stuff for an affordable price > (sitelutions.com is offering 5 MySQL databases, PHP support, cgi, etc etc > for $9.95/month). > > There's only one problem--they don't allow you to edit the MySQL databases > through a shell--you have to use a web-based control panel and phpMyAdmin. > > My problem is that I'm used to editing my MySQL databases through the shell, > and I find the phpMyAdmin admin kind of confusing. > > I have two questions: > > 1. Was anyone out there in my position before, but then once you tried > phpMyAdmin, you found that you liked it a lot? > > 2. Does anyone know of any better, or equal deals out there that also allow > shell access? > > Thanks very much in advance for your help. > > best, > > Matthew Gold -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]