i am having issues moving a few databases to a new server as they are over 1 gig on size. what would be the best way to do this they are on the same network. i really dont know much but trying to learn as i go could i use putty? i assume server would be the best way but dont really know. old server 192.168.1.108 new server 192.168.1.132 old server MySQL version 10.0.38-MariaDB-0ubuntu0.16.04.1 new server MySQL version 10.0.38-MariaDB-Ubuntu20.04.6 thanks for any help kwick
It does not really matter how big the database is, it is moved the same way. PHPMyAdmin may have restriction on the size of database dump it can handle, but doing the dump and restore from command line works no matter the size of dump. Make a dump of the database. If the file is compressed, it should be much less than 1 GB (That is very large database, by the way) Copy the dump file to the target host, use command scp (secure copy) or if you want to use putty it has secure copy command for windows, pscp.exe. Restore the database dump. If you do not know how to do it from command line, use Internet Search Engines with Code: mysql restore dump command line
