Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The issue with answering the question in it's current format is that there is two interpretations that could be made.</p> <ol> <li>You are asking how to import the file that you generate via PHPMyAdmin, to do this all you need to do is to go to the copy of PHPMyAdmin that is connected to the database that you would like to use. Once you have logged in, select the database to be used then near the top of the page you have a tab marked <code>import</code>, just click on that and upload the file as requested and sit back for PHPMyAdmin to do it's job</li> <li>You are asking us how you can write a PHP script to take the exported SQL file and process it, kind of like an installation script... When you export the SQL file you need to make sure that you do not select any compression setting and that you export it either as text or an SQL file so that it is easier to process, it would also be better if you told the export script to <strong>not</strong> include comments, this is so that you can avoid physically needing to edit the file if you don't want to. From here you have two choices, you can either manually split the file into parts, i.e. one file for all of the table creation queries, a different file for all the INSERT queries. The second choice here is to process the whole file as it is using PHP queries, you can include the file as whole in your script then possibly look at splitting the file into an array to process easier and to let the end user know how the process is going.</li> </ol> <p><strong>Edit:</strong> I know it is wordy and if you needed it to help I could look at providing some code examples</p>
    singulars
    1. This table or related slice is empty.
    1. POimport phpmyadmin generated sql dump
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMarc Towler
    1. USMarc Towler
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CO+1, Thanks @Marc for your response. Your second option is what i need. I will try to export the dump using your guidelines and probably will update the code also.
      singulars
      1. PO
      1. USImran Naqvi
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload