| carlos.poon |
|
NetHosted Customer

Joined: 20 Sep 2004 Posts: 88 Location: London, UK
|
Posted: Sun Oct 17, 2004 7:11 pm Post subject: [Fixed]how to restore website including database. |
| |
Hello Andrew,
While working on a local copy of my site, I managed to mess up a few things.
I was testing doing a backup of my MySQL database locally via a php interface.... and Somehow (this puzzles me) it connected to the "Live" site hosted on NetHosted, and restored a different database to the site... Now I just get a blank page when I try to access the domain on NetHosted.
Is there anyway to restore the site to how it was a week ago (including the database)? I know I should to taken better care!
Or is it all lost?
Thanks
Carlos
Last edited by carlos.poon on Wed Jan 26, 2005 3:48 pm; edited 1 time in total |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 7:17 pm Post subject: |
| |
Let me just look over our backups carlos
Andrew _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 7:22 pm Post subject: |
| |
Ok which database (what name) are you having problems with? _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| carlos.poon |
|
NetHosted Customer

Joined: 20 Sep 2004 Posts: 88 Location: London, UK
|
Posted: Sun Oct 17, 2004 7:26 pm Post subject: not sure totally |
| |
Andrew i'm not to sure...
Basically waht happened was that i download the database from the hosting.
While "playing" with it locally it somehow knew that it was from the live site, and restored a "messy" database back to the hosting.
As to the name of the database.. I'm not sure of that... if there are 2 that you can see... I'm not totally sure which i was using...
The messup was on Friday.. so any day before that will help a lot..
Carlos |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 7:28 pm Post subject: |
| |
Ok, give me a bit of time to sort it all out for you. I will update this thread asap.
Andrew _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| carlos.poon |
|
NetHosted Customer

Joined: 20 Sep 2004 Posts: 88 Location: London, UK
|
Posted: Sun Oct 17, 2004 7:29 pm Post subject: add info |
| |
I guess that with the original hosting package, there may have been a test/empty database. As far as i know i just added to the original database.
Sorry for being a pain. I'll make better notes of what I'm doing in the future.
Carlos |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 8:00 pm Post subject: |
| |
Frustratingly Carlos our backup is from the 16th @ 18:04 and the page is still coming up blank.
Andrew _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| carlos.poon |
|
NetHosted Customer

Joined: 20 Sep 2004 Posts: 88 Location: London, UK
|
Posted: Sun Oct 17, 2004 8:04 pm Post subject: i see |
| |
Andrew,
Hello, Is it blank after a database restore, or blank after a website + database restore?
Any day before the 15th it was working.
Carlos
Last edited by carlos.poon on Sun Oct 17, 2004 8:05 pm; edited 1 time in total |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 8:05 pm Post subject: Re: i see |
| |
| carlos.poon wrote: | Andrew,
Hello, Is it blank after a database restore, or blank after a website + database restore?
Carlos |
I only restored the database as that is what you said you'd been playing with?
Andrew _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| carlos.poon |
|
NetHosted Customer

Joined: 20 Sep 2004 Posts: 88 Location: London, UK
|
Posted: Sun Oct 17, 2004 8:06 pm Post subject: |
| |
i did my "playing/messup" on the 15th..
If you don't have an earlier backup.. then i guess that's it (it's my own fault)
If there is no earlier backup, can you blank the site, and put it back to its original state (when i 1st joined NetHosted)?
thanks
Carlos
Last edited by carlos.poon on Sun Oct 17, 2004 8:09 pm; edited 1 time in total |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 8:08 pm Post subject: |
| |
| carlos.poon wrote: | | i did my "playing/messup" on the 15th |
Right, but our current backup of your site was taken on the 16th at 18:04 so isn't any use in this situation it would seem.
Andrew _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| carlos.poon |
|
NetHosted Customer

Joined: 20 Sep 2004 Posts: 88 Location: London, UK
|
Posted: Sun Oct 17, 2004 8:10 pm Post subject: |
| |
| If there is no earlier backup, can you blank the site, and put it back to its original state (when i 1st joined NetHosted)? |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 8:13 pm Post subject: |
| |
| carlos.poon wrote: | | If there is no earlier backup, can you blank the site, and put it back to its original state (when i 1st joined NetHosted)? |
No, no earlier backups I'm afraid we keep the most recent only.
Blank your site? That would mean we'd delete all your emails, cron jobs, files the lot - wouldn't it just be easier for you to delete all your files via FTP?
Andrew _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| carlos.poon |
|
NetHosted Customer

Joined: 20 Sep 2004 Posts: 88 Location: London, UK
|
Posted: Sun Oct 17, 2004 8:21 pm Post subject: latest |
| |
Hello,
I haven't setup any cron jobs or emails yet....
The only reason i said "blank" was that i'm not totally sure how the whole thing works:
Not sure where the database is stored.
Not sure how to blank the current database (now i messed it up)
Not sure if i need a blank database to reinstall all my phpBB stuff
If I can get things back to the "original joined" state I could fix things, do I just delete everything via ftp in "public_html"?
Carlos |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff

Joined: 22 Mar 2004 Posts: 5684
|
Posted: Sun Oct 17, 2004 8:23 pm Post subject: |
| |
I see, well in that case would you like to restore your account as if you had just signed up (e.g. we'd restore it using your original welcome email, same passwords etc)?
Andrew _________________ | Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
User Permissions |
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum
|
| |