Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best way to move a database

Status
Not open for further replies.
JezEling

JezEling

IS-IT--Management
Mar 22, 2004
127
GB
Hi All,

Can anyone tell me the best way to move a database from a Linux machine to a Windows machine?

The linux machine is running MYSQL version 3.23.54 and the Windows machine is running MYSQL version 4.0.17.

Many thanks in advance

Jez
 
Sort by date Sort by votes
Use mysqldump to dump the database to a text file, then use mysql to execute the file on the Windows machine.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Colin Burton
  • Locked
  • Question
Sending A a video clip to either a web server or MySql Database
Replies
2
Views
170
Colin Burton
Colin Burton
EdLentz
  • Locked
  • Question
How do I use a keyword in a query??
Replies
6
Views
545
EdLentz
EdLentz
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
440
EdLentz
EdLentz
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
490
spamjim
spamjim
Arthur Lewis
  • Locked
  • Question
Backup Mysql database to client machine
Replies
2
Views
172
Arthur Lewis
Arthur Lewis

Part and Inventory Search

Sponsor

Back
Top