Hi,
Option 2 will not work. InnoDB has background threads that continue
to change data even when the database is "quiet".
This is a simplification. The details are too complicated to write in
this thread, but there's an entire chapter on this topic in the book
I'm writing right now, High Perfor
Hi Alex,
I've used this method to start a replication slave without using MySQLdump to
get the data from one machine to another.
Option 1 works for sure,
Options 3 and 4 do not work for sure (if a .MYI, .MYD or ibdatax file is
changed while you are copying, you get a broken file on the other en
Its the same program, just Improved :-)
People hate things they do not understand.
You're probably right, and if I had memorized all the commands to be able to
edit text, and had gotten used to it, I may like it. I've just gotten used
to free-format editing w/o having to enter any commands to
ysql@lists.mysql.com
Subject: Re: Backup questions
> There's GVIM for Windows, its the same program of Linux, I use it when
> there's no way but using Windows. Get it at www.vim.org ! Its a blast
> having the same (powerful, easy, fast and reliable) tool in windows
> and linux.
On 7/3/06, Jesse <[EMAIL PROTECTED]> wrote:
> There's GVIM for Windows, its the same program of Linux, I use it when
> there's no way but using Windows. Get it at www.vim.org ! Its a blast
> having the same (powerful, easy, fast and reliable) tool in windows
> and linux. But you'll find it kinda
ks,
Jesse
- Original Message -
From: "Brad Jahnke" <[EMAIL PROTECTED]>
To: "Jesse" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Monday, July 03, 2006 11:06 AM
Subject: Re: Backup questions
2) sometimes, I like to copy just a single table or so out
There's GVIM for Windows, its the same program of Linux, I use it when
there's no way but using Windows. Get it at www.vim.org ! Its a blast
having the same (powerful, easy, fast and reliable) tool in windows
and linux. But you'll find it kinda hard to learn at first, because of
the "command mode"
On 7/3/06, Jesse <[EMAIL PROTECTED]> wrote:
> --routines, -R
> and
> --triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
> 2) sometimes, I like to copy just a single table or so out of the backup
> file, and restore just that.
You might want to try out MySQL Administrator which can often be used to
restore backups from mysqldump. It can _selectively_ restore tables from a
backup file.
http://dev.mysql.com/doc/admi
--routines, -R
and
--triggers
Thanks, these did the trick, and it's put my procedures and triggers into
the back up file. However, it has commented them out so that they will not
be created if I do a restore to a new database. Not sure why...
Change Editor ;-)
I personally use VIM and ne
Jesse wrote:
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe
a newer one wouldn't, but for the most part, it does a very good job for
me.
Ok never heard of multiedit... if your system is window
Funny, i've never seen one that does? What system/editor are you using?
Multi-Edit version 8.0i. This is an older version of the editor. Maybe a
newer one wouldn't, but for the most part, it does a very good job for me.
try to use the --max_allowed_packet= option - afaik mysqldump will creat
On 7/3/06, Jesse <[EMAIL PROTECTED]> wrote:
I'm trying to determine the best way to back up my MySQL databases in such a
way that they can be easily restored, flexible, and complete. I've
experimented with physically copying the files (with disastrous results).
MySQLDump seems to be the way to g
Jesse wrote:
my editor forces a hard line break at column position 16384, which, of course, corrupts
the restore. I don't know if there are other text editors that will not do this,
Funny, i've never seen one that does? What system/editor are you using?
or even better, if there is a way to
14 matches
Mail list logo
