--- Egor Egorov <[EMAIL PROTECTED]> wrote:
> David Blomstrom <[EMAIL PROTECTED]> wrote:
> >> If you use command-line client you can do:
> >>
> >> mysql> SET FOREIGN_KEY_CHECKS = 0;
> >> mysql> SOURCE file_name;
> >> mysql> SET FOREIGN_KEY_CHECKS = 1;
> >
> > Does anyone on this list know...
> >
> > 1. Can I also open the file with Notepad and
> insert
> > the statements?
>
> Yes.
>
> >
> > 2. Where's the location of this dump file?
> >
>
> Where did you save it?
I don't know; I didn't even know it existed! When I
EXPORT a database, am I creating just ONE file or more
than one? At first, I thought there was just one - the
file that landed on my desktop. I inserted these two
statements in that file (using Notepad), but I
couldn't publish it online.
Then I thought I understood that there's a SECOND file
- a "dump file" that I'm supposed to modify. But I
didn't knowingly save it to any particular location,
because I wasn't even aware of its existence. During
the export operation, I wasn't prompted to save a dump
file to a certain location.
So let me go back to sqaure one...
1. When I export a database, how many files are
created?
2. If more than one file are created, including a dump
file, I'm supposed to insert the referential integrity
statements in the dump file, not the SQL file, right?
3. How can I determine the location of the dump file I
saved?
Thanks.
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
