Large Data Import


#1

Hi all,

I’ve got a 9.9 mb export from a mysql database I want to import into my new DreamHost site. Got bumped on the import with the suggestion the import might be too large.

Anyone worked around this one?

Thanks

Mike


#2

You can do it from shell like this:
mysql -h your.mysql.host.name -u USERNAME -pPASSWORD DATABASE_NAME < your_dump.sql

Notice there is no space between “-p” and password


#3

I can’t seem to login, keep getting error

my shell host is mysql.downtownchagrin.dreamhosters.com

Does this seem correct? or would it be more something like mysql.batman.dreamhost.com?

Sorry to be so basic but thanks for your answer


#4

You should know what is your database host name.
But don’t worry. You can check it in the panel.
Just go to ‘Goodies’ -> 'Manage MySQL’
Some there, below ‘Hostname for this MySQL server’ is your database host name.
You can also add/change user data and/or password for the database.


#5

Well this is rather frustrating. I do know my user name and I do know my database name because I am able to login with myphpadmin however in the attempt to log in from the shell I keep getting rejected.

very frustrating since I can’t upload via myphpadmin

what does anyone suggest?

all help is appreciated


#6

If you can login to database via phpmyadmin you must also can via shell.
Give me some more details, i.e. what error do you see when you try to connect to database via shell


#7

well I would think so too, but so far I cannot log into any mysql host to import data.

Host: mysql.downtownchagrin.dreamhosters.com /bin/bash

type ssh2 3des port 22

Last login: Fri Jan 30 14:17:26 on ttys001
ssh -c 3des -2 -l downtownchagrin mysql.downtownchagrin.dreamhosters.com -p 22 ;exit
GFive:~ michaelbellah$ ssh -c 3des -2 -l downtownchagrin mysql.downtownchagrin.dreamhosters.com -p 22 ;exit
downtownchagrin@mysql.downtownchagrin.dreamhosters.com’s password:
Permission denied, please try again.
downtownchagrin@mysql.downtownchagrin.dreamhosters.com’s password:


#8

Here’s a Wiki article with some helpful commands:
http://wiki.dreamhost.com/Migrate_MySQL

To clarify, you need to SSH into your webserver (downtownchagrin.dreamhosters.com), then run the sql commands.

-Scott


#9

ah so, i see said the blind man as he reached for his hammer and saw

thanks!!