I have a problem, the MySQL server goes away...
Warning: PDOStatement:: Execute (): MySQL server has gone away in/var/www/html/xxxhashtag.com/sitemap_generator.php on line 88
I am reloading the sites from old backups, but I need to sync the sitemaps.
I have a script, which reads the new data in the database, adds links to the Sitemap, and updates the database by entering the value "Insitemap = 1", the next start reads only the data with value "Insitemap = 0".
Normally everything works, but now I have to sync everything in the Sitemap, about 600.000 lines...
The script will stay there quite a bit, then it returns errors of this type.
I have increased the limits on mysql.cnf and php.ini, but still does not work, what else can I do?
|