US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > General technical discussion

Notices

Reply
 
Thread Tools
Old 11-17-2016, 06:48 AM   #1
Junior Member
 
Join Date: Sep 2016
Posts: 17
Callhost is on a distinguished road
Default 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
Callhost is offline   Reply With Quote
Old 11-17-2016, 07:05 AM   #2
ISPsystem team
 
Join Date: Aug 2016
Posts: 102
C.Gladkov is on a distinguished road
Default

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
C.Gladkov is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 01:12 PM.