I can FTP and telnet in to my site as "admin" or a user, but all the files in /var are owned by root so cannot be deleted, with the exception of several mysql files owned by mysql, which I also cannot move or delete :( If I could extract the info in the database I could delete that remotely, then restore it after I get root access back again, but as it is now marked corrupt I can't seem to do anything with it. Is there any way of fixing a database with zero room on the partition it is in?
> > I`ve got myself into a bit of a mess by allowing my raq3's 200mb var > > partition > > to fill up. This means I can no longer login to my server as root, > > because a > > log file of my login cannot be created. Naturally only root can delete or > > move any files in /var to fix this problem :o Anyway, this caused my > > MySQL > > database which was also in /var have problems, and before realising that > > disk > > space was the cause, I tried to repair the database using the repair > > command. > > Now I have a corrupt database that I cannot export due to "Error: Cannot > > open > > database.MYD", and I cannot copy the actual data files on the server due > > to > > lack of permissions. Is there anyway I can get around this? If I delete > > the > > database I should have enough room to login as root again, but I`d really > > rather have a copy of the database before doing this. > > Just a offshot guess here, can you ftp in and delete a file? > > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php