Do Security Copy

Ithilien · Post by **Ithilien** » Mon 23 Jul 2007 14:33

Hello,

i'm trying to make a security copy of my database using mydac but i can't. I tried to use the client mysqldump but it works in sheel, not as a SQL command ( if i'm not wrong ), so how can i do it using SQL statements? Is it possible? THank you.

P.D.: I'm working in Windows XP environment.

Antaeus · Post by **Antaeus** » Tue 24 Jul 2007 08:06

If I understood you correctly, you need either TMyDump or TMyBackup component of MyDAC. You can read more about them in the MyDAC help.
This topic of MySQL Reference Manual should be also useful for you.

Ithilien · Post by **Ithilien** » Tue 24 Jul 2007 13:37

Yeah, but i have MyDAC standard so i don't have this component...

I think the best easy solution is to use those sentences:

Code: Select all


SELECT * INTO OUTFILE 'file_name' FROM tbl_name.

LOAD DATA INFILE 'file_name' REPLACE ...

Antaeus · Post by **Antaeus** » Wed 25 Jul 2007 07:56

Yes, this solution looks appropriate in your case.
But mysqldump provides more functionality. It is a self standing tool that included in the MySQL installation.