CODEWITHSUNDEEP
mysqlbackupinnodb
BrownChiLD
BrownChiLD

Reputation: 3713

Reinstalling WAMP, file backup MySQL database w/ InnoDB tables = FILE COPY ok?

I need to do a fresh install of WAMP. Files and other settings are easy to backup/reconfigure, but I have a question regarding MYSQL.

I used to simply COPY a backup of the mysql folder structure , data, and everything...

But w/ this project i'm using INNODB tables , and i've read that SIMPLY COPYING the data folder wont work w/ InnoDB, and will be pront to corruptions and such..

but I'm copying the wHOLE mysql folder , bin, data and all. can't that work as well?

I dont understand why that can't work because, everything MYSQL needs to run normally is there in the MySQL folder w/c im copying completely, not just the DATA folder.... and as far as i know MYSQL doesnt have any other dependencies like REgistry settings or windows system file or other external stuffs to run normally -- DATA/Tables wise.

so if my above assumptions are correct, then backing up my database/tables by copying the WHOLE mysql folder = 100% ok , yes?

Now i know there are other ways to backup database, like mysql Dumps and other stuff, but that's a lot of work vs just copying the darn thing, since i have access to the root anyway.

please advise. thanks

Upvotes: 2

Views: 1230

Answers (2)

frozenfire
frozenfire

Reputation: 81

Yes you can copy MySql Folder. For the InnoDB tables there is one log file inside mysql>>data folder. Do not forget to move log file "ibdata1" inside your newly installed XAMPP/WAMP data folder, the tables will work. MyISAM tables will not cause any problems at all. Best of luck !!

Upvotes: 1

Tpojka
Tpojka

Reputation: 7111

Even when is deinstalling, files that are not installation files eg. newly created files in process of work with projects will NOT be deleted. I had situation today that WAMP stopped because of some error with wampserver.ini file. There was no chance to restart it. As I am currently in the middle of project, I needed right WAMP installation as fast as possible. I made whole backup of C:\wamp folder, and started deinstallation. After that all files with full folder up tree was there: WWW, bin\mysql\mysql5.x.xx. But there is mismatch with MySQL versions so this could be solution - installing previous version of MySQL and backup all DBs. I think I am going to do that after current work.

Upvotes: 0

Related Questions