How to backup database?
|
How to backup using MySQL GUI or MySQL Administration?
|
Windows 7 and 8
1. Open folder C:\ProgramData\MySQL\MySQL Server 5.5\data\. 2. Copy your database folder, example: “rdadb” or “rizal” or whatever folder name you assigned to your database. 3. Paste it to any portable storage device that you have, example USB Flash drive, or upload it to your Google drive. 4. To restore, just copy the database backup from source and paste it to the same location above. Windows XP Service Pack 3 1. Open folder C:\Document and Setting\All users\ProgramData\MySQL\MySQL Server 5.5\data\ 2. Copy your database folder example: “rdadb” or “rizal” or whatever folder name you assigned to your database 3. Paste it to any portable storage device that you have, example USB Flash drive, or upload it to your Google drive. 4. To restore, just copy the database backup from source and paste it to the same location above. |
Source: http://www.siteground.com/tutorials/php-mysql/mysql_gui_tools.htm
|