• Copy big MySQL database with php in 5 steps

    July 17, 2015

    1. Dump structure of the big database. 2. Open the sql file and cut the constraints. 3.  Import the structure to another database. 4. Run this code: /** * Sync from live database */ ini_set('memory_limit','512M'); $limit = 100000; $time = time(); $sleep = 1; $sleepEvery = 60; $link = new mysqli( “__HOST__”, “__USER__”, “__PASSWORD__”, “__DATABASE__” […]

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org