The MU forums have moved to WordPress.org

How do I import 180 MB sql db to new WPMU installation? (13 posts)

  1. billdennis5
    Member
    Posted 16 years ago #

    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 ...

  2. lunabyte
    Member
    Posted 16 years ago #

    FTP it to your account, then ssh into your grid account, and import it from the command line.

  3. billdennis5
    Member
    Posted 16 years ago #

    OK ...

  4. billdennis5
    Member
    Posted 16 years ago #

    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.

  5. billdennis5
    Member
    Posted 16 years ago #

    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.

  6. billdennis5
    Member
    Posted 16 years ago #

    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.

  7. MrBrian
    Member
    Posted 16 years ago #

    Download SQLyog, it's a ton easier to migrate databases with it.

  8. billdennis5
    Member
    Posted 16 years ago #

    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.

  9. billdennis5
    Member
    Posted 16 years ago #

    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.

  10. demonicume
    Member
    Posted 16 years ago #

    ewww, command line. quick, I need a young priest and an old priest!

  11. billdennis5
    Member
    Posted 16 years ago #

    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.

    ;-)

  12. alexandrehaguiar
    Member
    Posted 16 years ago #

    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.

  13. andrea_r
    Moderator
    Posted 16 years ago #

    Oh command-line. what a love-hate relationship. :D

About this Topic

  • Started 16 years ago by billdennis5
  • Latest reply from andrea_r