Mysql

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
EmadGirgisAsked:
Who is Participating?
 
johanntagleConnect With a Mentor Commented:
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/
0
 
mansooralia_yahooCommented:
try phpmyadmin, and then exporting, select stored procedures too in the check box
0
 
EmadGirgisAuthor Commented:
It appeared to be the easiest way to shutdown the database and move the data directory

Thanks
0
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.

All Courses

From novice to tech pro — start learning today.