--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 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.

--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]

Reply via email to