MySQL Database Move


Recommended Posts

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

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

  • Recent Achievements

    • One Month Later
      Sopa flores earned a badge
      One Month Later
    • First Post
      StaticMatrix earned a badge
      First Post
    • Week One Done
      StaticMatrix earned a badge
      Week One Done
    • Rookie
      lamborghiniv10 went up a rank
      Rookie
    • One Month Later
      pinnclepd earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      504
    2. 2
      PsYcHoKiLLa
      207
    3. 3
      +Edouard
      155
    4. 4
      Steven P.
      87
    5. 5
      ATLien_0
      79
  • Tell a friend

    Love Neowin? Tell a friend!