Any chance?

Is there a chance that when I switch hosts to hostgator.com, can I transfer my Invision Power Board v1.3 forum to my new hostgator account? I wouldn't like to lose all the posts and everything.

[circpros]

If you back up the database, you can load it seamlessly onto a new installation - very easy. I f you have a lot of board mods, you'll want to back up the files as well.

Not a difficult thing to do if you have the requisite knowledge. If not, Hostgator can probably help.....

Originally Posted by circpros

If you back up the database, you can load it seamlessly onto a new installation - very easy. I f you have a lot of board mods, you'll want to back up the files as well.

Not a difficult thing to do if you have the requisite knowledge. If not, Hostgator can probably help.....

Just tell me the steps and I can do it myself!

[whoahorse]

I am actually in the process of doing this as well. Is anyone here an SQL wizzard? LOL

Look at the errors I get:

http://www.whoahorse.com/forum

http://www.peacehorse.com/forum

Weezy

[circpros]

Just perform a full backup in phpmyadmin, install the board at the new location, then dump the existing database info into the new database through phpmyadmin (or the database restore tool if invision has one - Don't use it, don't know)......

Sorry for being such a newbie, but how do I backup my database?

[whoahorse]

I actually just switched to SMF - LOVE IT!

We did loose alot of threads, but wow this is one VERY KEWL board!!

Weezy

[circpros]

Everyone was a newbie once...... I've been tinkering a while myself, but I still ask newbie questions..... but that's because I'm dense.

To back up your database in PHPmyadmin:

Open phpmyadmin (in your cpanel). Select the database you wish to back up from the drop-down menu on the left.

When the DB summary loads, click the top tab marked 'export'. The default backup settings should be sufficient, so just click the box that says 'save file as', and change the name if you wish (the default name is __DB__).

Click the go button at the bottom, and you'll be prompted to save the file like any other download.

If successful, you have just backed up your DB. Many forum software have integrated functions to do a back up (or recovery) as well, but you should get at least marginally familiar with phpmyadmin anyway!

[whoahorse]

Where is phpmyadmin in the cpanel??

Weezy

[amartins]

MySQL Databases, when in there scroll to the bottom of the page and you'll see a link to phpmyadmin.

Antonio.

[whoahorse]

Hey Antonio!

This is great, I hope it works for me..

How or where to I upload this database? I can't see anything in the phpadmin area?

Weezy

[whoahorse]

Originally Posted by circpros

Open phpmyadmin (in your cpanel). Select the database you wish to back up from the drop-down menu on the left.

What if you don't see a drop down menu?

Weezy

[amartins]

Hi,

That means u dont have a database created yet, go into the database menu (before phpmyadmin) and create the DB then setup a user associated with that database. Afterwards that is done go to phpmyadmin select the database, then upload your file.

You will also have to tinker a bit with your config files because your database name and username data will be different from your previous host.

HTH

Antonio.

[whoahorse]

I think this is getting over my head. LOL!

Weezy

[amartins]

Well what I meant was that at your previous host your database may have been say:

database: weezy
username: weezy
password 12345

On HG's servers your database will have a prefix which is the username for the domain u are setting up on. So for example say your username for the domain is "izzy" your databases will be izzy_name

in this case:

database: izzy_weezy
username izzy_weezy
password 12345

This is only important for your software's configuration where it asks you for database name.. username etc (usualy config.php)

Setting things up is real simple:

log in to the cpanel:

1- press the mysql database icon
2- create your database ADD DB
(this will now be the database name in your config file)
3- create a username/password ADD USER
(this will now be the database user in your config file)
4- add the user to a database giving that user all privileges ADD USER TO DB
(be sure u are adding the correct username to the database)
5- press phpmyadmin
4- select the database then press SQL on the top menu and upload your SQL file (depending on the size it may take a while, when done phpmyadmin will inform you of the results)

Your database will now exist and will be populated with the data you have backed up from your other host.

The final thing is to set up your software to work with this database (this has to do with what I wrote at the start of this email) edit the databasename, username and any other relevant fields so the software connects to the mysql db with the correct login data.

Thats it! DOn't worry, once you do one you will be an expert and this way is much easier than doing it through telnet )

Antonio.

[whoahorse]

Hey Antonio!

Thanks so much for all your help!

Very appreciated!

Weezy

How do I upload a backup that I just made?

[whoahorse]

In the cpanel

There is an area for backup.. have you found it?

Weezy