I would start by seeing if the files are there after you create/load the table. It should by default create a file for each table you create. Sounds to me like a problem reading the disk. If you don't find any answers on your own, post your system specs to the MySQL lists. You could also try verbose debugging options, I've never used any debugging, but here's how to do it in mysqladmin. --debug[=debug_options], -# [debug_options] Write a debugging log. The debug_options string often is 'd:t:o,file_name'. The default is 'd:t:o,/tmp/mysqladmin.trace'. -Jeff ----- Original Message ----- From: "Bill Green" <bill@xxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Wednesday, May 12, 2004 4:05 PM Subject: mysql went away > HI. I've been using mySQL 4.0.13, php4.3.4, and phpMyAdmin2.5.5 on Mac > OS 10.3.3 as a learning/testing/development environment for a couple of > months now - no problems, works great. > > I've created more than a few mySQL databases and tables, but yesterday > I created a database, a table, and LOAD DATA from within phpMyAdmin. > Successfully. I looked at the data and all was fine. Logged out and > went away for a while. Came back and phpMyAdmin would not show me my > databases in the left frame, and I could not launch a query window. I > could see runtime information, system vars, processes, and even > privileges. > > I tried logging in to mySQL through the terminal, and I can run simple > commands and connect OK, but any commands to show databases or tables > will hang the terminal. Through the command line client I can run > simple commands, but no commands to view or affect databases or tables. > > I can run php scripts - connect to databases, retrieve and even > insert/update data, but I cannot view databases or tables. > > Does anyone have a clue about what the problems may be or where I > should start? > > --- > Bill Green > 20 Meadowview Drive > Asheville, NC 28804 > -- > bill@xxxxxxxxxxxxx > http://www.billgreen.org > 828.252.1492 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
