-1

This is a Duplicate to this question. But the given answer did not solved my problem. I have mysql installed which is accessed from other computers in the network with my ipaddress/phpmyadmin.

I also added line skip_name_resolve=1 to my my.ini file but this also din't worked. I cannot even take backup now.

I installed mysql on another pc and copied the databases from xampp/mysql/data from previous mysql folder. But the database does not has all the tables. Plz suggest something to resolve the problem or if there is any way i can take backup. enter image description here

Community
  • 1
  • 1
Sajal
  • 1,198
  • 1
  • 17
  • 32

1 Answers1

1

The error you are getting is a problem with resolving the hostname given for the MySQL connection string. Check your DNS entry for the host in question, modify your /etc/hosts to statically point to it, etc

Also this isn't a question of programming, rather of system, so...

Noam Rathaus
  • 5,405
  • 2
  • 28
  • 37
  • you rightly pointed out it isn't a programming question. I can't even access mysql from my pc. Can you tell how to check my DNS entry and how to modify /etc/hosts. It would of great help. – Sajal Nov 26 '13 at 05:41
  • The problem isn't with your MySQL, it is with phpMyAdmin, do you know where it points? i.e. which host it points to? – Noam Rathaus Nov 26 '13 at 06:25
  • I tried to access mysql using cmd prompt but it also gives same error. XAMPP is installed on my pc and i access it with localhost/phpmyadmin. I don't know where should it point. – Sajal Nov 26 '13 at 07:29
  • Your question is outside the scope of this, I suggest you try Super User or XAMPP support page – Noam Rathaus Nov 26 '13 at 10:25