Backing up mysql database in xampp?

Question

Hi everyone, I recently created a database, and our professor told us that we can make a copy of the database by copying the folder to xampp / mysql / data.

Then, after I made my database, I copied my database folder, because I continue to keep the database bad on another computer. It turns out that copying this folder is not enough, because it turns out that it can only read the database, but not the contents of the tables in the database.

The contents of the database folder "tablename" .frm and "db.opt"

Can someone teach me the proper way to back up a database? and what files do I need to copy to run the database that I made on another computer.

I already read this, but I can’t understand the instructions correctly (if ever this is the right way to back it up)

http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html

Thanks, advanced!

Answer 1

On the local screen for XAMPP (inside your browser), go to PhpMyAdmin (left) and select "MySQL". See your database in the upper left corner, make sure that it is selected. A menu tab will appear on the central screen, in which there is an Import tab and next to it is Export. Click the "Export" tab. Here you will need to select all the tables that you want to include in the backup, as well as set the name and location for the backup file (believe that the default download file). Be sure to also make sure that the backup file type is selected. e.g. sql file etc.

After creating this backup, you can simply import it again into XAMPP in your browser. should be relatively easy. Hope this helps.

Answer 2

Use the export function in phpMyAdmin http://codex.wordpress.org/Backing_Up_Your_Database

Answer 3

There are two ways to back up a database.
One: backup the folder In Windows, go to the xampp folder to install xampp> mysql> data> here you will find your folder with the database name. copy it and save.
you can use any other computer, just go to the xampp folder to install xampp> mysql> data> pest it here.
Two: export the .sql backup database In the browser, go to phpmyadmin and select your database> then click "Export" in the upper mane. then write the name in the input field of the new template. then hit go. You will find that the file has been uploaded.
you can use it on any other computer, then go to phpmyadmin in your browser and create a database, and in the top menu click Import, select select file > select this file to be downloaded> then click go .