I have a mysql database on a server that is around 4 gb in size and I couldn't get it downloaded to my local machine. I tried getting a dump on the server, but the dump is not getting created probably because of the big size. Is there any way, I could get the dump downloaded on my local machine?
I can syncing using Sqlyog but I know it will take ages. Is there a way, I can get a dump created on the server?
By the way, my server is a linux server and its running php/mysql.