Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you are using InnoDB tables and therefore have transaction support, you don't need to lock the database at all you can just add the <a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction" rel="nofollow noreferrer"><code>--single-transaction</code></a> command line option. This gives you a consistent snapshot without locking anything by using the transaction mechanism.</p> <p>If you don't have transaction support you can get what you describe with the <a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_lock-tables" rel="nofollow noreferrer"><code>--lock-tables</code></a> command line option, this will lock the databases. </p> <p>It's also worth noting that READ LOCKs aren't quite as good as they sound since any write operation will lock which will lock subsequent read operations, see <a href="http://www.mysqlperformanceblog.com/2010/04/24/how-fast-is-flush-tables-with-read-lock/" rel="nofollow noreferrer">this article</a> for more detials</p> <p><strong>Edit:</strong> I don't think it's possible to dump the format and data separately without the file writing permission and the <a href="http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_tab" rel="nofollow noreferrer"><code>--tab</code></a> option. I think your only option is to roll your own <code>mysqldump</code> script that uses one of the transaction or READ LOCK mechanisms that mysqldump uses. Failing that it may be easier to just postprocess a single dumpfile into the format you want.</p>
    singulars
    1. This table or related slice is empty.
    1. POGenerating a set of files containing dumps of individual tables in a way that guarantees database consistency
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDan Head
    1. USDan Head
    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. COIs there a library in some language that can reliably generate a dump of a given table? Or maybe some way to pass an open DB connection to mysqldump?
      singulars
      1. PO
      1. USintuited
    2. COAny MySQL client library in whatever your preferred language should let you run a LOCK TABLE command, or START TRANSACTION before SELECTing the data out, you then just need to write the row data out in INSERT statement format. SHOW CREATE TABLE foo will give you the structure.
      singulars
      1. PO
      1. USDan Head
    3. CObased on the fact that `mysqldump`'s dumps contain commands other than INSERT, I'd say it's a bit more complex than that. Setting the character set is one thing that comes to mind. There are a lot of things to take into consideration, probably depending on the table type, and particular use cases, that I wouldn't want to have to attempt to itemize and deal with.
      singulars
      1. PO
      1. USintuited
 

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