Trying to restore large mySQL database

[thehostrack]

Hello,

We are trying to restore a very large database from a backup drive on one of our servers (the database is around 3GB). We run the command:

mysql databasename < /path/to/backup/database.sql

but after the database gets around 1500MB loaded in we get a software error "Software caused connection abort." What is causing this? Is their a limit set somewhere?

Also now phpMyAdmin is giving us this error when we try and access it:

Warning: session_write_close() [function.session-write-close]: write failed: No space left on device (28) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:44) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 101

Any help PLEASE!

THANKS!

[Infopro]

This should work:

mysql -u username_username -p username_databasename < /path/to/backup/database.sql

[thehostrack]

That still doesn't stop the software error...

[encryption]

your TMP dir is full. empty it. See the last response in this thread - http://forums.cpanel.net/showthread.php?t=69255

Also now phpMyAdmin is giving us this error when we try and access it:

Warning: session_write_close() [function.session-write-close]: write failed: No space left on device (28) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44

Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 44

Warning: Cannot modify header information - headers already sent by (output started at /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php:44) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 101

Any help PLEASE!

THANKS!

[thehostrack]

I finally got the command to run but once the database loads around 1700MB in the entire server goes CRAZY. Is this because the tmp directory is filling up? If I reboot the server everything returns to normal,but my database has not bee restored.

Please advise anyone!

THANKS!!