• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:


I run a database on mysql... I am running windows 7 and I need to back up the whole database including views, tables, data to another machine windows 7...
How to best do that
1 Solution
If your data is still small, mysqldump should do it.  See http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

If your DB is already in gigs and you can afford to shutdown your database:

1.  Determine your datafile directory by looking at my.cnf
2.  Shutdown both source and target databases
3.  Copy the full datafile directory including subdirectories
4.  Restart the databases

If you cannot afford to shutdown the source database, try Percona Xtrabackup - the windows version is still in Alpha though.  See http://www.percona.com/downloads/XtraBackup/XtraBackup-1.6/Windows-alpha/
try phpmyadmin, and then exporting, select stored procedures too in the check box
EmadGirgisAuthor Commented:
It appeared to be the easiest way to shutdown the database and move the data directory

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now