Return to site

Mysqldump windows install

broken image

To restore your files run a dos command prompt again to the xampp/mysql/bin command prompt and typeĬ:\xampp\mysql\bin>mysql -u root -p openemr < C:dumpfile.sql It will run awhile and produce your backup file dumpfile.sql in the c:directory When you go to restore it in the new xampp, you open up the database in phpmyadmin and at the bottom of the list, check all, and use the drop down list to empty the data files. Then from the command prompt C:\xampp\mysql\bin>mysqldump -u root - p -databases openemr> C:\dumpfile.sql Enter your root passord here: Open a windows dos command prompt and enter: CD C:\xampp\mysql\bin

broken image

The restore commands would need to be linux instead of windows commands I guess. The basic idea is to mysqldump your database and copy your sites/default directory to your new installation. I think it would be exactly how I went to the new xampp as outlined below and in this forum. Cverk wrote on Sunday, September 09, 2012:

broken image