Breaking News: Grepper is joining You.com. Read the official announcement!

how to take backup of mysql database in xampp

Ahmed answered on September 30, 2021 Popularity 9/10 Helpfulness 2/10

answer how to take backup of mysql database in xampp

how to take backup of mysql database in xampp

Comment


There is Two way to backup your database
One:Folder backup In windows go to xampp installation folder xampp> mysql > data > here you find your database name folder. copy it and save it .
you can use any other computer just go to xampp installation folder xampp> mysql > data >paste it here.
Note: You should not overwrite the MySql default folders and only overwrite 3 files

    ibdata1
    ib_logfile0
    ib_logfile1

others should remain as default. Thanks otherewise you wont see your databases in PHPMyAdmin. Thanks
Two:export database .sql backup In browser go to phpmyadmin and select your database >then in to the top mane click Export. then write a name in New template input box .then click go .you will find a file is down loaded.
you can use it any other computer then go to phpmyadmin in browser and create a database and on the top menu click Import click choose file > select this file witch is downloaded > then click go button.

Popularity 9/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: backup database mysql sql take xampp

Link to this answer
Share Copy Link

Contributed on Sep 30 2021

Ahmed

0 Answers Avg Quality 2/10

how to take backup of mysql database in xampp

Contents

More Related Answers

how to take backup of mysql database in xampp

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.