It is currently Thu Mar 28, 2024 9:06 am


All times are UTC


Forum rules


Please click here to view the forum rules



Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Backing Up MYSQL Database
PostPosted: Fri Mar 24, 2006 4:44 pm 
Noobie
Noobie

Joined: Mon Oct 24, 2005 6:13 am
Posts: 5
I would like to know if there is a way that my database can be backed up so that I can make sure that nothing screws my database up with the changes I have to do online tonight.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 24, 2006 4:53 pm 
Site Admin
Site Admin

Joined: Fri Feb 11, 2005 7:43 am
Posts: 1818
Location: 100WebSpace's Headquarters
You can backup your database from the phpMyAdmin section of your web hosting control panel. Login to phpMyAdmin. Click on your database (on the left you see the name of the database and all tables under the database, click on the name of your database), then click on "Export" from the top navigation menu. Check the "Save as file" check-box and click on the "Go" button in the bottom right corner. There you go! :)

_________________
Read the F.A.Q. before asking a question!


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 24, 2006 5:09 pm 
Noobie
Noobie

Joined: Mon Oct 24, 2005 6:13 am
Posts: 5
Thank you for giving me this insight...

I have done this now the question would be is..

If I do screw something up then how do I get this BACKUP back on line so that everything will be fine again.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 24, 2006 5:21 pm 
Site Admin
Site Admin

Joined: Fri Feb 11, 2005 7:43 am
Posts: 1818
Location: 100WebSpace's Headquarters
I should have explained this too :) In the phpMyAdmin there are 5 icons on the left navigation menu, the middle one says SQL, click on it and a new window opens where you see "Import file" in the top navigation links. There you can import the file that you have exported.

_________________
Read the F.A.Q. before asking a question!


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 24, 2006 5:22 pm 
Moderator
Moderator

Joined: Thu Dec 15, 2005 2:59 pm
Posts: 681
Location: England
Click on the SQL tab and paste the contents of your backup, or locate the SQL file and hit go. This will restore all data from the backup.

Edit Oliver posted his message a split second before me hah! :D

_________________
Mountain biking forum ;)
Ponds and fishkeeping :D


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 24, 2006 5:40 pm 
Noobie
Noobie

Joined: Mon Oct 24, 2005 6:13 am
Posts: 5
Thank you both for getting me to where I need to be before tonight...


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ]  Moderators: fhmagic, KJ, Moderators, Support Team

All times are UTC


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 post attachments in this forum

Search for:
Jump to:  
100WebSpace © 2011