11-17-2016, 06:48 AM | #1 |
Junior Member
Join Date: Sep 2016
Posts: 17
|
ispmanager database size displaying
We import users from ISPmanager-Pro 4.4.10.23 to ISPmanager Lite 5.78.2
User has a big database, almost 6 Gb, we cannot import using User import tool. 1. Look on the old server how the database is created. (show create database `basa-dannih`) 2. Using "User import" we transferred on new server the files 3. Go to new server in an imported user account and create the same db like on the old server 4. Make DB dump on the old server (mysqldump --add-dpor-table basa-dannih > basa-dannih.sql). 5. We copy database dump to the new server and recover in in a create DB via mysql basa-dannih < basa-dannih.sql 6. Run "User Import" again 7. The site is working. Database size is shown as 0 if we use such method What should we do to display in ISPmanager 5.78.2 correct DB size |
11-17-2016, 07:05 AM | #2 |
ISPsystem team
Join Date: Aug 2016
Posts: 102
|
Hello,
You can indicate a small value of DBCacheMaxDelay in Configuration file, and wait when ISPmanager will count the size, or change it or delete it from config. http://doc.ispsystem.com/index.php/Database_size |
|
|