CakePHP重新连接到DB [英] CakePHP Reconnect to DB

问题描述

我有一个脚本插入一个对象到数据库，然后我有喜欢20 000其他小对象被插入。因此，我将其他对象保存到数组中并保存。

I have a script that inserts an object into the database and then I have like 20 000 other little objects to be inserted. So I save the other objects into an array and save them afterwards.

但是服务器sais是MySQL服务器已经走了

But the server sais "MySQL Server has gone away"

我能以某种方式重新连接到数据库吗？

Can I reconnect in some way to the database? Or can I disconnect after inserting the big object and after collecting all the small object to reconnect?

推荐答案

你可以在你的模型中。

You can in your model.

$this->ModelName->getDatasource()->disconnect(); 
    //do stuff
$this->ModelName->getDatasource()->connect(); 

这篇关于CakePHP重新连接到DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！