Import Database tables

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

Import Database tables

Postby dennisp » 13. April 2015 00:10

I have had a problem with xampp and can not access either MySQL or phpMyadmin. Although I have tried many of the fixes shown in this and other forums, I still cannot resolve the issues.

I have completed a new install of Xampp and wanted to know if I can import my previous database tables into the new install. The database tables appear to be intact . I was not able to export them before I lost access to phpMyadmin. I had also changed some of the privileges prior to losing access to phpMyadmin. I have details of those changes. I.e. Username and passwords.

Is it possible to import these database tables even though they have not been exported?

I can always rebuild the files but it would be useful to recover the information if possible. I am learning to use Mysql and phpMyadmin and really want to get it correct this time. Is there any documentation that I should be reading.
Thanks in advance
dennisp
 
Posts: 4
Joined: 10. April 2015 08:01
Operating System: Windows 8.1 64 bit

Re: Import Database tables

Postby Altrea » 13. April 2015 17:12

I would try the following:
- use the same version of xampp like the corrupted version
- copy over the \xampp\mysql\data\ folders of the databases you want to move over (only copy over your own created databases, NOT the default databases like mysql, phpmyadmin, etc)
- create the database users you need for your databases
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 152 guests