fatal error problem

[paulsra]

hi all,
i believe i have a problem with my database, i get the following error:

Fatal error: main() [function.require]: Failed opening required 'C:\Inetpub\useddirtbikesreal\' (include_path='.;c:\php\includes;C:\Inetpub\useddi rtbikesreal\includes\classes\pear') in C:\Inetpub\useddirtbikesreal\includes\init.php on line 0

if i point the script (3.1 designer) to a fresh database it works fine. the problem is iv spent months on the db thats not working.

im working on a local server with win2003.

please help as this is killing me, once this is sorted, i think i might go with the hosted version!

thanks
Paul

[Lhotch]

It can sometimes be pretty tough to troubleshoot a problem based on an rror reporte by the script.

Has this install ever worked?

If so, then what have you done since the time and worked and the time you noticed the error?

Databases dont generally just go bad.

[paulsra]

its been working great with no problems.
about the time it happened i installed a website analizer script called logaholic, but there were no changes to the 68 script. i have since removed that db to be sure there were no conflicts. but the site was working fine after i had installed logaholic anyway..

thanks for your quick response

[Lhotch]

Unfortunatly, I dont know what to tell ya. The error seems to indicate problems with the script accessing a file, but if you said you can point it to a new database and it works, then that likely isnt the problem.

The fact that a new db works fine also leads me to beleive there is no problem with the scripts either and its likely you just may have a corrupt database or somehow deleted a needed record. Do you have a backup of your live database you can restore and try? If not, then it looks like your out of luck as far as your data goes.

[paulsra]

is there ay way i can compare two databases to find any differences other that the content, eg; pages?

[Lhotch]

I guess that depends on what database server your using and how familiar you are with database management. If your using mysql for example you could use the mysqldump program which will dump the whole database to a text file. Do this for your 2 databases and compare the contents of the files.

[paulsra]

im currently using 'mysql administrator' from the mysql site, to manage the databases. but it dosnt seem to be able to transfer tables between db's.

if i could transfer the 'pages' table and mabee a couple of others this would b good enough to get me up and running.

i dont think the mysql administrator does this,

can this be done?

[Lhotch]

you can edit the mysqldump file so that it just includes the tables that are damaged and then import it with the mysql command line tools.

[paulsra]

i sorted it out.

the currency table in he db was corrupted....somehow.
i simply dropped that table and now all is well.

thanks for all your help.