PDA

View Full Version : How to perform a MySQL 'source' command in Transformation



Simon_Lux
01-30-2013, 11:02 AM
Hi everybody !


I join this forum today


I must create un job which go to populate a MySQL database (already existing) from Dump file.
I decided to create a SQL Script as bellow :


source /path/dump.sql;


When I execute this transformation, I've the following error :
2013/01/30 15:08:41 - Exécution script SQL.0 - ERROR (version 4.3.0-stable, build 16786 from 2012-04-24 14.11.32 by buildguy) : Le traitement va être arrêté suite à une erreur:


I don't find how to solve this issue and I don't know an other method to populate a MySQL database from a Dump.


Somebody here can help me ?!!


Thanks in advance.


Kr,


Simon

Simon_Lux
02-04-2013, 01:10 PM
Nobody of this community can help me for my problem ??...
I still to search on the web but no answer for the moment...