On 12/06/2018 10:31 AM, Andrei Verovski wrote:
Hi !
Thanks to everyone who replied with advice !
I have phpmyadmin on both servers, yet my concern was following - mysql database users and permissions. This accounting & inventory control system have a truckload of databases (not single, but many), each with many tables, and I have no idea how they relate to each other.
You can use the same `mysqldump --all-databases` to dump your entire system. The reason you compress the data from .sql to .bz2 or .xz is to minimize the size (from 500-1000%). The .sql tables are text (and some very sparse). You can easily get 5:1 or more by simply compressing the data. Now with 32G smart cards, it's not nearly as critical as it was with floppies.... Also look at adding the `--add-drop-database` and `--add-drop-table` options. -- David C. Rankin, J.D.,P.E. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org