My MySQL databases appear to have been overwritten somehow, and I am
very distressed about this. Please tell me that there is a way to
recover this data.
I am using Mac OS X, and recently upgraded to PHP 4.2. I have been
accessing MySQL from PHP and phpMyAdmin for a while, occasionally using
the command line as well. I don't recall making and dramatic changes to
any of these files recently.
When I went to my web site today, I saw the error message 'could not
select database'. When I checked out the databases in MySQL, this is
what I got:
mysql> show databases;
+---------------------+
| Database |
+---------------------+
| CarbonUFSVolumeInfo |
| mnta |
| mntb |
| vi.recover |
+---------------------+
4 rows in set (0.04 sec)
What could have happened here? Did I delete a crucial file? Did it
somehow get overwritten? I used to have four databases.
Any help you can provide would be appreciated. I don't know what other
information would be helpful, but will do my best to provide it if
anyone asks.
Thank you,
Greg Westin
greg@stripped