[Lonestar]

Recently my clan United Gamers Coalition *pimp* http://planetugc.com *pimp* have decided to move to a new host. The new host is a major upgrade, and will change our second url (unitedgamerscoalition.com to ugcworld.com).

I have done an entire site backup for both URL's, done an entire MySQL Export for all DB's.

Our forums are done with YaBB and it uses an SQL DB. Ive backed up the entire SQL DB, and tried to dump that into another DB we have on other host, but it seems to upload forever and i give up.

I know the forum is huge and shld take time, but maybe im wrong and it wont.

Therefore what i need is anyone with experience with this type of stuff can accurately give me a good layout on how to move an entire site and MySQL Database to another host without losing info would be greatly appreciated.

Im sure ive figured out all the proper steps (except for the MySQL part) but would like some good advice from experienced people to ensure no info is lost. I only have 4 days in which to prepare so a speedy reply is appreciated.

Anyone who helps will have UGC's gratitude and a mention on our frontapge news and a link to this wonderful forum from our site. So your doing me and HLP a favor as we have of traffic come through their. I know its a bribe but u guys are the only place i wld ask and know i can find an answer.

Thanks ahead of time.

[vadar_1]

Well the surefire way is to load up phpmyadmin, and recreate each field by hand...

etc: 14 years

wait, what was your time budget again?

[an0n]

http://www.mysql.com/doc/en/Backup.html

Use phpMyadmin's little query window text-box thingy to run the commands.

Dump onto the old server. Download the back-up. Upload it to the new and methinks even YaBB will have some kind of auto-database-import thingy.


Also, don't use YaBB. It ****ing sucks. Use phpBB2, CuteCast or Invision, or get a vB if you can afford it.

[Stealth]

hey an0n, what's a good mySQL tutorial site

[Lonestar]

Originally posted by an0n
http://www.mysql.com/doc/en/Backup.html

Use phpMyadmin's little query window text-box thingy to run the commands.

Dump onto the old server. Download the back-up. Upload it to the new and methinks even YaBB will have some kind of auto-database-import thingy.


Also, don't use YaBB. It ****ing sucks. Use phpBB2, CuteCast or Invision, or get a vB if you can afford it.

We have thought of a new board, however YaBB does its job flawlessly. If it aint broke, i dont plan spending time fixing it.

What im doing right now is i did an entire backup of the site, and attempting to restore a backup on the new host. However it seems to be uploading forever, but i guess thats normal for a site that is 125MB in size.

I tried the dump thing with SQl and it took a long time to, might just start it and let it go all night one night.

[an0n]

The NW forums have like 5000 posts in a 6mb database and they take around.........well, less than a minute. So get a rough estimate of how long it should take then start dumping and wait [however long] +10 mins.

You sure the site has enough space for the database to dump to?


Oh, and check out http://www.phpbb.com it literally takes like 30 seconds to install.


Stealth: Looky looky
And here

[Lonestar]

So the file i have must be corrupt.

I have over 175MB of space on the server im transferring to. More then enough room for just the forum area as it takes up only around 75MB

[an0n]

Originally posted by Lonestar
So the file i have must be corrupt.

Why?

[Lonestar]

Here's what i did.

I went to MySQL, and did a dump of the entire Database, i saved the data and structure and it gave me an SQL file within a zip.

I unzipped the SQL file, then went to new server, and tried to dump that SQL file into a new database. it loads for more then 30min. before i give up.

I did an entire site backup, through my webhost. it asks me to dwnload stuffit expander, which i do and install. I then download the backup file. When opening the file it says the file is corrupted or some **** like that. When i use winrar on the tar file my host gives me it says unexpected end of archive.

All i want to do is move the one Database over to a different host. I figure getting an SQL file of the data and structure will suffice as i have done that before. Now it seems i was dreaming that day and i cant do it today.

Step by step would help, if you could.

[Lonestar]

What i cld do, is download a new Board (PHPbb2) install it in the new server, then get a converter from YaBB to PHPbb2 and do it this way.

PHPBB2 only wants the SQL file from the Database right to convert from it? Or is it more complicated?

Let me know, the board is all that matters to me, the rest i can delve into tomorrow when i get my patience back.

[an0n]

Methinks phpbb2 should only need the sql file. Never imported a YaBB database before though so I can't be sure.

*will check*

And as for the site back-up, try getting the latest versions of WinZIP and WinRAR and trying to decompress the file. If that doesn't work then it's ****ed and you'll need to back it up again.

[Lonestar]

Well all i ended up doing was exporting the data and structure of the SQL Database i wanted. opened it in a text editor and copied and pasted bits at a time in the query box. Once i queried the entire file, i ran the setup of the board giving it new DB info, once installed it took the new DB posts and users and settings and put it into the newly installed board.

Very simple steps, however an SQL file of a forum is quite big for text editors and a p3 450.