Help I deleted the connection strings from my database

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

  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