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...
Security reasons maybe, this would make the dump not compatible with
older versions of mysql that do not support triggers, procedures or
functions. I guess there must be a way for mysqldump to uncomment
this.
> Change Editor ;-)
> I personally use VIM and never had such problems.
I've been using Multi-Edit for years, and have been very happy with it. VIM
sounds like a Linux editor?? I'm working in Windows XP.
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".
> --extended-insert (-e) will put multiple VALUES() statments in a
> single line. Disable this feature (it is default for --opt) and will
> get a single INSERT for each row.
I thought this may be the way I needed to go, but wasn't sure. I will give
this a try and see if it works.
Thanks,
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
