Ninjakreborn Posted November 29, 2006 Share Posted November 29, 2006 Ok I have to move my database to another server.I went into mysql to get a dump, and it locked up.I had to wait until someone at bluehost could actually go in and back it up for me.They did that, and I see it's 25.5 megabyte .sql file, I can't even seem to open the damn thing on my computer.Much less export it over to the sql, so I finally get it opened, and when I try to paste a little sql at a time into the sql box for the other server, it starts telling me, improper syntax, can someone please help me figure out how to get it from that database to me new database, on my new server. Quote Link to comment https://forums.phpfreaks.com/topic/28921-moving-db-to-another-server/ Share on other sites More sharing options...
AndyB Posted November 30, 2006 Share Posted November 30, 2006 [quote]can someone please help me figure out how to get it from that database to me new database, on my new server.[/quote]Seems like a good question to ask your host.Possible sources of problem are the collation, character set, and how the table type is defined. Maybe you're trying to use reserved words as table names or field types. That's why actual error messages are so helpful in solving these things.Take [b]one small table[/b] from the database and try to add it on the new server. Report the exact message(s) you get. Quote Link to comment https://forums.phpfreaks.com/topic/28921-moving-db-to-another-server/#findComment-132462 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.