Transfer mysql database to a new server using phpMyAdmin
Date: 26th July, 2010
- Assuming you’re inside phpMyAdmin, select the database you want to move.
- Hit the’Export’ tab.
- ‘Select all’ to export every table.
- Make sure the ‘Structure’ and ‘Data’ boxes are ticked.
- Select ‘Drop table if exists’.
- Select ‘Save to file’ at the bottom, and change the name if necessary.
- Hit ‘Go’.
