Using mysqlfrm against XAMPP installed mySQL
Posted: 31. July 2019 14:54
Has anyone every got mysqlfrm to work when spawning a mysql process via mysqlfrm when mysql was installed via xampp?
https://community.apachefriends.org/f/
https://community.apachefriends.org/f/viewtopic.php?f=16&t=78354
mysqlfrm --diagnostic "C:\backup_copy\mydata\stuff.frm" > "C:\to_restore\mydata\stuff.sql"
mysqlfrm --diagnostic "C:\backup_copy\mydata\address.frm" > "C:\to_restore\mydata\address.sql"
mysql -u root --password=<yourpassword>
create database `mydata`;
exit
mysql -u root --password=<yourpassword> mydata < "C:\to_restore\mydata\stuff.sql"
mysql -u root --password=<yourpassword> mydata < "C:\to_restore\mydata\address.sql"
ALTER TABLE `mydata`.`stuff` DISCARD TABLESPACE;
ALTER TABLE `mydata`.`address` DISCARD TABLESPACE;
ALTER TABLE `mydata`.`stuff` IMPORT TABLESPACE;
ALTER TABLE `mydata`.`address` IMPORT TABLESPACE;