How do I move my existing database to Powweb?

[slipmode]

How do I move my current mysql database to Powweb? Also how does the forums that I will load under my htdocs of my site point over to my database?

[gillcouto]

Use phpMyAdmin to upload your db dump file. Depending on what forum software you're using, it may also have a db restore feature, except it won't work until the forum is running. You should really follow the instructions in your forum software first. They'll explain how to configure the db access settings. It may be easier if you divide the db move into two steps: first install and run the forum and save the initial db it creates, then upload your old db and in phpMyAdmin update the config table for the new host settings which you can get from the initial db dump. If it takes three tries, that's pretty good.

[slipmode]

I have uploaded my sql database as well as upload my forum files to the webserver. I use phpbb 2.0.8.

My database was previously on another server before and it had a different database name and used a different username then the new ones I had to create for powweb. I updated the config for the forums to the new username and database name and I also assumed I should point the location of the database to mysql01.powweb.com. I am not able to get the forums to connect to the database. Is there anything in the actual sql files that has the old database name and old username that I need to correct? Also am I specifying the location correctly to the sql files?

[mikadit]

try to login your database using the http://phpmyadmin.powweb.com. or from your OPS
check the FAQ, BOOK MARKED THREADS, READ THIS FIRST (http://forum.powweb.com/showthread.php?t=30966) posted by Pig , where he mantain all most important and necessary threads bookmarked and the very usefull Halfabee' scripts (http://forum.powweb.com/showthread.php?s=&threadid=20022) to restore and split your databes if needed, if your backup is more of 72000 lines you will need to split it

[gillcouto]

Whenever you upload a database, some values may need to be modified manually for the new server. You can manually edit the sql file itself before uploading or go to phpMyAdmin after uploading. Some values in the phpbb_config table need to be updated. If your table prefix is different you'll see it. Edit these values in the table with your new values:

cookie_domain www.yourwebsite.com
script_path /phpbb2/
server_name www.yourwebsite.com

Then check the admin configuration page for everything else. The phpbb2/config.php file also needs to be updated, but that's normally handled by the install script, double check it anyway. Don't forget that nothing runs until you delete or rename the phpbb2/install directory. :cool: