質問編集履歴

1

情報の追加

2018/03/30 08:37

投稿

ogra
ogra

スコア18

test CHANGED
File without changes
test CHANGED
@@ -1,3 +1,5 @@
1
+ (情報が不足しているとのご指摘を受け、情報を追加しました。)
2
+
1
3
  お世話になっております。
2
4
 
3
5
  さくらインターネットのレンタルサーバにインストールしてあるWordPressを、さくらのVPSに移行しようとしています。
@@ -33,3 +35,427 @@
33
35
  このような場合、WordPressの管理画面で画像をアップロードし直す以外に、どのようにしたらリンク切れを解決できるでしょうか。
34
36
 
35
37
  よろしくお願いします。
38
+
39
+
40
+
41
+ ### 移行元サーバ(さくらのレンタルサーバ スタンダード)
42
+
43
+
44
+
45
+ OS: FreeBSD 9.1-RELEASE-p24 amd64
46
+
47
+ Apache: 2.4.29
48
+
49
+ PHP: 5.4.45
50
+
51
+ MySQL: 5.5.59-log (UTF-8)
52
+
53
+
54
+
55
+ `$ php -i`の実行結果(日本語関係を含むと思う部分を抜粋)
56
+
57
+ ```
58
+
59
+ Configuration File (php.ini) Path => /usr/local/php/5.4/etc
60
+
61
+ Loaded Configuration File => /usr/local/php/5.4/etc/php.ini
62
+
63
+ Scan this dir for additional .ini files => /usr/local/php/5.4/etc/conf.d
64
+
65
+ Additional .ini files parsed => (none)
66
+
67
+ PHP API => 20100412
68
+
69
+ PHP Extension => 20100525
70
+
71
+ Zend Extension => 220100525
72
+
73
+ Zend Extension Build => API220100525,NTS
74
+
75
+ PHP Extension Build => API20100525,NTS
76
+
77
+ Debug Build => no
78
+
79
+ Thread Safety => disabled
80
+
81
+ Zend Signal Handling => disabled
82
+
83
+ Zend Memory Manager => enabled
84
+
85
+ Zend Multibyte Support => provided by mbstring
86
+
87
+ IPv6 Support => enabled
88
+
89
+ DTrace Support => disabled
90
+
91
+
92
+
93
+ Registered PHP Streams => https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar, zip
94
+
95
+ Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
96
+
97
+ Registered Stream Filters => zlib.*, convert.iconv.*, mcrypt.*, mdecrypt.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk
98
+
99
+
100
+
101
+
102
+
103
+ Core
104
+
105
+
106
+
107
+ PHP Version => 5.4.45
108
+
109
+
110
+
111
+ default_charset => no value => no value
112
+
113
+
114
+
115
+
116
+
117
+ zend.detect_unicode => On => On
118
+
119
+ zend.enable_gc => On => On
120
+
121
+ zend.multibyte => Off => Off
122
+
123
+ zend.script_encoding => no value => no value
124
+
125
+
126
+
127
+
128
+
129
+ iconv
130
+
131
+
132
+
133
+ iconv support => enabled
134
+
135
+ iconv implementation => libiconv
136
+
137
+ iconv library version => 1.14
138
+
139
+
140
+
141
+
142
+
143
+ mbstring
144
+
145
+
146
+
147
+ Multibyte Support => enabled
148
+
149
+ Multibyte string engine => libmbfl
150
+
151
+ HTTP input encoding translation => disabled
152
+
153
+ libmbfl version => 1.3.2
154
+
155
+
156
+
157
+
158
+
159
+ Multibyte (japanese) regex support => enabled
160
+
161
+ Multibyte regex (oniguruma) backtrack check => On
162
+
163
+ Multibyte regex (oniguruma) version => 4.7.1
164
+
165
+
166
+
167
+ Directive => Local Value => Master Value
168
+
169
+ mbstring.detect_order => no value => no value
170
+
171
+ mbstring.encoding_translation => Off => Off
172
+
173
+ mbstring.func_overload => 0 => 0
174
+
175
+ mbstring.http_input => pass => pass
176
+
177
+ mbstring.http_output => pass => pass
178
+
179
+ mbstring.http_output_conv_mimetypes => ^(text/|application/xhtml+xml) => ^(text/|application/xhtml+xml)
180
+
181
+ mbstring.internal_encoding => no value => no value
182
+
183
+ mbstring.language => neutral => neutral
184
+
185
+ mbstring.strict_detection => Off => Off
186
+
187
+ mbstring.substitute_character => no value => no value
188
+
189
+ ```
190
+
191
+
192
+
193
+ ### 移行先サーバ(さくらのVPS)
194
+
195
+
196
+
197
+ OS: CentOS Linux release 7.4.1708 (x86_64)
198
+
199
+ Apache: 2.4.6
200
+
201
+ PHP: 5.4.16
202
+
203
+ MariaDB: 5.5.56
204
+
205
+
206
+
207
+ `$ php -i`の実行結果(日本語関係を含むと思う部分を抜粋)
208
+
209
+ ```
210
+
211
+ Configuration File (php.ini) Path => /etc
212
+
213
+ Loaded Configuration File => /etc/php.ini
214
+
215
+ Scan this dir for additional .ini files => /etc/php.d
216
+
217
+ Additional .ini files parsed => /etc/php.d/curl.ini,
218
+
219
+ /etc/php.d/dom.ini,
220
+
221
+ /etc/php.d/fileinfo.ini,
222
+
223
+ /etc/php.d/gd.ini,
224
+
225
+ /etc/php.d/json.ini,
226
+
227
+ /etc/php.d/mbstring.ini,
228
+
229
+ /etc/php.d/mcrypt.ini,
230
+
231
+ /etc/php.d/mysql.ini,
232
+
233
+ /etc/php.d/mysqli.ini,
234
+
235
+ /etc/php.d/pdo.ini,
236
+
237
+ /etc/php.d/pdo_mysql.ini,
238
+
239
+ /etc/php.d/pdo_sqlite.ini,
240
+
241
+ /etc/php.d/phar.ini,
242
+
243
+ /etc/php.d/posix.ini,
244
+
245
+ /etc/php.d/sqlite3.ini,
246
+
247
+ /etc/php.d/sysvmsg.ini,
248
+
249
+ /etc/php.d/sysvsem.ini,
250
+
251
+ /etc/php.d/sysvshm.ini,
252
+
253
+ /etc/php.d/wddx.ini,
254
+
255
+ /etc/php.d/xmlreader.ini,
256
+
257
+ /etc/php.d/xmlwriter.ini,
258
+
259
+ /etc/php.d/xsl.ini,
260
+
261
+ /etc/php.d/zip.ini
262
+
263
+
264
+
265
+ PHP API => 20100412
266
+
267
+ PHP Extension => 20100525
268
+
269
+ Zend Extension => 220100525
270
+
271
+ Zend Extension Build => API220100525,NTS
272
+
273
+ PHP Extension Build => API20100525,NTS
274
+
275
+ Debug Build => no
276
+
277
+ Thread Safety => disabled
278
+
279
+ Zend Signal Handling => disabled
280
+
281
+ Zend Memory Manager => enabled
282
+
283
+ Zend Multibyte Support => provided by mbstring
284
+
285
+ IPv6 Support => enabled
286
+
287
+ DTrace Support => disabled
288
+
289
+
290
+
291
+ Registered PHP Streams => https, ftps, compress.zlib, compress.bzip2, php, file, glob, data, http, ftp, phar, zip
292
+
293
+ Registered Stream Socket Transports => tcp, udp, unix, udg, ssl, sslv3, tls
294
+
295
+ Registered Stream Filters => zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, mcrypt.*, mdecrypt.*
296
+
297
+
298
+
299
+
300
+
301
+ Core
302
+
303
+
304
+
305
+ PHP Version => 5.4.16
306
+
307
+
308
+
309
+ default_charset => no value => no value
310
+
311
+
312
+
313
+
314
+
315
+ zend.detect_unicode => On => On
316
+
317
+ zend.enable_gc => On => On
318
+
319
+ zend.multibyte => Off => Off
320
+
321
+ zend.script_encoding => no value => no value
322
+
323
+
324
+
325
+
326
+
327
+ iconv
328
+
329
+
330
+
331
+ iconv support => enabled
332
+
333
+ iconv implementation => glibc
334
+
335
+ iconv library version => 2.17
336
+
337
+
338
+
339
+
340
+
341
+ mbstring
342
+
343
+
344
+
345
+ Multibyte Support => enabled
346
+
347
+ Multibyte string engine => libmbfl
348
+
349
+ HTTP input encoding translation => disabled
350
+
351
+ libmbfl version => 1.3.2
352
+
353
+
354
+
355
+
356
+
357
+ Multibyte (japanese) regex support => enabled
358
+
359
+ Multibyte regex (oniguruma) backtrack check => On
360
+
361
+ Multibyte regex (oniguruma) version => 4.7.1
362
+
363
+
364
+
365
+ Directive => Local Value => Master Value
366
+
367
+ mbstring.detect_order => no value => no value
368
+
369
+ mbstring.encoding_translation => Off => Off
370
+
371
+ mbstring.func_overload => 0 => 0
372
+
373
+ mbstring.http_input => pass => pass
374
+
375
+ mbstring.http_output => pass => pass
376
+
377
+ mbstring.http_output_conv_mimetypes => ^(text/|application/xhtml+xml) => ^(text/|application/xhtml+xml)
378
+
379
+ mbstring.internal_encoding => no value => no value
380
+
381
+ mbstring.language => neutral => neutral
382
+
383
+ mbstring.strict_detection => Off => Off
384
+
385
+ mbstring.substitute_character => no value => no value
386
+
387
+ ```
388
+
389
+
390
+
391
+ `$ mysql -u root -p -e 'status'`の実行結果
392
+
393
+ ```
394
+
395
+ mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1
396
+
397
+
398
+
399
+ Connection id: 1690
400
+
401
+ Current database:
402
+
403
+ Current user: root@localhost
404
+
405
+ SSL: Not in use
406
+
407
+ Current pager: stdout
408
+
409
+ Using outfile: ''
410
+
411
+ Using delimiter: ;
412
+
413
+ Server: MariaDB
414
+
415
+ Server version: 5.5.56-MariaDB MariaDB Server
416
+
417
+ Protocol version: 10
418
+
419
+ Connection: Localhost via UNIX socket
420
+
421
+ Server characterset: utf8
422
+
423
+ Db characterset: utf8
424
+
425
+ Client characterset: utf8
426
+
427
+ Conn. characterset: utf8
428
+
429
+ UNIX socket: /var/lib/mysql/mysql.sock
430
+
431
+ Uptime: 6 hours 24 min 11 sec
432
+
433
+
434
+
435
+ Threads: 1 Questions: 76062 Slow queries: 0 Opens: 95 Flush tables: 2 Open tables: 121 Queries per second avg: 3.299
436
+
437
+ ```
438
+
439
+
440
+
441
+ ### 表示できないURLとファイル名の対応
442
+
443
+
444
+
445
+ (ドメイン名の.jpより前のacmeの部分は実際のものとは異なります。)
446
+
447
+ `http://acme.jp/wordpress/wp-content/uploads/2015/10/名称未設定-1.png`
448
+
449
+ →ファイル名は`å??称æ?ªè¨­å®?-1.png`
450
+
451
+
452
+
453
+ `http://acme.jp/wordpress/wp-content/uploads/2015/07/%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%BC%E3%83%B3%E3%82%B7%E3%83%A7%E3%83%83%E3%83%88-0027-07-26-19.43.37.png`
454
+
455
+ →ファイル名は`ã?¹ã?¯ã?ªã?¼ã?³ã?·ã?§ã??ã??-0027-07-26-19.43.37.png`
456
+
457
+
458
+
459
+ 上記のように、ファイル名が文字化けしているようです。
460
+
461
+ レンタルサーバからVPSへファイルをコピーするにあたり、単純に`tar`コマンドでtar.gzファイルを作り、それをscpでコピーして展開しただけだったのがいけなかったのでしょうか。