Switching mysql data to mysql data?

phpmagic

I've been using wamp5 for about a year or so and I grew tired of it so I uninstalled it and went for a fresh install of apache2, mysql4, php4 and phpmyadmin.

Before I uninstalled WAMP5 I backed up c:\wamp\mysql\data so that I could keep all the database files. My question is, is it safe to just move all of that data into my new mysql installation c:\mysql\data\ ?

I did try this with one small database I had, and I could access it with my new phpmyadmin installation. But I was just wondering if it is an acceptable solution.

windows XP

tekky

if its worked for you... and you haven't had any problems.... whats the question? If you had no problems, then you already have you answer...

olaf

I have done this with bigger tables without problems with mysql 3.23.
A better way is to create backups using "BACKUP TABLE"

phpmagic

tekky wrote:
if its worked for you... and you haven't had any problems.... whats the question? If you had no problems, then you already have you answer...

The question? Is this acceptable regardless of whether it worked for me? Even though I can access (or see) the database with phpmyadmin doesn't mean to me that it might all work as well as it did before. Of course I can always test it all (including scripts that rely on my mysql databases) and see if it goes smoothly, but basically a question to whether anyone else has dealt with this issue can often save a lot of headaches to someone who has never done this before.

Anyway, now that I think about it the "backup table" method is what I should've done. Thanks

superwormy

This is in general NOT a good idea. A better idea is usually to do a dump of the databse with 'mysqldump' and then restore it later from the command line with the 'source /path/to/file.sql' command.