Unable to restore 300mb 5.0 database to 5.5

9

993ti

Verified User
Joined
May 4, 2007
Messages
89
I'm moving servers but am unable to restore 3 databases varying from 60 to 300mb in size.
The dumps are from a 5.0 database but the new server is running 5.5.9

I tried bigdump but get 'Mysql has gone away' errors there.
Also tried restoring with SSH but it just throws a weird screen with PUTTY all over the place.

How do i import these databases? :(
 
mysql -u root -p databasename < file.sql

This is the command you should use to import from ssh. Replace root with whatever to root mysql admin login is. Then it will prompt you for your password. Make sure your .sql file doesnt have any USE databasename; at the top
 
Thanks, this went better but still got 'ERROR 2006 (HY000) at line 37736: MySQL server has gone away' :(
What am i doing wrong here?
It's Ubuntu 10.04 LTS (64 bit) btw.
 
Would it be wise to try and upgrade the 5.0 database to 5.5.9 first?
 
Finally got it to restore.
I edited my.cnf and changed max_allowed_packet = 1M to max_allowed_packet = 64M.
Something to tweak more i guess.
Thanks for the help SCSI
 
You must log in or register to reply here.
Back
Top