title: Move MySQL schema
body: <p>We have a Linux server that has been running our MySQL 5.1 server.  For a variety of reasons we have created a new MySQL5.5 server.  What is the easiest and most efficient way to move an entire schema from the Linux 5.1 MySQL to the Windows 5.5 MySQL database?</p>
  
  <p>Yesterday I looked into exporting the resultset of the query as a csv and using the LOAD DATA INFILE command but that didn't work correctly.  The dates didn't import correctly, there were nulls where there should have been data, I didn't look too closely at exactly what was wrong, just could tell it wasn't right.</p>
  
  <p>This would be a one time operation.</p>
  
  <p>Thanks,
  leslie</p>