How to access data table on another local drive

Problems with the Windows version of XAMPP, questions, comments, and anything related.

How to access data table on another local drive

Postby scott1137 » 21. August 2010 16:03

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
scott1137
 
Posts: 5
Joined: 21. August 2010 15:55

Re: How to access data table on another local drive

Postby JonB » 21. August 2010 17:43

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. :?:
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: How to access data table on another local drive

Postby scott1137 » 21. August 2010 18:38

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
scott1137
 
Posts: 5
Joined: 21. August 2010 15:55

Re: How to access data table on another local drive

Postby scott1137 » 21. August 2010 20:56

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
scott1137
 
Posts: 5
Joined: 21. August 2010 15:55

Re: How to access data table on another local drive

Postby scott1137 » 21. August 2010 21:08

That worked!
Thanks all.
Scott
scott1137
 
Posts: 5
Joined: 21. August 2010 15:55

Re: How to access data table on another local drive

Postby JonB » 22. August 2010 03:29

Good job Scott :mrgreen:

Give yourself a toast with whatever feels good for you!
:D
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: How to access data table on another local drive

Postby scott1137 » 22. August 2010 04:42

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
scott1137
 
Posts: 5
Joined: 21. August 2010 15:55


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests