Copy Mysql Tables

How to copy all mysql tables to a pendrive and install it on another machine ?
Jose BredariolPMPAsked:
Who is Participating?
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
After you install MySQL on the other machine, you can dump the all the databases and move them to the new server.  This page tells about 'mysqldump': http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
0
 
karunamoorthyConnect With a Mentor Commented:
Hello jbredariol,

The simplest way is
Copy the mysql data files (i.e the files are usually located in mysql->data->dbnamefolder

For example you have installed your mysql in c:\mysql folder and the dbname is mydb then

just copy all the files in c:\mysql\data\mydb to your pen drive and copy the same files to your destination and ofcourse that is to copy to mysql/data/dbname folder.

I hope you got it.

from
karunamoorthy.-
0
 
bimal_linuxConnect With a Mentor Commented:
Hi,
Please shutdown the mysql server before copying mysql files. This will help to prevent file corruption at destination server.
Various mydql backup methods are described at: http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html

Regards,
Bimal Mankara
0
 
Jose BredariolPMPAuthor Commented:
Thanks all
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.