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

Copy Mysql Tables

How to copy all mysql tables to a pendrive and install it on another machine ?
Jose Bredariol
Jose Bredariol
3 Solutions
Dave BaldwinFixer 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
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.

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

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