Devart Forums

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.

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.

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

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

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.