I've got my vBulletin database running on my machine. It's a long story about how I tried to upgrade to 4.0, didn't work out, got it working on my machine, need to migrate to server, blah blah blah, I won't bore you.
Point is: I have a 150-ish meg .sql file. Compressed it's about 52 megs. Way too big for phpmyadmin to accept through a browser.
I need to get this file, compressed or uncompressed, onto my server. It's a Linux machine running cPanel/WHM. I can FTP it to my server, but I have no clue where to put it on there in order to run it.
I also have no idea how to run it. I was raised on Windows; thanks mom!
Now I'm on a Mac. I'm very unfamiliar with command line stuff. I can change directories and... uhh, paste in commands.
So to put it plainly:
- Where do I upload my sql file to?
- How do I execute it?
I have attempted to figure out how to remotely connect to my server via MySQL Administrator. I've granted access to my IP. I don't even know what to put into the server hostname; tried my domain name and my server's IP address. Ugh. I'd like to know how to make this happen as well.
I can't seem to find a simple solution to these problems. I've scoured the 'net, but there is no simple step-by-step solution tutorial that I could find.
Please help me! Share your wisdom! I must learn!