Migrate fr MySQL only to WAMPServer
Posted by: lakesurfer (---.bna.bellsouth.net)
Date: September 24, 2006 12:44AM

I am just getting started. I've loaded MySQL 5.0 on my XP machine, and developed a database. I just discovered WAMPServer, and really want to install and use it, but I'm concerned about the possibility of installing two instances of MySQL. Further, I'd really prefer not to lose the database structure and data that I've already entered.

What should I do to migrate to WAMPServer and preserve my database structure and data?

Thank you,

Options: ReplyQuote
Re: Migrate fr MySQL only to WAMPServer
Posted by: CyberSpatium (67.170.181.---)
Date: September 25, 2006 09:59AM

use mysqldump. if you are not comfortable using the command line, you can use phpmyadmin to export and import data. just remember when you use phpmyadmin to export your database you select the box to also include all your data.

mysqldump References:

Copying MySQL Databases to Another Machine

mysqldump — A Database Backup Program

Example Backup and Recovery Strategy

phpMyAdmin Wiki References

Dumping data

import data

export data

Options: ReplyQuote

Sorry, only registered users may post in this forum.