Todd Holley Posted August 4, 2007 Share Posted August 4, 2007 I have a friend with a phpbb3 forum. We are moving it to my web box. I got everything moved and then through the forum I created a sql backup. When I try to restore that backup via mysql administrator on my box it says that it can not restore. I have access to his databases through phpmyadmin as well but am not very familiar with it. If you have any suggestions / instructions on moving the db it would be very helpful. Thanks! Link to comment Share on other sites More sharing options...
studeggle Posted August 4, 2007 Share Posted August 4, 2007 There is an export tab in phpmyadmin, part of your problem may also be the size of the database. You may need to devide it into a couple pieces. Link to comment Share on other sites More sharing options...
Todd Holley Posted August 4, 2007 Author Share Posted August 4, 2007 I exported using phpmyadmin then opened up my phpmyadmin and i try to import it and it just freezes up. The db size is 11.4 mb. Thanks! Link to comment Share on other sites More sharing options...
adamnp Posted August 4, 2007 Share Posted August 4, 2007 Not sure if this is your issue, but it is a very common cause of import/export mishaps. When you first go into phpmyadmin, there will be your main database on the left. First click this, and then goto export, you should see a 'select all' button on the top left that will alow you to select all entries in that db. This you want todo, and then save it as a file. Now when you import, it should work. The issue is when you export from the main part, it also saves the 'create database phpbb3' or whatever happens to be the db name. So its trying to create the same db, in the db you already have. And outputs the error. I doubt the 11MB size of the DB would go over the timeout, so you should be able to import it all at once. Hope that helps Link to comment Share on other sites More sharing options...
Todd Holley Posted August 4, 2007 Author Share Posted August 4, 2007 Yeah actually I am having to split it up. I got all the tables imported except for posts. It is only a 2.3 mb table but it says it is too large. Is there any way to change the settings in mysql to where it will import it? Link to comment Share on other sites More sharing options...
studeggle Posted August 4, 2007 Share Posted August 4, 2007 Most of the time its not mysql that is the problem. If you access database directly it'd be fine with 11mb. Its the php that is the problem. For your current one, just devide the table into pieces. probably two should suffice. "INSERT INTO" is the key phrase it is a new row of data, you can break it any as long as you have everything upto that. Link to comment Share on other sites More sharing options...
Todd Holley Posted August 4, 2007 Author Share Posted August 4, 2007 Finally got it. I figured out if you zip it you can do a lot more at one time. Thanks! Link to comment Share on other sites More sharing options...
adamnp Posted August 4, 2007 Share Posted August 4, 2007 Yeah, also do it from a rdp instance instead of frm your local computer. You can change the php timeout if you have access to your conf files Link to comment Share on other sites More sharing options...
DougK94 Posted August 5, 2007 Share Posted August 5, 2007 Or import it using a command line instead of thru phpmyadmin, then you do not need to worry about it timing out.... Link to comment Share on other sites More sharing options...
Todd Holley Posted August 5, 2007 Author Share Posted August 5, 2007 I didn't know the IP of the other sql server. > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.