开发者

phpMyAdmin import Database that is missing!

开发者 https://www.devze.com 2023-01-23 15:42 出处:网络
My sql database in phpMyAdmin is gone but i kept the files in the directory of xampp/mysql/data/mydatabase with extensions like .MYD .MYI .frm .opt...

My sql database in phpMyAdmin is gone but i kept the files in the directory of xampp/mysql/data/mydatabase with extensions like .MYD .MYI .frm .opt...

the thing is when i try to open it in notepad++ to see the information they seem corrupted or damaged. Then i've tried to import these files directly to the database through phpMyAdmin, but again with no results because it's full of syntax errors...

Can someone tell me how开发者_如何学Python to solve this?

Thanks in advance!


Back the files up (back up the entire directory structure just in case), recreate a database with the same name (destroying the files), stop mysql, replace the files, start mysql.

Make sure you keep your backup in case things go wrong!

0

精彩评论

暂无评论...
验证码 换一张
取 消