mysql question

[Todd Holley]

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!

[studeggle]

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.

[Todd Holley]

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!

[adamnp]

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

[Todd Holley]

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?

[studeggle]

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.

[Todd Holley]

Finally got it. I figured out if you zip it you can do a lot more at one time.

 

Thanks!

[adamnp]

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

[DougK94]

Or import it using a command line instead of thru phpmyadmin, then you do not need to worry about it timing out....

[Todd Holley]

I didn't know the IP of the other sql server. >