• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: [OT] Frontbase Export/Dump
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [OT] Frontbase Export/Dump


  • Subject: Re: [OT] Frontbase Export/Dump
  • From: Mike Schrag <email@hidden>
  • Date: Mon, 12 May 2008 16:53:57 -0400

# To dump a database to a SQL file
$ mysqldump mydatabase > mydatabasedump.sql

# To import a database form an SQL file
$ mysql myremotedatabase < mydatabasedump.sql
Out of scientific curiosity, I went digging -- if you're using InnoDB, these appears to not be transactionally safe(much like FB's ascii dump). If you're using MyISAM, you have no transactions, so your database is already broken :). For InnoDB, though, you can use mysqldump --single-transaction dbname which will give you a transactionally safe dump. MySQL is not, however, transactionally safe for alter table statements. For most cases this won't be a problem, but if you try to dump the db while running migrations, you'll get corrupted results. If you're using MyISAM, you should do a --lock-tables, which has the obvious downside of .... locking the tables ... but if you're using this for backup, you really should be doing it.

ms

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


  • Follow-Ups:
    • Re: [OT] Frontbase Export/Dump
      • From: Kieran Kelleher <email@hidden>
References: 
 >[OT] Frontbase Export/Dump (From: Joshua Paul <email@hidden>)
 >Re: [OT] Frontbase Export/Dump (From: David Holt <email@hidden>)
 >Re: [OT] Frontbase Export/Dump (From: William Hatch <email@hidden>)
 >Re: [OT] Frontbase Export/Dump (From: Guido Neitzer <email@hidden>)
 >Re: [OT] Frontbase Export/Dump (From: Chuck Hill <email@hidden>)
 >Re: [OT] Frontbase Export/Dump (From: Kieran Kelleher <email@hidden>)

  • Prev by Date: Re: Connection pooling + WebObjects
  • Next by Date: Re: Connection pooling + WebObjects
  • Previous by thread: Re: [OT] Frontbase Export/Dump
  • Next by thread: Re: [OT] Frontbase Export/Dump
  • Index(es):
    • Date
    • Thread