problem while importing db via ssh

[chems]

hello guys

i tried 4 times importing my db via ssh its 1gb one

the memory load get higher and higher

i see in phpmyadmin that 800 mb is done

but after few min i get this



and import stopped this happen 4 times guys what shall i do please

chems Reviewed by chems on 23rd Jun 2011. problem while importing db via ssh hello guys i tried 4 times importing my db via ssh its 1gb one the memory load get higher and higher i see in phpmyadmin that 800 mb is done but after few min i get this Rating: 5

[snowmanrene]

Import it via phpmyAdmin and make sure that this is checked:

"Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. This might be good way to import large files, however it can break transactions."
What this does is if phpmyAdmin times out, you can simply select the same file to import and it will continue where it left off. Usually you need to use this method multiple times to import really large databases.

If the above does not work, then try this in SSH.

screen

then enter your command to import the database.
If you disconnect via timing out, just reconnect and type this:

screen -r

This will reconnect you to the previous screen session which will still be running, meaning the import will still be processing.

[chems]

-bash: screen: command not found

[snowmanrene]

What's your OS?

If it's CentOS, then

sudo yum install screen

If it's Debian, then

sudo apt-get install screen