Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (vintagerace, capnbob, GregK), 50 Guests and 12 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 88
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 4 of 4 < 1 2 3 4
Topic Options
#178651 - 02/17/07 06:39 PM Re: ok Moving day for me... [Re: David Dreezer]
Conrad Offline
addict
Registered: 08/04/04
Posts: 425
 Originally Posted By: David Dreezer
mysqldump --opt -u root -p database > dumpfile.sql

Yes, opt is on by default on newer versions of MySQL but not on older versions. I use it anyway, just in case. Saves a lot of time later.


I'm really glad I read this as my old server is running a pre-historic version of MySQL that was commonly used around the time when the Egyptians (or was it Marsians?) build the great pyramids.

What does --opt do btw, and how does it save time later?
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#178656 - 02/17/07 07:36 PM Re: ok Moving day for me... [Re: Conrad]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
BTW, --opt is enabled by default as of MySQL 4.1 (according to the man page):
 Quote:
As of MySQL 4.1, --opt is enabled by default, but can be disabled with --skip-opt.


As for what it does, quoting the manual again:
 Quote:
· --opt

This option is shorthand; it is the same as specifying
--add-drop-table --add-locks --create-options --disable-keys
--extended-insert --lock-tables --quick --set-charset. It should
give you a fast dump operation and produce a dump file that can be
reloaded into a MySQL server quickly. As of MySQL 4.1, --opt is on
by default, but can be disabled with --skip-opt. To disable only
certain of the options enabled by --opt, use their --skip forms; for
example, --skip-add-drop-table or --skip-quick.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#178679 - 02/18/07 05:12 AM Re: ok Moving day for me... [Re: Gizmo]
Conrad Offline
addict
Registered: 08/04/04
Posts: 425
I guess I'm very lucky that Dave mentioned this as my old server is running 4.0.22. All this time I have been making mysql dumps without this, but luckily never had to reimport them back.
Top
Page 4 of 4 < 1 2 3 4



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image