Sikh Posted November 25, 2012 Share Posted November 25, 2012 I'm trying to move some big production databases from mysql server 5.0.51b to the latest 5.5 release. I properly dumped the databases on the old server and I moved then to the new server. Every time I run "mysql -u root -p (database) < (database_SQL.sql)" It gives me an error saying its at line 1. Line 1 is the dump information from the old server. I'll remove it and then it says "can't create table blah blah blah". What do I do!? This has been driving me crazy at work. Good thing is we are moving to a new server. So if I can't get it today I'll be able to throw up the old machine but bad thing is its been the biggest bottleneck in our network. Finally got a machine specd out perfectly for a replacement and now mysqls being a bitch. Any help is appreciated guys. Thanks, Sikh Link to comment https://www.neowin.net/forum/topic/1122034-mysql-database-move/ Share on other sites More sharing options...
Faks Posted November 25, 2012 Share Posted November 25, 2012 first of all what error exactly appears ! Link to comment https://www.neowin.net/forum/topic/1122034-mysql-database-move/#findComment-595348226 Share on other sites More sharing options...
Recommended Posts