You must be logged in to post Login


Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

WordPress Database Maintenance and Backup

UserPost

9:50 am
December 9, 2010


Buck Inspire

Member

posts 1546

Post edited 9:51 am – December 9, 2010 by Buck Inspire


Hi all,

 

Enjoying my new self-hosted site, but there is one blemish.  Frown  After importing my old data into the new site, it has a 0 in the Archives section linking to my December posts.  My guess is it's a bad record in my database.  Any tips on how to modify my WordPress database?  Speaking of which, how do you all backup your databases?  Sorry for the technical questions.  Can't we just blog?!?! Yell

 

Thanks,

Buck

12:45 pm
December 9, 2010


Buy Like Buffett

Member

posts 1682

I use the wordpress database backup plugin. It works quite well.

 

 

Mark

Learn how to build wealth at Buy Like Buffett.

Learn about making money online at Mark Riddix dot com

Follow me on Twitter

1:19 pm
December 9, 2010


Budgeting in the Fun Stuff

Member

posts 3048

Buy Like Buffett said:

I use the wordpress database backup plugin. It works quite well.


I use the Wordpress Database Backup too.  I also backup my sites through Host Gator once a week.  :-)

Crystal

Yakezie Member Site: 

Budgeting in the Fun Stuff

Ebook:  How I Make Money Blogging:
The Beginner's Guide to Building a Money-Making Site

Email:  budgetingfunstuff *at* gmail *dot* com

You can also find me on Twitter and Facebook

12:49 am
December 10, 2010


Buck Inspire

Member

posts 1546

Hey Mark and Crystal,

 

Thanks, I was about to load up the plugin when I noticed on my hosting admin page, database backup.  Doh! Surprised

 

Budgeting in the Fun Stuff said:

Buy Like Buffett said:

I use the wordpress database backup plugin. It works quite well.


I use the Wordpress Database Backup too.  I also backup my sites through Host Gator once a week.  :-)


1:19 am
December 10, 2010


Buy Like Buffett

Member

posts 1682

Use them both like BITFS. I backup on Hostgator as well but the WP Database Backup saves some files that the hosting provider may not.

 

 

Mark

Learn how to build wealth at Buy Like Buffett.

Learn about making money online at Mark Riddix dot com

Follow me on Twitter

4:34 am
December 10, 2010


Glen Craig

Member

posts 1087

With the database plugin you can set it to email you a copy of your database every day.  This way should something ever happen to your host you still have your database (assuming your email isn't tied to your host).

7:40 am
December 10, 2010


Buck Inspire

Member

posts 1546

Thanks Mark, will do! Cool

 

Buy Like Buffett said:

Use them both like BITFS. I backup on Hostgator as well but the WP Database Backup saves some files that the hosting provider may not.


7:41 am
December 10, 2010


Buck Inspire

Member

posts 1546

Good deal, thanks for the help! Smile

 

Craig – Free From Broke said:

With the database plugin you can set it to email you a copy of your database every day.  This way should something ever happen to your host you still have your database (assuming your email isn't tied to your host).


12:12 pm
December 11, 2010


Buck Inspire

Member

posts 1546

I'm now using it and schedule a weekly backup.  Easy to use.  Thanks again! Smile

 

Buy Like Buffett said:

Use them both like BITFS. I backup on Hostgator as well but the WP Database Backup saves some files that the hosting provider may not.


12:17 am
December 14, 2010


Buck Inspire

Member

posts 1546

In case anyone is interested I fixed my one blemish!  After importing my old posts apparently there was the Hello World first post.  Digging into my database with phpAdmin, I saw it had a post date of 0.  I deleted it and Viola! Embarassed

 

Buck Inspire said:

Hi all,

 

Enjoying my new self-hosted site, but there is one blemish.  Frown  After importing my old data into the new site, it has a 0 in the Archives section linking to my December posts.  My guess is it's a bad record in my database.  Any tips on how to modify my WordPress database?  Speaking of which, how do you all backup your databases?  Sorry for the technical questions.  Can't we just blog?!?! Yell

 

Thanks,

Buck



About the Yakezie.com Forum

Forum Timezone: America/Los_Angeles

Forum Stats:

Groups: 2
Forums: 9
Topics: 6383
Posts: 84794

Membership:

There are 13651 Members
There have been 20 Guests

There are 9 Admins
There are 8 Moderators

Top Posters:

My Personal Finance Journey – 3159
Khaleef @ KNS Financial – 3149
Budgeting in the Fun Stuff – 3048
Sustainable PF – 2759
Miss T @ Prairie Eco-Thrifter – 2213
Eric – PersonalProfitability.com – 2120

Administrators: The College Investor (1935 Posts), Financial Samurai (1803 Posts), LaTisha @YoungFinances (1715 Posts), Forest Parks (1337 Posts), 20s Finances (1147 Posts), Money Reasons (697 Posts), Chris Johnson (78 Posts), Sydney at Untemplater (0 Posts), Suba (0 Posts)

Moderators: Suba @ Wealth Informatics (1876 Posts), sooverthis (1041 Posts), PK @ DQYDJ (361 Posts), jmichelsen (208 Posts), Ramona (13 Posts), JeremyNJohnson (4 Posts), Moderator (0 Posts), rackgeek (0 Posts)