I am realizing something, the DB is for my WHMCS, and the table that is using 11GB Is "tblmodulelog" is this table really important or I can just leave it behind? Anyone with an idea?
-
You MUST read the Babiato Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.
Our resources on Babiato Forum are CLEAN and SAFE. So you can use them for development and testing purposes. If your are on Windows and have an antivirus that alerts you about a possible infection: Know it's a false positive because all scripts are double checked by our experts. We advise you to add Babiato to trusted sites/sources or disable your antivirus momentarily while downloading a resource. "Enjoy your presence on Babiato"
Help with migrating a 13GB sql database.
- Thread starter RickGrimes
- Start date
keep the whole database intact. if you do not know what you are doing, you can completely destroy the whole database.
Thank you bro!! I have just cleared "tblmodulelog", my DB has been trimmed to 938MB from 13GB. workable now!!
you may need to use scp linux command
by that you could move the 3gb file from server to server even if your internet is slow
you need ssh access to both servers
by that you could move the 3gb file from server to server even if your internet is slow
you need ssh access to both servers
if you can access ssh to server. Use rsync to tranfer database backup. And restore in new server. Other solutions, change webserver to Docker, use rsync to tranfer.
You can use any RDP , can get a free trial from AWS,Google Cloud, etc . move the sql file or zip to your project/domain root folder. Use RDP for your internet issue.. login to your current hosting provider /vps with shell access if you have, use wget to download the sql file /zip from your remote server (without changing your domain dns to new hosting ) . Use ssh to import sql file using command , or use a gui tool like bigdump to import your sql file.
Similar threads
