Migrate database

0

Colleagues.

We had a problem with a computer from which we had to format it, but we kept the files and had to reinstall the programs, among them Xampp. The folder that was left was c: / xampp, so we renamed it to c: / xampp_old and did the reinstallation.

The problem is with the database migration. We opened the folder c: / xampp_old / mysql / data / and copied the folders of the databases that were created before formatting and we threw to the folder that Xampp created c: / xampp / mysql / data /, but when we did this, mysql gives error, does not start.

How do we migrate the old xampp database to the new one?

    
asked by anonymous 17.06.2017 / 17:19

1 answer

2

Hello, I needed to perform a similar procedure and follow the solution I applied:

1 - I opened the Control Panel of my c: / xampp_old and started only the mysql service;

2 - Then I opened the Control Panel of my c: / xampp and starte Apache;

3 - I accessed the PhpMyAdmin from c: / xampp and connected to the MySql Base started in c: / xampp_old and I performed the Full Export of the Databases to .sql file;

4 - I made the export of the User accounts together with the access permissions of these banks and also saved in .sql file;

5 - I finished the PhpMyAdmin connection and stopped MySQL from the c: / xampp_old control panel;

6 - Started MySQL from the c: / xampp; Control Panel

7 - I accessed PhpMyAdmin and connected, this time you are connecting to the new MySQL;

8 - I executed the import of SQL first importing the Bank and then importing the Permissions;

9 - As I export Root User in my case my PhpMyAdmin lost the connection after the execution, being necessary to log in again, but already with the User and Password that I had configured in previous MySQL.

NOTE: I know the question was asked in time, but I hope it will be useful for anyone who needs to do this. In My case I did the same to update my entire Xampp framework to a newer version.

If someone has difficulty performing these processes in detail, he may return with questioning.

    
12.05.2018 / 19:07