Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <h2>What I think you should do:</h2> <p>I Think you should install phpmyadmin on your server, this will allow you to access your database from work/school/cafe/etc, MySQL-workbench is more advanced and gives you more features so you can deal with changing the structure and editing any rows/columns, relations, and much more, look at phpmyadmin's features it has most if not all.</p> <h2>phpmyadmin it works in any web-browser:</h2> <p>I really recommended phpMyAdmin it has many SQL features to help you deal with everything when it comes to the MySQL database if you are using innoDB then you get even more features such as relation-ships between tables.</p> <h3><a href="http://phpmyadmin.net/" rel="nofollow noreferrer">phpMyAdmin</a> has the following features:</h3> <ul> <li>Intuitive web interface</li> <li>Support for most MySQL features:</li> <li>browse and drop databases, tables, views, fields and indexes</li> <li>create, copy, drop, rename and alter databases, tables, fields and indexes</li> <li>maintenance server, databases and tables, with proposals on server configuration</li> <li>execute, edit and bookmark any SQL-statement, even batch-queries</li> <li>manage MySQL users and privileges</li> <li>manage stored procedures and triggers</li> <li>Import data from CSV and SQL</li> <li>Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LATEX and others</li> <li>Administering multiple servers</li> <li>Creating PDF graphics of your database layout</li> <li>Creating complex queries using Query-by-example (QBE)</li> <li>Searching globally in a database or a subset of it</li> <li>Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</li> <li>And much more...</li> </ul> <p>Everything you listed above is included in phpMyAdmin, if you are running debian or Debian-based system simply run:</p> <pre><code>root@debian:~ # aptitude install phpmyadmin root@arch:~ # pacman -S phpmyadmin </code></pre> <p>BTW: if you are not using Apache or lighttpd for the http-server you will need to read through the conf files for phpmyadmin and then write up the required conf script for phpmyadmin to work with your http-server.</p> <h2><a href="http://wb.mysql.com/" rel="nofollow noreferrer">MySQL workbench</a>. Its cross-platform and works great.</h2> <p><a href="http://diariolinux.com/wp-content/uploads/2008/08/wb51linuxpreview2a.png" rel="nofollow noreferrer">MySQL workbench visurally see what you are doing with your database. http://diariolinux.com/wp-content/uploads/2008/08/wb51linuxpreview2a.png</a></p> <p>BTW: Use <code>&lt;ctrl&gt;+&lt;G&gt;</code> to forward engineer a database, It took me a while to find out for to do this.</p> <h2>Stand alone perl file that works just after you configure it: (untested)</h2> <pre><code>use DBI; my $user = "username"; # MySQL Username my $pass = "xxxx"; # MySQL Password my $host = "localhost"; # MySQL Host my $mydb = "zzzz"; # MySQL Database my $file = "test.sql"; # Import file my $sqlServer = "mysql"; # What sql-server are we using, oracle/mysql/etc # I would use the following method to configure it, though the above works fine too. ($user,$pass,$host,$mydb,$file,sqlServer) = ( "username", # MySQL Username "password", # MySQL Password "localhost", # MySQL Host "myDB", # MySQL Database "test.sql", # Imported file "mysql" # What sql-server are we using, oracle/mysql/etc ); # Now lets connect to the MySQL server. my $dbh = DBI-&gt;connect("DBI:$sqlServer:$mydb:$host",$user,$pass)or die DBI-&gt;errstr(); # Lets now open the .sql file. open(INPUT,$file); # Now lets run each sql-statement. while ($line = &lt;INPUT&gt;){ print $line; $dbh-&gt;do($line); print "Query failed (run manually):\n$line\n\n ". $dbh-&gt;errstr()."\n" if $dbh-&gt;errstr(); } # Now close the file. close(INPUT); </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POGeneral purpose remote data backup and download - including InnoDb support
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJamesM-SiteGen
    1. USJamesM-SiteGen
    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
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI am well aware of the features supported by PhpMyAdmin and I have already mentioned the export module of PhpMyAdmin. The other features of PhpMyAdmin do not actually help in solving this problem. Only a working export script (like I have said, a separate working export module of PhpMyAdmin) would be a good solution (a single script instead of a whole web application). If you know about any such similar working script I would really appreciate that. Thanks.
      singulars
      1. PO
      1. USSandeepan Nath
    2. CO@Sandeepan @Sandeepan Nath : I added another entry above, I will also include a single stand alone script that will take a parameter for the SQL script. MySQL workbench is the best option though, I do know its another program, but as it works on most if not all operating-systems.
      singulars
      1. PO
      1. USJamesM-SiteGen
    3. CO@Sandeepan Nath : But first I need to know are you running an operating system with perl? if yes I can give you a simple script that takes a parameter and sill read out the SQL commands to mysql.
      singulars
      1. PO
      1. USJamesM-SiteGen
 

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