Devart Forums

Anyone can help me with this problem?

try to do in a mysql shell this

mysql> source c:/dump.sql;

and try to do this with a mycommand

it show an error.

It's a bug? or what?

Delphi 2k5 update 2
MyDac 3.50.0.18

Command source is a command of "mysql.exe" utility. To run scripts with MyDAC use TMyScript.

I need to load an huge script...About 256Mb of .sql. TMyScript leaks too memory when i do a myscript1.sql.loadfromfile('c:\mydump.sql');.
How i can solve this?

Now MyDAC doesn't support such functionality. We are planning to extend functionality of TMyScript to execute large scripts in MyDAC 4.0, but most likely queries in this script must be divided by some specific dividers.

Hi,
I see this post is from 2005. Is this possible by now to restore a big mysql file? The TMyScript is using too much memory in my case too...

In order to execute SQL commands from file, you can use the ExecuteFile method of the TMyScript component to save memory consumption.