Yeah. I know. It's a monster. Any advice on how to break this bad boy down to chewable chucks and import ...?
The file size limit is about about 10 mb ...
Yeah. I know. It's a monster. Any advice on how to break this bad boy down to chewable chucks and import ...?
The file size limit is about about 10 mb ...
FTP it to your account, then ssh into your grid account, and import it from the command line.
OK ...
OK ... I've been looking around. Anyone know of a web page that explained/teaches how to ssh and use command lines to import ...
Yeah, I'm a n00b.
OK, here's the problem. I have no experience with ssh. I've submitted a support ticket to my host -- mediatemple -- and after eight hours, there's no reply.
I was hoping there was advice on how to break the database into smaller pieces to I could just import them.
OK. Done whining now. Actually found the support articles I needed.
Just need an opportunity to get to my laptop where the files are.
I blame lack of sleep.
Download SQLyog, it's a ton easier to migrate databases with it.
Actually, I'm following instructions from my host and using Putty. FTPing the database to my server now. It's a big healthy monster.
Somtime soon, I'm going to try to shrink that thing. There's a ton of tabled I don't need since I've deleted perhaps thousands of splogs over the years.
A little help with PuTTY;
My instructions say to do the following:
4) Log in using SSH and navigate to the directory where the dump file is located.
5) Execute the following command from the command line
Here's the problem, I am at a comment line, and I have NOT friggin idea how to navigate to the right directory.
The line says blogpeoria.com@c101:~$
and then I have a cursor.
Any help would be appreciated.
Man, I hate incomplete instructions, especially when there's an eight hour lag between when the question gets asked and when it get answered.
ewww, command line. quick, I need a young priest and an old priest!
Heh.
Finally, I called tech support and he patiently walked this old fart through the process.
You know why I like the WPMU Forums? I get help when I need help. When I don't need help, I just need to learn, the pros just sit back and let me rant and whine until I get off my ass and make me look it up.
;-)
There is a php script just for large sql files. The bigdump http://www.ozerov.de/bigdump.php this script server to restore a very large backup of mySQL database. When You can't access the server shell or import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server.
Oh command-line. what a love-hate relationship. :D