CODEWITHSUNDEEP
mysqldatabasedumpphing
Easly
Easly

Reputation: 334

Phing pdosqlexec Segmentation Fault

when i try to execute this 

<pdosqlexec 
    url="${pdo_driver}:host=${host};dbname=${db.name};" 
    userid="${mysql_user}" 
    password="${mysql_pwd}" 
    encoding="utf8" 
    onerror="abort">
    <fileset dir="./cache/mysql/">
        <include name="dump.sql"/>
    </fileset>
    <formatter type="plain" outfile="./cache/mysql/output4.txt"/>
</pdosqlexec>

i get a segmentation fault, and the loading of the dump.sql is interrupted. Any solution?

Upvotes: 0

Views: 360

Answers (1)

Alexey
Alexey

Reputation: 157

You can try add delimitertype="row" option to pdosqlexec. For me this solution helps load files larger then 4 MB

full example of use

<pdosqlexec
    url="mysql:host=${DB_HOST};dbname=${DB_NAME}"
    userid="${DB_USER}"
    password="${DB_PASS}"
    delimitertype="row">
        <transaction src="${DB_SCHEMA_PATH}/notus-backend.sql"/>
        <formatter type="plain" outfile="${LOG_PATH}/phing.CreateTables.log"/>
</pdosqlexec>

Upvotes: 1

Related Questions