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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 12, 2004 4:05 PM
Subject: [PHP-DB] 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
> --
> [EMAIL PROTECTED]
> 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
