Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 16, 2012, 06:25:49 PM

Pages: [1]   Go Down
  Print  
Author Topic: Caution - cpanel - My SQL database (watch out for DELETE)  (Read 987 times)
dnelson
Pong! (the videogame) Master
*****
Offline Offline

Posts: 26


« on: June 02, 2004, 12:54:20 PM »

I went into this option today and instead of clicking the Check button I accidentally clicked the Delete button.  Poof - my database was toast.  I would suggest that LP add an enhancement that confirms that you want to take this action as a safeguard.  

This action deleted my phpBB database and luckily I was only experimenting with this so I didn't lose anything really important.

Just thought I would mention it.
Logged
Hush
Senior Moderator
Über Jedi
*****
Offline Offline

Posts: 2903


« Reply #1 on: June 02, 2004, 12:57:00 PM »

Lunar Pages don't have control of most of the C-Panel software functions, as it is written by another company (C-Panel...), but I'm sure they will forward the recommendation, or see if it is something they are able to change.

The best safeguard will always be the most important, before you do anything to anything, back it up.  Computer's, as reliable as they are can still be unpredictable, so back up everything as often as you can.
Logged

<- From the ashes will rise a phoenix ->

Lunarpages Web Hosting || Lunarpages Forums || Lunarpages Affiliate Program
dnelson
Pong! (the videogame) Master
*****
Offline Offline

Posts: 26


« Reply #2 on: June 02, 2004, 01:02:16 PM »

Yes, I do "full backups" on a very frequent basis.  

Do you know of documentation how to get the sql database restored out of the backup file?  If you can point me in the right direction I might try the procedure as a test to see if I can recover from this if it happens again.

Thanks!   Smile
Logged
Hush
Senior Moderator
Über Jedi
*****
Offline Offline

Posts: 2903


« Reply #3 on: June 02, 2004, 01:11:22 PM »

If you open PHPMYADMIN from C-Panel's Database section, then select your database on the right hand side of the screen, you will see a tab at the top of the screen labeled 'SQL'.  Click this, then the browse button about half way down.  This will allow you to browse your computer for the backup file.  Once you have found it, clicked ok and then the Go button (in PHPMYADMIN) it should upload the backup.

Or if you have the SQL backed up in a text file, open it and copy the contents, then do as above, but paste the SQL into the white text box rather than clicking the browse button, now click go.

Also in the Backup section of C-Panel there is a database restore tool there, which should work in a similar way.

If you open PHPMYADMIN, you should see a link to the user manual near the bottom of the screen, this is the full online manual which will explain in depth how to restore a backup.
Logged

<- From the ashes will rise a phoenix ->

Lunarpages Web Hosting || Lunarpages Forums || Lunarpages Affiliate Program
dnelson
Pong! (the videogame) Master
*****
Offline Offline

Posts: 26


« Reply #4 on: June 02, 2004, 01:14:52 PM »

Thanks for the info - I'll check it out!   Applause
Logged
Hush
Senior Moderator
Über Jedi
*****
Offline Offline

Posts: 2903


« Reply #5 on: June 02, 2004, 01:35:36 PM »

You're welcome.  Thumbs Up
Logged

<- From the ashes will rise a phoenix ->

Lunarpages Web Hosting || Lunarpages Forums || Lunarpages Affiliate Program
Pages: [1]   Go Up
  Print  
 
Jump to: