access the database of a php application on a server lin

1

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?

    
asked by jalazbe 14.09.2017 в 19:20
source

1 answer

1

I imagine that you are only exporting the structure and not the data, for this in phpMyAdmin, when you go to export, go to Customized > Options specific to the format: > Structure and data . This will also export each of the rows as inserts .

    
answered by 15.09.2017 / 14:17
source