[SOLVED] Hopefully the dumbest question of the day.

For discussion and questions related to CMS Specific templates and stylesheets (CSS), and themes. or layout issues. This is not a place for generic "I don't know CSS issues"
Post Reply
User avatar
genestevo
Forum Members
Forum Members
Posts: 72
Joined: Thu Jan 26, 2012 11:50 am

[SOLVED] Hopefully the dumbest question of the day.

Post by genestevo »

Hi Guys,
I've never backed up a data base before but the guy I'm building the site for worries about the sort of thing that happens whey somebody says "Don't worry, that never happens...".
I'd already downloaded the contents of the site root via FTP. Have I done the next bit right? This is what I did:
1. Logged into my cpanel and then into phpMyAdmin
2. Clicked on the name of the relevant database in the left hand column
3. Clicked the export button on the main top menu
4. Clicket the Custom radio button and then realised I didn't understand any of it so clicked the Quick radio button instead
5. Left the format drop down as SQL
6. Hit the go button.
I now have all the data I retrieved via FTP and a file named after my data base which has an .sql extension.
Do I now have all I need to rebuild/restore the site in the unlikely event my most excellend host (UK2.net) gets abducted by aliens?
I hope so because the Custom option may as well have been writen in Mandarin.
Cheers,
Gene Stevo.
Last edited by genestevo on Sun Feb 26, 2012 10:03 pm, edited 1 time in total.
Wishbone
Power Poster
Power Poster
Posts: 1368
Joined: Tue Dec 23, 2008 8:39 pm

Re: Hopefully the dumbest question of the day.

Post by Wishbone »

That's about it! Now, before you need it, try doing a restore on the side and make sure it works. :)

Copy the files to a sub directory or subdomain, create another database, import the SQL file, make database, path, and URL changes in the config.php, and adjust anything if needed in .htaccess, then check to see if the backup worked.
User avatar
genestevo
Forum Members
Forum Members
Posts: 72
Joined: Thu Jan 26, 2012 11:50 am

Re: Hopefully the dumbest question of the day.

Post by genestevo »

Thanks for the advice Wishbone. I'll do that to put my mind at rest if nothing else!
I always get nervous messing with stuff I know sod all about. Nice to know I can test the method.
Cheers, and thanks again.
Another one solved :)
Gene Stevo.
Post Reply

Return to “Layout and Design (CSS & HTML)”