Moving from one host to another

[kat]

The backup I have is of the entire site, not just the forum.

Let's see how this database restore goes, first.

[user1234]

Might need to contact your host, if my retry fails.

Their answer will be that they don't support 3rd party applications.
Though that can't be their answer as to where the "backup" and "restore" section of the control panel is.

[kat]

All you need to tell them, is that you need to run that query, in MySQL, so that you can import the database.

It only needs to be temporary, after all.

Most of it seems to be there.

I stopped the forum upload, to let this have all my bandwidth.

Once that's done, I'll finish upping the forum and we'll see what happens, ay?

[user1234]

All you need to tell them, is that you need to run that query, in MySQL, so that you can import the database.

It only needs to be temporary, after all.

Most of it seems to be there.

I stopped the forum upload, to let this have all my bandwidth.

Once that's done, I'll finish upping the forum and we'll see what happens, ay?

I dialed, then pressed 2.
Brad answered immediately. He offered to walk me through it.
Since I don't know what you have where it is impossible for me to be in the middle of this.
Could you please, please, please call?
Brad said that anyone there could help, but if you get a guy that doesn't seem real swift, you maybe should ask for Brad.

[kat]

Heh... From here, in England, that call would cost me megabucks!

If you just tell him that you need to run this query:

SET GLOBAL max_allowed_packet=1000000000;

in mysql, you'll be laughing.

Not yet, though. I'm still retrying and it's got further than before, already. So, we MIGHT be OK.

[user1234]

Heh... From here, in England, that call would cost me megabucks!

I thought you were domestic when you inquired about "across the pond" I thought you thought I was English. Toll free here.
I called and didn't get any further than last time

If you just tell him that you need to run this query:

SET GLOBAL max_allowed_packet=1000000000;

in mysql, you'll be laughing.

Not yet, though. I'm still retrying and it's got further than before, already. So, we MIGHT be OK.

Can you go to the "support" while inside the account and request what you need on a ticket?

[kat]

Yeah, probably.

If this fails, again, I'll give it a go.

Mind you, a 500 meg database is pretty huge.

Maybe you have ******loads of stuff in your error logs, or something.

[user1234]

Maybe you have ******loads of stuff in your error logs, or something.

If that is something I was supposed to empty or do something about, it's got 2 years worth.
If it generates an email announcing every database error, over 2 years there were only a dozen or so such messages sent to me.

There aren't that many images in the forum either, if that matters.
If you did a full backup of my entire hostmonster account, it includes my website too. I don't think the website is all that big, and it is in antique software with no bells or whistles.

[MrPhil]

Yeah, if you're moving to a new host (new server), this might be a good time to clear out the log, particularly the error log, tables. That might cut your database down quite a bit in size, and preferably should have been done before backing up the database (unless you had no opportunity to do so). Worst case, you can manually edit the .sql file and delete all the INSERT INTO smf_log_errors commands. Incidentally, if your .sql file is too big to import all at once, feel free to use an editor to break it up into smaller pieces (so long as you CREATE a table before you INSERT data into it). Once you're settled in and running again, keep an eye on the error log for a while, as the change in PHP levels and configuration details (not to mention file corruption from the move) could cause lots of errors to pop up.

[kat]

Well, it's still upping, so keep fingers crossed, eh? 

[user1234]

Yeah, if you're moving to a new host (new server), this might be a good time to clear out the log, particularly the error log, tables. That might cut your database down quite a bit in size, and preferably should have been done before backing up the database (unless you had no opportunity to do so). Worst case, you can manually edit the .sql file and delete all the INSERT INTO smf_log_errors commands. Incidentally, if your .sql file is too big to import all at once, feel free to use an editor to break it up into smaller pieces (so long as you CREATE a table before you INSERT data into it). Once you're settled in and running again, keep an eye on the error log for a while, as the change in PHP levels and configuration details (not to mention file corruption from the move) could cause lots of errors to pop up.

Thank you Mr. Phil, though a little discouraging regarding your "file corruption" note. 
Unfortunately my host canceled my account during the DDoS attack and took my site down. I did a full in-forum backup the week before.
I still have access to the my CPanel files but won't for very much longer.

I'm afraid I migrated to the wrong host because they use Plesk.
Seems incomplete or at least difficult.

[user1234]

Well, it's still upping, so keep fingers crossed, eh? 

I still am.
What is the in-forum, full-backup function for, if it isn't useful?
When and/or how is it applied?
(whoops sorry, I should have searched the subject first)

[kat]

I've never worked that out, myself.

I think it's just the database.

Still going...

[user1234]

I've never worked that out, myself.

I think it's just the database.

Still going...

Your cat icon aptly describes what's going on.
I just found this description of the "too big" upload message
http://docs.simplemachines.org/index.php?topic=490.msg5447#msg5447

Since it's still going do you think that Brad figured out what we needed, or did you fill out a ticket?

[kat]

I think we have a database!

Just going to up the rest of the forum.

This could take a while...

[user1234]

I think we have a database!

Just going to up the rest of the forum.

This could take a while...

I just found this subject described a little differently than I didn't before. Did you ever get the
   3. Select the Restore database from backup file check box.
selection?
_________________

If the database does not exist and you need to recreate it from scratch:

   1. Go to Home > Databases and click Add New Database.
   2. Specify the database name, type and server for the database you are restoring.

      Note. You can specify a new database name, but you must choose the correct database type: for example, if you are trying to restore a MySQL database, choose MySQL database type.

   3. Select the Restore database from backup file check box.
   4. Specify the location of the database backup file. You can upload a backup file from your local machine or specify a file located on the server.
   5. Provide the default username and password for the restored database.
   6. Click OK.

      If you are restoring MS SQL database, there is a possibility that some database users will be orphaned. In order to provide the ability to access and use the database for these users, you need to repair them. Refer to Recovering Orphaned Database Users section for more information.

[kat]

Yeah, I waded through most of that.

Still I got there, in the end.

Just upping the actual forum, now.

It's gonna take a while, coz you have billions of different languages and things, there.

It's gonna take an hour, at least.

[user1234]

Maybe you have ******loads of stuff in your error logs, or something.

It just dawned on me. Would 4 DDoS attacks over the last year have caused it to log a gillion errors?
The little "most online today" meter had counts of 700 and 800 before the site went into dysfunction.
I think that "most ever online at one time" count is something like 850

[kat]

No idea, to be honest.

When we've got this up'n'running, maybe we can empty some of the logs out.

It's still only 1% done, so we're gonna have to sit tight and wait, for this.

[kat]

5% **Yawns**