Web developer, Norwich - Clive Portman

Copy MySQL database over to a new server

Published under MySQL

Published on Monday 26th July 2010
  1. Assuming you’re inside phpMyAdmin, select the database you want to move.
  2. Hit the’Export’ tab.
  3. ‘Select all’ to export every table.
  4. Make sure the ‘Structure’ and ‘Data’ boxes are ticked.
  5. Select ‘Drop table if exists’.
  6. Select ‘Save to file’ at the bottom, and change the name if necessary.
  7. Hit ‘Go’.