Apache Friends Support Forum

I've dropped a table and now can't log in to site via phpmysql. I want to find the dropped table on the backup on my local computer.

I have XAMPP installed on my c: drive (XP pro) to use with other local sites. However it is not configured to access this backup site. How do you suggest I do this? Also, There is phpmysql folder in the backup folder as part of the backed up site. Have not figured out how to get to that via localhost.

Thanks,

Scott

Have not figured out how to get to that via localhost.

You probably can't.

How did you make the backup? and where is it located?

I sure hope that 'backup' you are referring to was a 'real' MySQL backup, not merely a copy of some folders, but we will have to wait for your answers.

Thank you.

It is on an external hard drive. I backed up both the folders and backed up the database from php/myadmin. It is a .sql file

Duh. I can open and search for the 'dropped' table in text editor.

Next steps as I understand them - I'm pretty new at this so please advise if I'm messing something up:
1.Find the part that creates the missing table (I have the name from following this procedurehttp://docs.joomla.org/How_do_you_recover_your_admin_password%3F.
2. Post it into PHPMyAdmin.
3. pray it works/that there are no other missing tables.
Scott

That worked!
Thanks all.
Scott

Good job Scott

Give yourself a toast with whatever feels good for you!

Thank you, JonB, for pointing me in the direction of the actual file. I couldn't see the tree for the forest. Once I looked at the file I remembered I could get to it via text editor, etc...
Scott