Restoring database fails

[Martz]

I'm trying to restore a database to stock mysql Ver 11.15 Distrib 3.23.47

Everything goes in file up the first 120+mb, then at postid 663916 the process goes to sleep, and just gathers dust in the process list :( I've tried this quite a few times, I'm experimenting with a few switches such as -q -C -n to see if it will be sucessfull, but no such luck. :(

Does anyone have any advice for how I may be able to restore this dump to the new mySQL server?

Thanks!

Martin.

[Martz]

Seems to stop when mysql hits 128mb for its database totals.... :( :( :( :(

[Martz]

$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda1 726M 726M 0 100% /
/dev/hda3 194M 24M 170M 13% /var
/dev/hda4 8.2G 3.4G 4.8G 42% /home

[Martz]

su: user root does not exist

... and there I think I will give up...

[Steve Machol]

What command are you using to restore the backup?

[eva2000]

Originally posted by Martz
$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/hda1 726M 726M 0 100% /
/dev/hda3 194M 24M 170M 13% /var
/dev/hda4 8.2G 3.4G 4.8G 42% /home your root partition seems full too

[Martz]

mysql -uroot -p databasename < mysqldump.sql

[Steve Machol]

Try the database username and password, not 'root'.

[eva2000]

Originally posted by Martz
mysql -uroot -p databasename < mysqldump.sql some servers i noticed need a space between -u and root