I'm working with Plesk Onix Version 17.5.3 update # 21. The server is Ubuntu 16.04.2 LTS Php version 5.6.30 php extension: mysqli, curl, mbstring phpMyAdmin version 4.6.6
The fact is that I use the option "export dump" of the database with the intention of being able to access the data it contains. The file that is generated includes:
- error_docs
- link
- logs
I use Notepad +++ 7.5.1 to open the file that is generated (filename.sql)
In it I find the information on how to create the tables with their definition
DROP TABLE IF EXISTS
plan_accion
;/ *! 40101 SET @saved_cs_client = @@ character_set_client * /;
/ *! 40101 SET character_set_client = utf8 * /;
CREATE TABLE
plan_accion
(
pa_id
int (11) NOT NULL AUTO_INCREMENT,(... other fields ...)
PRIMARY KEY (
pa_id
)) ENGINE = InnoDB AUTO_INCREMENT = 47 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
But I can not see the contents of the Database.
If I access PhpMyAdmin from the database I can see the tables and if I click edit I can see its contents.
The problem is how to see the contents of the database in a document. some way?