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,
Joe

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
[dev.mysql.com]

mysqldump — A Database Backup Program
[dev.mysql.com]

Example Backup and Recovery Strategy
[dev.mysql.com]


phpMyAdmin Wiki References

Dumping data
[wiki.cihar.com]

import data
[wiki.cihar.com]

export data
[wiki.cihar.com]

Options: ReplyQuote


Sorry, only registered users may post in this forum.