laurin1 Posted February 5, 2008 Share Posted February 5, 2008 What is the best way to do this? I've tried using various tools, but I keep running into problems. The latest is that I'm trying to import a dump, and I keep getting: Error Code: 1044 - Access denied for user 'root'@'localhost' to database 'information_schema' Yet, I know that root has global access to the entire database. Link to comment https://forums.phpfreaks.com/topic/89458-move-mysql-db-to-new-server/ Share on other sites More sharing options...
laurin1 Posted February 5, 2008 Author Share Posted February 5, 2008 Sorry, that error is resolved, it's this one: Error Code: 2006 - MySQL server has gone away Link to comment https://forums.phpfreaks.com/topic/89458-move-mysql-db-to-new-server/#findComment-458136 Share on other sites More sharing options...
fenway Posted February 5, 2008 Share Posted February 5, 2008 And you're read this? Link to comment https://forums.phpfreaks.com/topic/89458-move-mysql-db-to-new-server/#findComment-458628 Share on other sites More sharing options...
laurin1 Posted February 5, 2008 Author Share Posted February 5, 2008 I have and I have fixed that last error, but that was only with the primary database. I need all of them and when I try to do that, I get the other error: Error Code: 1044 - Access denied for user 'root'@'localhost' to database 'information_schema' Link to comment https://forums.phpfreaks.com/topic/89458-move-mysql-db-to-new-server/#findComment-458714 Share on other sites More sharing options...
fenway Posted February 5, 2008 Share Posted February 5, 2008 That's quite bad.... that should never happen, because (A) root has access to everything unless the permissions are messed up and (B) you're never supposed to be root. Link to comment https://forums.phpfreaks.com/topic/89458-move-mysql-db-to-new-server/#findComment-458757 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.