Menu
I have changed my windows and I forgot to export from local databases fortunately I have installed xampp on another partition which windows is not installed on that,
in new windows previous xampp didn't start and I have installed it again Just I don't know how can I copy my databases (which I haven't backup and I don't have .sql file) in previous xampp to this version I have recently installed
464
1 Answer. You will get all databases at the "xampp/var/mysql". You can copy the complete folder to the new setup and it will show you all databases.
Open your browser and go to localhost/PHPMyAdmin or click “Admin” in XAMPP UI. Now click Edit privileges and go to Change Admin password, type your password there and save it. Remember this password as it will be used to connect to your Database.
The default database file location for server instances depends on the version of the Microsoft SQL Server software: SQL Server 2014 — C:\Program Files\Microsoft SQL Server\MSSQL12. MSSQLSERVER\MSSQL\DATA\ SQL Server 2016 — C:\Program Files\Microsoft SQL Server\MSSQL13.
say the old version of xampp on C partition, so go this path C:\xampp\mysql\data and copy all databases folders, then you should install the same old version of xampp on your machine to avoid the problems and errors with different versions then paste all folders in the data folder of the installed xampp and start your mysql server you will find all your databases and you can export them as you like.
104
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
