Forum Backup Restoration Help...

[Hoberz]

I am trying to move my forum/database from one webhost to another webhost.

Can someone explain to me how to restore my forum on the new webhost with a sql.qz back-up file? Is this possible or not? When I try to restore it via phpMyAdmin, I get error messages because the forum database name isn't the same as the database I created (if database name was 1234_server, I can only create server_1234 on the new webhost).

Help would be very appreciated -- it sounds as if I should resort to using SSH/Telenet, but someone else was hosting for me rather and I don't really want to give him my log-in information.

Thanks!

[your24hourstore]

the database will be named the same as the sql file
so you may have to rename it to the new databases name

depending on your host the first part of the database may take 7 or 8 letters from the Domian name example if your domain is houseforsale.com

your database may need some of that to create your database, like

housefo_ the rest is a name you have selected like house so the database will look like housefo_house when you download the sql file it will look like house.sq.gz if it has been compressed using that format that file name can be changed as long as you upload a saved database that matches the database it will take it.

now you may have to change your paths in config.php because that information is not going to be correct if you have changed anything in it that it needs to find the database such as passwords or file paths.

hope it helps , but as long as you have a good saved backup in sql.gz file you can move the data, you may want to upload the vb software to the new server. then overwrite it all when you have it setup correctly with your old data
and can use the same config.php file for both databases

[Hoberz]

When I try to restore via the restore a MySql Database option, I get a PHP timeout (could be because it's 10MB in size?)

When I try to restore via phpMyAdmin, I get this message: #1044 - Access denied for user 'thelight'@'localhost' to database 'C278638_thelightninglane'

Can someone explain to me what these errors are?

Thanks!

[borbole]

When I try to restore via the restore a MySql Database option, I get a PHP timeout (could be because it's 10MB in size?)

When I try to restore via phpMyAdmin, I get this message: #1044 - Access denied for user 'thelight'@'localhost' to database 'C278638_thelightninglane'

Can someone explain to me what these errors are?

Thanks!

It looks like the db user hasn'''t gotten full permissions to the db he is assigned to.

About the restoration process, some hosts have file size limit restrictions, so it would be best if you restored it through some other ways. Such as via SSH for ex, if your have SSH access. Or through bigdump.php file or mysql dumper.

[your24hourstore]

When I try to restore via the restore a MySql Database option, I get a PHP timeout (could be because it's 10MB in size?)

When I try to restore via phpMyAdmin, I get this message: #1044 - Access denied for user 'thelight'@'localhost' to database 'C278638_thelightninglane'

Can someone explain to me what these errors are?

Thanks!
as Barbole said its probibly that you have not given yourself full permissions in your new datbase. so go to your database and add yourself to the database but also give yourself all permissions

[Hoberz]

I had permissions in the new database, so it was kind of weird to me.

I had the webhost's support team restore the database for me and it's working now.

Thanks for your help