phpmyadmin Question posted in
The official documentation can be found here.

How to get MySql data from files without phpMyAdmin

My MySql was not working for 2 hours in xampp.

My logs are

01:37:11  [mysql]   Error: MySQL shutdown unexpectedly.
01:37:11  [mysql]   This may be due to a blocked port, missing dependencies, 
01:37:11  [mysql]   improper privileges, a crash, or a shutdown by another method.
01:37:11  [mysql]   Press the Logs button to view error logs and check
01:37:11  [mysql]   the Windows Event Viewer for more clues
01:37:11  [mysql]   If you need more help, copy and post this
01:37:11  [mysql]   entire log window on the forums

I have tried almost everything and nothing is working for me and I think I have also made my xampp settings even worse.

So now I will delete xampp and install again.

But wait, my databases are very important.

So is there by which I reinstall xampp and also I have all the databases I need.

I can’t start MySql
I can’t access phpMyAdmin

So how can I save my data from files?

Tags:

2

Answers


  1. 0

    You should open your sql files and look at the data, if it looks fine you can copy your backup folder into a recovery disk like F and reinstall it than copy the backup into your new data and replace new data with your backup you just copied, if the data is corrupt, well you need to go and try: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/myisam-table-maintenance.html But the thing is if it does not work than most likely you need to force INNODB reboots……

    Login or Signup to reply.
  2. 0

    Good luck trying "open your SQL files" (whatever those are).

    The answers as to why MySQL is not running are in your log files.

    Yes, you can back up the data files and restore them into a new installation.

    We can’t tell you where those files are – it depends on how you installed MySQL. This might be defined in C:Windowsmy.ini (you’re looking for files named .ibd and .frm).

    Make sure the MySQL service is stopped. Move the directory containing these file out of the way, then remove and reinstall MySQL. After that stop the (newly installed MySQL service) edit C:Windowsmy.ini to set the datadir to the ,oved files, and start mysql.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search