Hi Mustafa,
1. Not work in innodb (also possible in Aria) storage-engine
Thats is true. But now, Kloxo-MR concentrates on MyISAM.
2. Need stop mysql server before zipped process and start again after that because to make sure integrity of data
We do not need to backup procedures and functions.
To make sure integrity of data:
Old Server:
...........There is no need to stop mysql server BEFORE THE TAR BEGINS to copy
...........and compress the data. The only negative situation may occur is when
...........the database tables are updated and very big.
...........This depends on the size of the database.
...........Here, one could issue a LOCK TABLE command.
...........This would be the same when one makes a dump or a a dir copy.
...........Time to lock until a directory is copied _IS_ FASTER to dump procedure.
Old Server:
...........There is no need to stop mysql server DURING THE COPY PROCESS is going on.
Old Server:
...........If you want a consistent dump and sure integrity of data of database
...........WHILE ITS BEING MODIFIED you need to use --single-transaction
...........(if you only backup innodb) or --lock-all-tables.
...........Stop mysql server is not necessary.
New Server:
...........There is no need to stop mysql server
...........WHILE KLOXO-MR CREATES A NEW ENTRY of database, if absent.
New Server:
...........There is no need to stop mysql server
...........BEFORE THE TAR BEGINS to copy
...........and UNCOMPRESS the data under /var/lib/mysql/db_name.
New Server: Last step
...........There is no need to stop mysql server
...........to RELOAD THE GRANT TABLES on new entry of database.
...........Thereafter, mysql will recognize the directory as a database.
In a nutshell, your ALT method is appropriate for recent condition of Kloxo-MR server installations everywhere. regardless of the kernel or bits, the ALT method SHALL FUNCTION efficiently without errors and fears.
Copy, tar and untar and simple linux functions. Now, if a directory appears under the /var/lib/mysql, then it does not disturb mysql at all until the directory is registered as a database. The only exception that would disturb mysql server would be if the name of this directory is mustafa. Then, mysql would crash.
3. No other panel use this method (including MySQL Inc and MariaDB Inc) as 'alternative' method
Big companies do not use this method because they have to handle with different mysql versions and environment.
In that case, I would also not suggest to do anything like this.
In case of Kloxo-Mr, this fundamental pre-requisite is not there. All Kloxo-MR installation will have a standarized procedure of installlation and maintanence of the servers. Here, one can use a different approach than used by different companies.
If you do not implement, than thats fine. But if you do implement, it will not help me.