1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Help I deleted the connection strings from my database

Discussion in 'Programming' started by tech4, Jul 31, 2009.

0
  1. #1
    I deleted these connection strings from my database for allfoodmenu.com

    I don't know how to add them back in. The sql file is allfoodm_food.

    This is the string I deleted without making backup of the file. Site not working.

    Users in food
    allfoodm_aston (Privileges: ALL PRIVILEGES)

    Connection Strings
    Perl $dbh = DBI->connect("DBI:mysql:allfoodm_food:localhost",
    "allfoodm_aston","<PASSWORD HERE>");
    PHP $dbh=mysql_connect ("localhost", "allfoodm_aston",
    "<PASSWORD HERE>") or die('Cannot connect to the database because: ' . mysql_error());
    mysql_select_db ("allfoodm_food");

    allfoodm_travel (Privileges: ALL PRIVILEGES)

    Connection Strings
    Perl $dbh = DBI->connect("DBI:mysql:allfoodm_food:localhost",
    "allfoodm_travel","<PASSWORD HERE>");
    PHP $dbh=mysql_connect ("localhost", "allfoodm_travel",
    "<PASSWORD HERE>") or die('Cannot connect to the database because: ' . mysql_error());
    mysql_select_db ("allfoodm_food");


    How do I add these back ? I don't know how!
     
    tech4, Jul 31, 2009 IP
  2. tech4

    tech4 Well-Known Member

    Messages:
    544
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    125
    #2
    Thanks...I didn't know it was that easy.

    But what I did was upload latest .sql without users/privileges and on the server old prehistoric .sql, same file name, different content with users/privilages. Guess what?somehow the host or the server merges these, now everythings works.
     
    tech4, Aug 1, 2009 IP