Hello Alex!
Thanks for replying!
My problem is creating a new database. I have droped all the tables. So the database is empty. Now if I run the SQL.pl it should also create all the new tables within the existing database with no tables, isnt it? Second problem is why does not the SQL.pl run? It always says compilation errors. In my earlier thread I have listed the lines or errors. I do not understand why. Because I give
>perl SQL.pl
gives compilation errors in lines 25,29,35,....
Or if I try,
> perl -de SQL.pl
It gives the same errors.
It does not give any result. However now I have request for a special attention for creating a new database and start from scratch. Will let know if creating a new database works. Actually, the three "Holy Mantras" you gave me was really to the point when I hunted madly to find out what did you mean and once I did it was not complicated at all to do them.
My second problem is my provider does not allow admin on MySQL for security reasons! Let them create and drop.
Anyway, Thanks Mr. Pataki! Yes, there has to be something that I have overlooked. You are most probably right. You know sometimes I do make such mistakes. But now I have chanted the "Three Holy Mantra of Alex" so many times that even if I made a mistake I myself would not realize!!! So actually its good to write to you and discuss, most of all, asking myself have I done correct before wasting the time of yours or Alex.
------------------
rajani
Thanks for replying!
My problem is creating a new database. I have droped all the tables. So the database is empty. Now if I run the SQL.pl it should also create all the new tables within the existing database with no tables, isnt it? Second problem is why does not the SQL.pl run? It always says compilation errors. In my earlier thread I have listed the lines or errors. I do not understand why. Because I give
>perl SQL.pl
gives compilation errors in lines 25,29,35,....
Or if I try,
> perl -de SQL.pl
It gives the same errors.
It does not give any result. However now I have request for a special attention for creating a new database and start from scratch. Will let know if creating a new database works. Actually, the three "Holy Mantras" you gave me was really to the point when I hunted madly to find out what did you mean and once I did it was not complicated at all to do them.
My second problem is my provider does not allow admin on MySQL for security reasons! Let them create and drop.
Anyway, Thanks Mr. Pataki! Yes, there has to be something that I have overlooked. You are most probably right. You know sometimes I do make such mistakes. But now I have chanted the "Three Holy Mantra of Alex" so many times that even if I made a mistake I myself would not realize!!! So actually its good to write to you and discuss, most of all, asking myself have I done correct before wasting the time of yours or Alex.
------------------
rajani
