Wordpress Hack #8: How to Optimize and Backup Your Wordpress Database WordPress的哈克＃ 8 ：如何优化和备份您的WordPress的数据库
(3 pages) 2,161 views - （ 3页） 2161意见者：管Posted in: 张贴于：
2,161 views 2161意见
Please note: This page was originally written in English.请注意：此网页最初是用英文写的。
The original post can be viewed原来的文章可被视为 here这里 . 。
Please note: This page was originally written in English.
The text has been translated using an online service such as Google or Babelfish.
The original post can be viewed here.
Do you know how to optimize and backup your Wordpress database? 你知道如何优化和备份您的WordPress的数据库？ Most people don’t - until it’s too late! 大多数人并不-直到为时已晚！ I’ll show you how to protect yourself and keep your blog running smooth! 我会告诉你如何保护自己和您的博客保持平稳运行！
This is the next installment of这是下一个分期付款的 30 Wordpress Hacks in 30 Days 30 WordPress的技巧30天内 , and though we may be just a day or two behind in the deployment - we are definitely not short on content! ，虽然我们可能只是一，两天后在部署-我们绝对不是短期的内容！ Be sure to view all 30 days to make the most of your Wordpress blog!一定要查看所有30天，使大部分的WordPress的博客！
Today I’m going to write about one of the most important and most overlooked things you need to know as a Wordpress site owner - your database.今天，我要去写的一个最重要和最忽视的事情，您需要了解作为一个WordPress的网站所有者-您的数据库。 I would say the greater percentage of bloggers, even if they are bit geeky or techie, aren’t “database savvy”.我要说的更大比例的博客，即使它们有点怪异或技术人员，不是“数据库精明” 。 It’s no different than driving a car but not knowing much about the mechanics or maintenance of it.这没有什么不同开车，但不知道这么多力学或维修的。 You don’t know what nobody ever told you - so consider today your lesson in “how to maintain and backup your wordpress database”.你不知道没有人告诉你-所以今天审议的教训， “如何维护和备份您的W ordPress的数据库” 。 Maintenance in necessary to ensure the backend of your site runs smooth, backup is necessary in case you have a disaster, move hosts, get corrupted files, or (god forbid) you screw it up hacking it yourself!在必要的维修，以确保后端您的网站运行顺利，备份是必要的，如果你有一个灾难，移动主机，让损坏的文件，或（上帝保佑） ，您螺钉它黑客它自己吧！
It’s not hard, in fact it’s about as painless as changing your oil in your car.这并不难，实际上它是作为无痛改变你的油你的车。 What I’m going to show you is how to do “preventative maintenance” for your Wordpress DB (database).什么我要告诉你是如何做“预防性维护”为您的WordPress的数据库（数据库） 。 People who are hackers, or programmers, or uber-geeks either login to the command line in telnet (very geeky!) to maintain their telnet database.人们谁是黑客，或程序员，或超级爱好者或者登录到命令行远程登录（非常怪异！ ）保持其远程登录数据库。 More popular is to login to your web host control panel for your site and use myPHPAdmin to graphically administer and maintain your Wordpress mySQL database.更受欢迎的是登录到您的网页主机控制面板，为您的网站和使用，以生动myPHPAdmin管理和维护你的WordPress的MySQL数据库。
There are two Wordpress plugins that I use that help me with Wordpress maintenance.有两个WordPress的插件，我使用，帮助我WordPress的维修。 The first is the首先是 Diagnosis plugin诊断插件 . 。 This plugin doesn’t “do” anything except give you information about your site and the web host you are on.这插件不“做”什么，除非让您了解您的网站和网页主机您是。 The first reason this plugin is invaluable is because it gives you a reference for information you might not ordinarily know.第一个原因此插件是非常宝贵的，就是因为它给你的参考信息您可能通常不知道。 Do you know what version of PHP you have?你知道什么版本的PHP吗？ Do you know your mySQL encoding type?你知道你的MySQL编码类型？ Do you know your mySQL IP address and port number?你知道你的MySQL IP地址和端口号码是多少？ These are all things you might need to know for installing script or troubleshooting your site in the future.所有这些东西你可能需要知道安装脚本或疑难排解您的网站的未来。 The main reason I have Diagnosis installed is because it gives me 3 pieces of information about my database load that I check out either once a week, or if my Wordpress blog starts acting funny (with errors or database connection).最主要的原因我已经安装的诊断是因为它给了我3个有关我的数据库负载，我退房或者每周一次，或如果我的WordPress的博客开始代理有趣的（有错误或数据库连接） 。
In my WP dashboard I go to “Dashboard -> Diagnosis” and look at the mySQL load section to briefly check out the load.在我国可湿性粉剂的仪表板我去“控制台-> ”诊断“ ，并期待在M ySQL的负载部分简要地检查了负荷。 The more traffic you have, and the more database intense your pages are, the higher the load will be.在更多的流量你，和更激烈的数据库，您的网页，较高的负荷将。 The amount of beating a mySQL database server can take is much different on a “shared host” vs. a VPS (virtual private server) or dedicated box.数额殴打MySQL数据库服务器可以采取很多不同的关于“共同主办”同期定位系统（虚拟专用服务器）或专用盒。 Shoemoney recently wrote about the fact that his Wordpress blog recently had to go to it’s own decidated server box, but it probably gets 1,000 times the traffic I do daily. Shoemoney最近写的事实，他WordPress的博客最近到它自己的decidated服务器中，但它可能获得1000倍的流量我每天。 The most important figure here to me is the “connection success rate”.最重要的数字，我这里是“连接的成功率。 ” If it’s not 99.9% - you have a problem.如果没有99.9 ％ -你有问题。 Either you have more traffic than your server can handle, too many connections, or something corrupted with the database.要么你拥有更多的流量比您的服务器能够处理，太多的联系，或者损坏的数据库。
I think the most common problem that happens is your Wordpress site loses connection with the DB and you get some kind of Wordpress error from your site (in a browser) that says “error connecting to database).我认为，最常见的问题，这种情况是你的WordPress的网站失去联系的数据库，你会得到某种形式的WordPress的错误从您的网站（在浏览器中） ，显示“错误连接到数据库） 。 One thing you may not realize is that when you get “shared web hosting” for $3.99 - $24.99 per month the “shared” part of the hosting is the web server and the database server.有一件事您可能没有意识到，当你“共享网络托管”为3.99美元-2 4.99美元，每月的“共享”的一部分，主办是W eb服务器和数据库服务器。 In other word, www.yoursite.com is physically on a server sharing that computers resources with hundreds of other web sites.在其他字，身体www.yoursite.com服务器上的共享计算机资源，数以百计的其他网站。 Your mySQL database is more than likely on a different server, and all it does is host databases.你的MySQL数据库更可能在不同的服务器，以及所有它是主机数据库。 Even if your web server resources are underutilized, your database server might be maxed out by a very busy (or inefficient) site.即使您的网络服务器资源不足，您的数据库服务器可能是由当初的一个非常繁忙（或低效）的网站。 If you get database errors or have connection problems the first thing I would do would be to see what your connection success rate is, and if it’s bad call your host and ask about the “health” of the mySQL server you’re using.如果你数据库错误或连接问题的第一件事我想这样做将看到您的连接成功率，如果它的不良要求你的主机，并询问“健康” MySQL服务器的使用。 You might find (like I have on some occasions) that another customer (on that DB server) is killing your site.您可能会发现（如我曾在一些场合） ，另一个客户（在该数据库服务器）是造成您的网站。
This post has multiple pages...这个职位有多个页...
- Maintaining Your Wordpress Database 维护您的WordPress的数据库
- Page 2 - How to Maintain a Wordpress Database第2页-如何保持W ordPress的数据库
- Page 3 - How to Backup a Wordpress Database第3页-如何备份W ordPress的数据库
- View All查看全部
Tags:标签： backup备份 , ， database数据库 , ， help帮助 , ， optimize优化 , ， plugin插件 , ， tutorial教程 , ， wordpress-hacks WordPress的，黑客
April 25th, 2008 at 10:16 am 08年四月25日在上午10时16
Very useful post JT.非常有用的后特鲁利。
Q
Is DB-manager compatible with 2.5?是的DB -经理兼容2.5 ？ Shows only 2.3 on the site, are you using it now with your 2.5?显示，只有2.3网站上，你是用它与您现在的2.5 ？
The diagnosis part is great!诊断部分是太棒了！ Noobs like me to WorPress don’t think about stuff like that. Noobs要我WorPress没有想到的东西一样。 Very important!很重要的！ And a good plugin.和一个很好的插件。
Do you really see an advantage over backing up the database vs just exporting the information out of WordPress?你真的看到了优势，备份的数据库与公正的信息出口的WordPress的？
I just zip my site every so often and export from WordPress.我只是压缩我的网站都经常和出口从WordPress的。 I also keep a DB backup because I’m paranoid我还保持数据库的备份，因为我偏执![= ） ]](http://www.jtpratt.com/wp-includes/images/smilies/4.gif)
but it does seem a little redundant.但它似乎有点多余。 So far I’ve only used the export/import of wordpress to set things back up.迄今为止我只用来出口/进口的WordPress的设置备份的东西。 When I’ve toasted the DB.当我已经烤数据库。 . 。 . 。 yes I have done it already.是我已经做了。 . 。 . 。 gotta learn some way.总得学习一些方法。 Anyway, I’ve just imported again and I’m right back to where I was.不管怎样，我刚才再次进口，我右后卫，以我在那里。
Just an idea for us noobs只是一个想法，我们noobs
Thanks for the DB education!谢谢您的数据库教育！
C ç
Acupunctures last blog post.. Acupunctures最后的博客帖子.. The Science of Getting Rich by Wallace Wattles科学致富的华莱士沃特尔斯
April 28th, 2008 at 12:03 pm 2008年四月28号在下午12时03
I really enjoy this wordpress hacks series.我很喜欢这个WordPress的黑客系列。 I’m no programmer and even I can understand and use this.我不是程序员，甚至我能理解和使用这一点。
On a related note (kind of在一个相关的说明（种![= [ ]](http://www.jtpratt.com/wp-includes/images/smilies/11.gif)
I Made My First BANS Sale!!!我在我的第一个禁止销售！
Just wanted everyone to know I made my first BANS sale today!只是希望每个人都知道我在我的第一个禁止出售今天！
I did the following to make it happen.我没有下面做到这一点。
1. 1 。 Used Rochelle’s “The Niche Store Checklist has been Revised” to create the BANS site.使用拉罗谢尔的“生态商店清单已修订后的”创造禁止的网站。 http://www.nichestorestrategies.com
2. 2 。 Used Marks’s “More Free Build a Niche Store templates - Come and Get Em!” to build the site.使用商标的“更自由建设生态店铺模板-来获取阿姆！ ” ，以建立网站。 http://www.thenichestorebuilder.com
3. 3 。 Used JTPratt’s “Watch Me Build a BANS Niche Site from Scratch!” to fine tune the site.使用JTPratt的“看我建立一个网站禁令利基从头开始！ ”微调网站。 http://www.jtpratt.com
4 Used JTPratt’s “Best Practices for Setting Up a New Wordpress blog in 60 Minutes or less” to set up a blog correctly.第4用JTPratt的“最佳做法设立一个新的WordPress的博客在60分钟或更少”建立一个博客正确的。 http://www.jtpratt.com
Thanks to all the forum posts at BANS and all the people who commented on the sites listed above.感谢所有论坛职位禁令和所有的人谁评论的网站上面列出。
Come take a look来看看 http://www.toolboxhero.com and make relevant comments at并提出相关的意见 http://www.toolboxhero.com/blog . 。 The blog is dofollow so go ahead and build some backlinks.该博客是dofollow所以要大胆向前，并建立一些反向。
Next, more backlinks, more BANS stores, and implement more ideas from Rochelle.其次，更多的反向，更禁止商店和实施更多的想法拉罗谢尔。 Mark, and JTPratt!!马克，并JTPratt ！
Thanks again, Paul再次感谢，保罗
Pauls last blog post..保罗最后的博客帖子.. Sears Normal Tool Warranty西尔斯正常保修工具
June 5th, 2008 at 9:04 am 2008年6月5日在上午09时04分
[...] a nice article by JTPratt, his next step was installing WP-DBManager which will provide a new screen in your dashboard with [...] [...]很好的文章JTPratt ，他的下一步是安装涡喷DBManager这将提供一个新的屏幕在您的仪表板与[...]
August 25th, 2008 at 3:31 am 2008年八月25日在上午03时31分
I have to agree that backing up your database is a pain, but very important.我不得不同意，备份你的数据库是一个痛苦，但非常重要的。 I read a post on a forum, that I frequent, today.我读了后的一个论坛，我频繁的今天。 From someone who got their blog hacked.从别人谁得到他们的博客砍死。 It’s just much easier to recover from that if things are backed up.这只是更容易恢复过来，如果事情后盾。
Sid Softwares last blog post..希德软件上的博客帖子.. Best Windows backup software最佳Windows备份软件
August 27th, 2008 at 12:02 am 2008年8月27日在上午12点零二
[...] don’t feel bad. It didn’t mean anything to me either when I came across it over at JT Pratt’s Blogging Mistakes (currently my favorite blog about blogging). You can follow the link to his excellent explanatory [...] [...]不觉得bad.Â它并不意味着什么，我都当我碰到它在日本烟草公司普拉特的博客误区（目前我最喜爱的博客有关Blog ） 。 A您可以按照链接他出色的解释性[...]
September 10th, 2008 at 4:29 pm 2008年9月十日在下午4点29
first off i want to thank you for the marvelous article…it is very clear and even i could “get it”….however, i have done everything you suggested and i am still loading slow….首先，我要感谢你的精彩文章...这是非常明确的，甚至我可以“得到” ... 。不过，我已经尽你建议我仍然加载缓慢... 。
i have also taken all the text off of you widgets, deleted all on active plug ins…我还采取了所有的文字从你构件，删除了所有关于积极插件...
i have done everything i have read about other than the cashe and i am so unfamiliar with that it sort of scares me…我已经尽我已阅读有关以外的其他cashe和我很熟悉，它那种害怕我...
could you please please help me….i have bugged my hosting company many times….and they said there is nothing else they can do….你可以请帮我... 。我有窃听我的托管公司多次... 。他们说，他们没有别的可以做... 。
so any imput would be very appreciated.因此，任何输入将是非常赞赏。
thanks谢谢
darlene
September 10th, 2008 at 10:03 pm 08年九月10日在下午10时03
@Darlene - @ Darlene -
Looks like you have multiple issues.看起来像您有多个问题。 I have had this exact same problem and fixed it.我有这个相同的问题和固定它。 I think you have a plugin conflict and also you have massive code issues.我想你有一个插件冲突，还您有大量的代码问题。
This is what I would do…这就是我将尽...
1. 1 。 Disable all plugins禁用所有插件
2. 2 。 Set the theme to default设置默认主题
3. 3 。 Take your July 15th post and edit it.你7月15日员额和编辑。 Copy the text into Windows notepad.复制文本到Windows记事本。 Use Ctrl-A to “select all” and copy, then go back to the post in your Wordpress dashboard.使用Ctrl - A至“选择所有”和复制，然后再返回后在您的WordPress的仪表板。 Delete everything.删除一切。 Paste the text you copied from notepad.贴上您复制文本从记事本。 The problem is you’ve been writing your entries in Microsoft Word, copying the text and pasting it into your posts using the Wordpress visual editor.问题是您一直在写你的作品在Microsoft Word中，复制的文本并粘贴到您的文章使用WordPress的可视化编辑器。 You have to stop doing that - it’s bloating the bejeezus out of your code.你必须停止这样做-这是腹胀的b ejeezus了您的代码。
4. 4 。 Save the post, reload your home page保存后，重新载入您的主页
At this point everything should be better.在这一点上都应该做得更好。 If it’s not, download all your plugins to your desktop in folder, then in FTP on your web server delete all the plugins in /wp-content/plugins.如果不是的话，下载所有的插件到桌面的文件夹，然后在您的FTP网络服务器删除所有的插件在/ wp-content/plugins 。 Wordpress still looks in your plugin directory - even if they aren’t enabled. WordPress的仍然期待您的插件目录-即使他们是没有启用。
So now, what happens?所以，现在会发生什么？ Your blog should be light years faster.您的博客应该光年的速度更快。 If it’s STILL not you may have a web host problem.如果它还是您可能有一个网页主机的问题。 There may be too many people on your web server or the MySQL (database server) might be overused.可能有太多的人对您的Web服务器或在MySQL （数据库服务器）可能是过度。 I mean, if you have the default them with no plugins your blog still takes 30 seconds to load, unless you have serious database corruption your web host is to blame.我的意思是，如果您有默认他们没有插件您的博客仍然需要30秒钟加载，除非你有严重的腐败数据库您的网页主机的错。 You already optimized your database - so it should be ok.您已经优化你的数据库-因此它应该确定。
At this point, I would dump your web host for someone like在这一点上，我将转储您的网页主机的像 Hostgator . 。 I use them for about everything, they work great, and you can have unlimited sites and databases for $15/mo or less.我使用他们的一切，他们的工作很好，你可以拥有无限的网站和数据库，为15/mo或更少。 The servers are fast, tech support is great, and I’ve never had any issues with anything - EVER.该服务器的速度快，技术支持是巨大的，我从来没有任何问题，任何-恒。
Post again on your success (or failure) once you’ve tried these steps…邮政再次你的成功（或失败）一旦你试过这些步骤...
September 10th, 2008 at 11:23 pm 2008年9月十日在下午11点23分
hi there…高科技有...
thanks for your comments…i have done the plugin thingy…i am afraid to do the default as i didn’t build that part of my website….and don’t know if i could get it back without a lot of tears….and i have really spent them all on this issue….谢谢您的意见...我也做了插件thingy ...我怕这样的默认，我没有建立这一部分我的网站... 。和不知道我是否能回来没有很多的眼泪... 。我真的度过他们都在这个问题上... 。
i do want you to tell me more in detail about my posting behavior….and you are right in what i am doing….and i know for you you probably felt it was in detail…but i need it sort of step by step….how do i write my articles….in notebook and then copy them into wordpress???我想你告诉我更详细了解我张贴的行为... 。和你是什么权利，我这样做... 。而且我知道你，你可能认为这是详细...但我需要的那种一步一步... 。如何我写我的文章... 。在笔记本，然后将其复制到WordPress的？ ？ ？ how do i get the various styles i like in my writing….do i have to give that up???…我如何获得各种风格我喜欢在我的写作... 。我一定要给予了？ ？ ？ ...
also i finally got a senior service rep and he went to the top and found out that one of data servers (the second one or something) was/is the problem and my issue is suppose to resolved by morning…i made 6 calls to them and asked about the server thingy each time and each time they just repeated that the server load was checked and it was ok….evidiently there are two servers and they didin’t take it that far….我也终于获得了高级服务代表和他到顶端，发现一个数据服务器（第二一人或东西）是/是这个问题，我的问题是假设，以解决...今天上午，我6呼吁他们并询问该服务器thingy每次每次他们只是重申，服务器负载的检查，并确定这是... 。 evidiently有两个服务器和他们didin't是否可以认为到目前为止... 。
so will lst you know what happens in the morning…and i really, really appreciate your answer and thoroughness in helping me…you are great!!!!!所以将首届你知道发生在今天上午...我真的，真的非常感谢您的回答和彻底性，帮助我...您是伟大的!!!!!
namaste, namaste ，
darlene
September 11th, 2008 at 7:50 am 08年9月11号在上午七点50分
Darlene, Darlene ，
I checked your site also.我检查您的网站还。 I don’t think it has anything to do with the plugins or themes.我不认为这有什么关系的插件或主题。
If you watch your browser working you will see that it is waiting to connect to the domain and once it does it loads the page rather fast.如果您看您的浏览器的工作你会看到，它正在等待连接到域，一旦它加载网页较快。 Therefore, the problem.因此，这一问题。 . 。 . 。 in my opinion is your host.在我看来，是您的主机。
Hostgator is a good host I also like Hawk Host - very good and low cost. Hostgator是一个很好的东道国我也喜欢鹰主机-非常好，成本低等优点。
One of my sites responds like yours at times.我的一个网站像您这样的回应时。 . 。 . 。 thus it isn’t my plugins or theme.因此，这不是我的插件或主题。 It’s whatever is going on with your host at that time.这一切正在与你的主机在这个时间。
Good luck祝您好运
September 11th, 2008 at 8:46 am 08年九月十一日在上午08点46分
@Darlene: What you need to do is never write posts in anything other than Wordpress from now on. @ Darlene ：你需要做的是从来没有写职位以外的任何WordPress的从现在开始。 Make sure you are using the “visual” editor (the one with bold, italic, font size, bullets, etc).请确保您使用的是“视觉”编辑器（在一个粗体，斜体，字体大小，子弹等） 。 If you aren’t - edit your profile under “Users” and enable it.如果您不是-编辑您的个人资料下的“用户” ，并启用它。
If there are things in Word you want to do that Wordpress visual editor won’t - you should be doing those in web pages anyway.如果有东西在Word中要做到这一点WordPress的可视化编辑器将不会-你应该做的是在网页上反正。 Microsoft Word adds in 50X more code (most of it useless) for every page you write - making the load times slower.微软Word 50X增添更多的代码（其中大部分是无用的）的每一页你写-使加载时间慢。 Not a ton slower, but slower.一吨不慢，但慢。
To fix the existing posts you just open up Windows Notepad by going to start->Accessories ->Notepad.要修复现有员额您刚刚打开Windows记事本的要启动“配件-> ”记事本。 Just copy your posts there.只需复制您的帖子出现。 Select all, and then copy again, and paste back to your post and save.选择所有，然后再复制，并贴到您的文章和保存。