Go Back   WarriorForum - Internet Marketing Forums > The Warrior Forum > Main Internet Marketing Discussion Forum
Register Blogs FAQ Social Groups CalendarHelp Desk

Reply
 
LinkBack Thread Tools
Old 11-16-2009, 03:16 PM   #1
Warrior C
War Room Member
 
Wealthyclark's Avatar
 
Join Date: Oct 2009
Posts: 433
Thanks: 42
Thanked 52 Times in 30 Posts
Default Backing up wordpress database

Can anyone give me a simple solution to back up my blog in the case something goes wrong. I use hostgator hosting
Wealthyclark is offline   Reply With Quote
Old 11-16-2009, 03:22 PM   #2
Active Warrior
 
Join Date: Oct 2009
Location: Pennsylvania
Posts: 36
Thanks: 3
Thanked 6 Times in 6 Posts
Default Re: Backing up wordpress database

Quote:
Originally Posted by Wealthyclark View Post
Can anyone give me a simple solution to back up my blog in the case something goes wrong. I use hostgator hosting
The WP DB Backup plugin works well in a pinch.
Ebo Etoyep is offline   Reply With Quote
Old 11-16-2009, 03:23 PM   #3
Advanced Warrior
War Room Member
 
dean_holland's Avatar
 
Join Date: Nov 2008
Location: England UK
Posts: 541
Thanks: 182
Thanked 216 Times in 79 Posts
Social Networking View Member's Twitter Profile 
Default Re: Backing up wordpress database

Hi

not sure of the name in all honesty but there is a plugin you can use that will do this and email you the backup at your specified timeframe ...

Do a quick search for wordpress backup plugin ... that should find it

Dean


dean_holland is offline   Reply With Quote
Old 11-16-2009, 03:23 PM   #4
Glad I Got Canned
 
Join Date: Sep 2008
Location: NY
Posts: 681
Thanks: 330
Thanked 61 Times in 57 Posts
Social Networking View Member's Twitter Profile  View Member's YouTube Profile
Default Re: Backing up wordpress database

Go to your CPanel, open phpMyAdmin.

Select your database.

Choose "Export." Choose CSV as the format. (You can export as Excel too, but I've found it less than perfect. Choose SQL for perfection but it's a much bigger file.)

Copy the output to Notepad and save it as "Mybackup.csv" or something similar.

SurviveUnemployment is offline   Reply With Quote
Old 11-16-2009, 03:23 PM   #5
Advanced Warrior
War Room Member
 
dean_holland's Avatar
 
Join Date: Nov 2008
Location: England UK
Posts: 541
Thanks: 182
Thanked 216 Times in 79 Posts
Social Networking View Member's Twitter Profile 
Default Re: Backing up wordpress database

Hi again ...

That got posted while I was typing .. thats the one above !!


dean_holland is offline   Reply With Quote
Old 11-16-2009, 03:30 PM   #6
Warrior Member
 
Join Date: Oct 2009
Posts: 18
Thanks: 0
Thanked 1 Time in 1 Post
Default Re: Backing up wordpress database

i assume each website should be backed up and saved as the csv file
stream2 is offline   Reply With Quote
Old 11-16-2009, 03:33 PM   #7
Watching you...
War Room Member
 
Istvan Horvath's Avatar
 
Join Date: Dec 2008
Location: Waterdown, Ontario, Canada
Posts: 5,983
Blog Entries: 2
Thanks: 1,575
Thanked 2,719 Times in 1,656 Posts
Social Networking View Member's FaceBook Profile  View Member's Twitter Profile  View Member's YouTube Profile
Contact Info
Send a message via Skype™ to Istvan Horvath
Default Re: Backing up wordpress database

Quote:
Originally Posted by stream2 View Post
i assume each website should be backed up and saved as the csv file
Since each website has its own database... the answer is yes.

(I do prefer the phpmyadmin > Export > SQL > as file route; clean and simple)

In the first half of the year we are supposed to work for the taxman. I think that's a mistake.
Help me to get rid of the taxman ASAP - thanks! (You, too, should make less mistakes!)


Istvan Horvath is online now   Reply With Quote
Old 11-16-2009, 05:01 PM   #8
Ken Katz
War Room Member
 
koolphoto's Avatar
 
Join Date: Apr 2005
Location: NY, CA , USA.
Posts: 563
Thanks: 55
Thanked 45 Times in 34 Posts
Default Re: Backing up wordpress database

If you want a good plugin to backup the wordpress database: WordPress › WP-DB-Backup WordPress Plugins

I usually backup my full site and the database. Here's how:

Go to cpanel>backups. Click Download a MySQL Database Backup. It will be downloaded to your computer.

Then you can backup your site by clicking: Download a Home Directory Backup

My name is Ken Katz and I am a web designer and photographer.
koolphoto is offline   Reply With Quote
Reply

  WarriorForum - Internet Marketing Forums > The Warrior Forum > Main Internet Marketing Discussion Forum

Tags
backing, database, wordpress

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -6. The time now is 08:28 AM.