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 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.
Code: screenthen enter your command to import the database.
If you disconnect via timing out, just reconnect and type this:
Code: screen -rThis will reconnect you to the previous screen session which will still be running, meaning the import will still be processing. -bash: screen: command not found What's your OS?
If it's CentOS, then
Code: sudo yum install screenIf it's Debian, then
Code: sudo apt-get install screen
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 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.
Code: screenthen enter your command to import the database.
If you disconnect via timing out, just reconnect and type this:
Code: screen -rThis will reconnect you to the previous screen session which will still be running, meaning the import will still be processing. -bash: screen: command not found What's your OS?
If it's CentOS, then
Code: sudo yum install screenIf it's Debian, then
Code: sudo apt-get install screen