MovableTypeで作ってる某ブログのサーバーを移動しようとさっきまでがんばってたんだけど・・・
ドメイン変わらずだしそれほど苦労せずできるかな?と思ってたけど大誤算。
まずmysqlからダンプしたらデータがなんと700MB!?
確かにデータの投稿量はんぱないからなぁ・・・
移行先はロリポップだからPHPの設定ってほとんどいじれなくて
phpMyAdminだとアップロードファイルのサイズ制限にひっかかって無理。
16MBまではいけるから16MBずつ分割して40回ぐらいにわけて実行するのは不可能じゃないけど現実的じゃないし PHPから取り込めないかな?って
ググってみたところでかい容量のダンプファイルをインポートするツールを発見
http://www.ozerov.de/bigdump.php
こちらを使って無事解決、、、、とは残念ながらいかず 200MBぐらい読み込んだところでタイムアウトしてる(涙)
けどそれなら4分割で・・・と一瞬考えたけど よくよく見るとmt_logってファイルで止まってる。
元サーバーのデータ見るとmt_logが600MBとか容量のほとんど占めてるしw
確認したところmt_logは単なるログデータだから消しても問題ないので 削除!
ということでダンプファイルのサイズが100MB程度に収まったのでこのbigdumpを使って無事移行できました。
まとめると・・・
・mt_logは削除
・ダンプファイルをFTPでアップしbigdumpを使って読み込む
Another time I practice a weblog, Hopefully it doesnt disappoint me as much as that one. I imply, I understand it had become my option to read, however I really thought youd have something interesting to mention. All I hear is a handful of whining about something that you might possibly fix should you werent too busy on the lookout for attention.
Awesome Post. You do a sufficient job. Thanks again
excellent post, very informative. I ponder why another experts of the sector do not notice this. You will need to continue your writing. Im confident, you do have a great readers base already!
This is certainly an incredibly amazing powerful resource that you’re offering and you simply provide it away cost-free!! I that can match discovering websites of which view the particular property value giving you a wonderful learning resource for zero cost. We truly dearly loved examining this web site. Regards!
I just now wanted to make a quick comment in order to express gratitude to you for people wonderful pointers that you are posting at this site. My time consuming internet investigation has in the end throughout the day been rewarded with high quality means to present to my guests. I will say that most of us prospects can be extremely endowed to take place in an outstanding network with lots of marvellous people who have useful hints. I believe quite privileged to get used your webpages and appearance forward to really more fabulous minutes reading here. Many thanks for many things.
I feel that may be an enchanting point, it made me assume a bit. Thanks for sparking my considering cap. From time to time I am getting such a lot in a rut that I simply really feel like a record.
Thanks for making the honest effort to discuss this. I think very strong about it and wish to learn more. If it's OK, as you gain extra in depth knowledge, may you mind adding more articles similar to this one with more information? It will be extremely useful and helpful for me and my friends.
It is making no sense :(
What a lovely day for a 4674311! SCK was here
“This site appears to get a great deal of visitors”
hello there and thank you for your information – I have certainly picked up anything new from right here. I did however expertise several technical points using this site, as I experienced to reload the site a lot of times previous to I could get it to load properly. I had been wondering if your web hosting is OK? Not that I am complaining, but slow loading instances times will very frequently affect your placement in google and could damage your quality score if ads and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and could look out for much more of your respective intriguing content. Make sure you update this again soon..
Very useful post! I really enjoyed reading it. So good to read a blog that's written in decent English! I will certainly be back for more in the future. Thanks a lot.
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It's always nice when you can not only be informed, but also entertained! I'm sure you had fun writing this article.
I do not understand exactly how i discovered this blog because I was searching information about about the situation in Afghanistan, but anyway I am really grateful I stumbled upon your post since I had a great 10 mins reading it. Keep up the good work! One final thing, is it possible to advocate various other important articles or blog posts about the very same problem?
you could have an important blog right here! would you wish to make some invite posts on my blog?
Needed to send you a very small remark to be able to say thank you over again just for the amazing things you have shared at this time. It is really particularly open-handed with you to offer unhampered all a few people would've offered for an electronic book to help make some bucks on their own, chiefly now that you might have tried it if you ever considered necessary. Those thoughts as well worked as a good way to understand that some people have similar zeal much like my very own to see significantly more in respect of this problem. I'm certain there are some more enjoyable opportunities up front for individuals who find out your blog.
Very interesting post. Your perspective is incredibly lucid and interesting. I will absolutely be following your RSS. I really hope you will post often on similar things. However I was curious as to what your resources for the write-up are? Cheers.
Fantastic write-up, very informative. I wonder why the other gurus of this sector do not notice this. You must keep on your posting. I’m confident, you have a huge readers’ base now!
very nice post, i certainly love this website, keep on it
Very good post. Will you please write much more about this subject.
You certainly know what you are talking about. Man, your blog is just terrific! I cannot wait to read more of what you have to say. I'm truly satisfied that I came upon this when I did because I was really getting down to lose interest with the whole blogging and site-building scene. Youve turned me around man!
This is really interesting, You are a very skilled blogger. I've joined your rss feed and look forward to seeking more of your magnificent post. Also, I have shared your site in my social networks!
There are some attention-grabbing points in time on this article however I don’t know if I see all of them heart to heart. There is some validity however I will take hold opinion till I look into it further. Good article , thanks and we wish more! Added to FeedBurner as well
I like the useful data you supply within your articles. I’ll bookmark your weblog and check once more here regularly. I’m quite certain I will learn lots of new stuff appropriate here! Very best of luck for the next!
Thank you so much because you post this information. I am really glad that your sharing it with me and other people visiting your website.
Quality is everything, so we need to ensure that there are values on what we are sharing to keep our subscribers interested.
whoah this blog is great i really like reading your posts. Keep up the good work! You realize, many individuals are hunting round for this info, you could aid them greatly.
A great blog post makes you think and you've certainly given me a few tid bits to consider.
The next time I learn a blog, I hope that it doesnt disappoint me as a lot as this one. I imply, I do know it was my option to read, however I actually thought youd have something fascinating to say. All I hear is a bunch of whining about one thing that you possibly can fix in case you werent too busy in search of attention.
Certainly very interesting post. In all cases I will try what is written here to pursue. greeting
The next time I read a blog, I hope that it doesnt disappoint me as a lot as this one. I imply, I know it was my option to read, however I really thought youd have something fascinating to say. All I hear is a bunch of whining about one thing that you could possibly fix in case you werent too busy on the lookout for attention.
Hi there, I found your site by way of Google while looking for a similar topic, your website came up, it seems to be good. I have bookmarked it in my google bookmarks.
I used to be suggested this website by my cousin. I am no longer certain whether this publish is written via him as nobody else recognize such distinctive approximately my problem. You are wonderful! Thank you!
A very very interesting article! I'll try to track that continues here! Thank you.
I’m not that much of a internet reader to be honest but your blogs really nice, keep it up! I'll go ahead and bookmark your website to come back later. All the best
“Do you people have a facebook fan page? I looked for one on twitter but could not discover one”
Simply desire to say your article is as astonishing. The clearness to your publish is just spectacular and i could suppose you're a professional on this subject. Fine with your permission let me to grab your RSS feed to stay up to date with forthcoming post. Thank you one million and please continue the rewarding work.
hey all, I was just checking out this weblog and I actually admire the premise of the article, and don't have anything to do, so if anybody want to to have an engrossing convo about it, please contact me on AIM, my identify is heather smith
Hey intelligent points.. now why did not i consider those? Off subject slightly, is this web page pattern merely from an atypical set up or else do you employ a customized template. I take advantage of a webpage i'm in search of to improve and well the visuals is likely one of many key things to complete on my list.
Thank you a lot for sharing this with all of us you actually realize what you are talking approximately! Bookmarked. Kindly additionally talk over with my site =). We can have a hyperlink alternate agreement between us!
Hi there! Would you mind if I share your blog with my zynga group? There's a lot of folks that I think would really appreciate your content. Please let me know. Thanks
Many thanks for posting this, It's just what I was researching for on bing. I'd quite a bit comparatively hear opinions from a person, barely than an organization internet page, that's why I like blogs so significantly. Many thanks!
hey all, I used to be just checking out this blog and I actually admire the idea of the article, and have nothing to do, so if anyone would like to to have an engrossing convo about it, please contact me on AIM, my title is heather smith
you will have an excellent blog right here! would you like to make some invite posts on my weblog?
I’d should verify with you here. Which isn't one thing I often do! I enjoy reading a put up that will make folks think. Also, thanks for allowing me to remark!
Hi there, beautiful weblog with great informational content. This is a really interesting and informative content.
Yes, it shows what we need to know.
Thanks on your marvelous posting! I truly enjoyed reading it, you're a great author.I will remember to bookmark your blog and will eventually come back later on. I want to encourage you continue your great work, have a nice evening!
I enjoy you because of your own labor on this web page. Gloria really likes setting aside time for internet research and it's easy to see why. I notice all about the dynamic tactic you give reliable tips and tricks by means of the blog and encourage response from some others on that subject so our favorite daughter is now becoming educated a lot. Take advantage of the remaining portion of the new year. You are conducting a great job.
I just like the valuable info you supply on your articles. I will bookmark your blog and check once more here regularly. I am relatively certain I'll be informed lots of new stuff proper here! Good luck for the next!
Today, while I was at work, my cousin stole my iphone and tested to see if it can survive a twenty five foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!
You got a very superb website, Gladiolus I noticed it through yahoo.
Your blog post isExtra Ordinary. I completely accepted your words. On some other day I will again visit your Website. check my buying first home site here
thanks a lot mate..
looking around for the best site to get one.
Of course, what a great site and informative posts, I will add backlink - bookmark this site? Regards,Reader.
Hi there, I found your blog via Google while searching for first aid for a heart attack and your post looks very interesting for me.
Apple now has Rhapsody as an app, which is a great start, but it is currently hampered by the inability to store locally on your iPod, and has a dismal 64kbps bit rate. If this changes, then it will somewhat negate this advantage for the Zune, but the 10 songs per month will still be a big plus in Zune Pass' favor.
I not to mention my guys were reviewing the excellent techniques on your website and all of the sudden developed a horrible suspicion I never thanked the blog owner for those strategies. Those young men came as a result passionate to learn them and have now seriously been enjoying these things. Thanks for simply being quite thoughtful and also for figuring out this form of awesome subjects millions of individuals are really wanting to know about. Our own sincere regret for not expressing appreciation to earlier.
Certainly one of the challenges which people beginning a new on-line firm face is that of acquiring visitors to their internet site.
I know this isn't exactly on topic, however i have a site using the identical program as properly and i get troubles with my comments displaying. is there a setting i'm lacking? it's attainable you could help me out? thanx.
Hello there! I'm so grateful I found your internet site. I actually discovered you by error, whilst I was exploring on Stumbleupon for something diffrent. Anyway, I am here now and would just like to give you thanks for the amazing article and a all-round appealing weblog (I also love the theme / design). I don't have enough time to browse all of it at the moment however I have bookmarked it as well as put in your RSS feeds, so if I have time I will be returning to read more. Please do carry on the great job.
Useful information, many thanks to the author. It is puzzling to me now, but in general, the usefulness and importance is overwhelming. Very much thanks again and good luck!
I really appreciate the writer’s skills over here as he has presented the facts in the right manner. Also he has kept the content simple, engaging and concise.
thanks nice stuff...Keep bloging
This internet site is often a walk-through rather than the details you wanted about it and didn’t know who ought to. Glimpse here, and you’ll undoubtedly discover it.
A great blog post makes you think and you've certainly given me a few tid bits to consider.
yes definitely
Nice! Just wanted to respond. I thoroughly loved your post. Keep up the great work.
This is getting a bit more subjective, but I much prefer the Zune Marketplace. The interface is colorful, has more flair, and some cool features like 'Mixview' that let you quickly see related albums, songs, or other users related to what you're listening to. Clicking on one of those will center on that item, and another set of "neighbors" will come into view, allowing you to navigate around exploring by similar artists, songs, or users. Speaking of users, the Zune "Social" is also great fun, letting you find others with shared tastes and becoming friends with them. You then can listen to a playlist created based on an amalgamation of what all your friends are listening to, which is also enjoyable. Those concerned with privacy will be relieved to know you can prevent the public from seeing your personal listening habits if you so choose.
I read them!!I want them!!I buy them!!!
That is the right blog for anyone who wants to seek out out about this topic. You understand so much its virtually laborious to argue with you (not that I truly would need…HaHa). You definitely put a new spin on a subject thats been written about for years. Nice stuff, just nice!
Really superb information can be found on web blog .
You must take part in a contest for among the best blogs on the web. I will recommend this site!
Today, while I was at work, my cousin stole my iphone and tested to see if it can survive a twenty five foot drop, just so she can be a youtube sensation. My iPad is now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!
The very crux of your writing while sounding agreeable initially, did not really settle properly with me after some time. Someplace within the sentences you actually were able to make me a believer unfortunately only for a short while. I nevertheless have a problem with your leaps in logic and you might do nicely to help fill in all those gaps. If you actually can accomplish that, I will undoubtedly end up being amazed.
I really appreciate this post. I’ve been looking everywhere for this! Thank goodness I found it on Bing. You have made my day! Thanks again!
I loved as much as you'll obtain performed right here. The comic strip is tasteful, your authored material stylish. nevertheless, you command get bought an edginess over that you wish be turning in the following. sick indubitably come further formerly once more as exactly the same just about very frequently inside case you shield this increase.
thanks nice stuff...Keep bloging
Finally a smart blogger...I love how you're thinking and writing!
Think highly of yourself, for the world takes you at your own estimate.
airsoft mask… […]while the sites we link to below are completely unrelated to ours, we think they are worth a read, so have a look[…]…
Highly rated post. I learn one thing totally new on completely different blogs everyday. Deciding on one . stimulating to read the paper content material from different writers and be taught somewhat something from their website. I'd like to apply certain of this content on my weblog you're mind. Natually I'll give a link right here we're at your web-site. Respect your sharing.
Many thanks for posting this, It's just what I was researching for on bing. I'd quite a bit relatively hear opinions from a person, slightly than an organization internet page, that's why I like blogs so significantly. Many thanks!
Excellent blog! Plenty of helpful information here. I was looking for this.Thanks for sharing! villa grece
Can you share the design of your blog? I would truly like to have it
What i do not understood is definitely how you’re not truly a lot more well-liked than you might be right now. You are very educated. You realize therefore significantly relating to this subject, produced myself consider it from so many varied angles. It’s like men and women are certainly not fascinated unless it is one thing to do with Lady gaga! Your individual stuffs superb.
I discovered your blog website on google and examine a few of your early posts. Continue to maintain up the very good operate. I simply further up your RSS feed to my MSN News Reader. Looking for ahead to reading extra from you in a while!?I am often to blogging and i really admire your content. The article has really peaks my interest. I am going to bookmark your site and preserve checking for brand spanking new information.
sign me in :D
Ein Preis Vergleich kann sich durchaus lohnen.
Fantastic write-up, very informative. I wonder why the other gurus of this sector do not notice this. You must keep on your posting. I’m confident, you have a huge readers’ base now!
This post is indeed quite interesting. Keep it up! I'll try here to further the contributions Vervolg.
Howdy! I just want to give an enormous thumbs up for the fantastic data you might have here on this post. I will likely be coming back to your weblog for more soon.
This really answered my problem, thank you!
Many thanks for another excellent write-up. Where else may anyone have that sort of information and facts in composed in such a clear approach. I've a demonstration next week, and I had been searching for precisely the info you have just provided me. Bless you.