Web Hosting Forum | Lunarpages
News: July 14, 2008 - New Contest! - Submit Your WordPress Theme Designs, Win BIG!
August 25, 2008 - Time to Vote for the August 2008 Site of the Month!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
August 29, 2008, 11:26:06 PM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Caution - cpanel - My SQL database (watch out for DELETE)  (Read 262 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
Über Jedi
*****
Offline Offline

Posts: 2760



« 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


<-Link Removed By Hush - Never To Reinstated->
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
Über Jedi
*****
Offline Offline

Posts: 2760



« 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


<-Link Removed By Hush - Never To Reinstated->
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
Über Jedi
*****
Offline Offline

Posts: 2760



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

You're welcome.  Thumbs Up
Logged


<-Link Removed By Hush - Never To Reinstated->
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.3 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM