PHP Classes

Works fine, but very slow action

Recommend this page to a friend!

      PHP MySQL Copy Database  >  All threads  >  Works fine, but very slow action  >  (Un) Subscribe thread alerts  
Subject:Works fine, but very slow action
Summary:processing a lot of rows
Messages:2
Author:Michal Detko
Date:2021-09-30 09:31:14
 

  1. Works fine, but very slow action   Reply   Report abuse  
Picture of Michal Detko Michal Detko - 2021-09-30 09:31:14
Hi, after update it works fine.
but I tried on DB with 5 tables, but LOG table is about 160K rows.
I shut it of after 30m on 13K copied rows.

  2. Re: Works fine, but very slow action   Reply   Report abuse  
Picture of René Mansveld René Mansveld - 2021-09-30 09:54:44 - In reply to message 1 from Michal Detko
Well it is optimized to save as many records as possible. Therefore it can't just copy very large blocks of data like for example phpMyAdmin would do. But if you use it on a damaged database, you can save the most records with it, as it jumps over records it can't read.

I developed this tool as I had to restore a database with important data where in some tables there were damaged records. With this tool, I saved about 99% of the database. While running I had to restart the MySQL server a view times. With phpMyAdmin the crash would just stop the copying and the SQL file would be inconsistent.