Zmiana linków w bazie MySQL Opcje

[andegrand2]

Witam,

Mam taki problem. Przeniosłem sobie skrypt WordPress na inny serwer, wszystko poszło super. Baza się normalnie zaimportowała ale.. nie mam zdjęć w postach bo w bazie są linki do starej domeny. Jak można zmienić "hurtowo" około 500 linków typu domena1.pl/upload... na domena2.pl/upload.. ?

Pozdrawiam,

[vsemak]

Podaj szczegóły tabeli w której znajdują się te wpisy to wtedy możemy Ci pomóc zwykłym UPDATE z warunkiem.

[andegrand2]

[SQL] pobierz, plaintext 
-- phpMyAdmin SQL Dump
-- version 3.1.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Czas wygenerowania: 08 Mar 2009, 12:20
-- Wersja serwera: 5.0.75
-- Wersja PHP: 5.2.8
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Baza danych: `techmania_pl`
--
 
-- --------------------------------------------------------
 
--
-- Struktura tabeli dla  `ms_postmeta`
--
 
CREATE TABLE IF NOT EXISTS `ms_postmeta` (
  `meta_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `post_id` bigint(20) NOT NULL DEFAULT '0',
  `meta_key` varchar(255) DEFAULT NULL,
  `meta_value` longtext,
  PRIMARY KEY  (`meta_id`),
  KEY `post_id` (`post_id`),
  KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1677 ;
 
--
-- Zrzut danych tabeli `ms_postmeta`
--
 
INSERT INTO `ms_postmeta` (`meta_id`, `post_id`, `meta_key`, `meta_value`) VALUES
(1, 3, '_edit_lock', '1228322821'),
(2, 3, '_edit_last', '1'),
(5, 6, '_edit_lock', '1228322795'),
(6, 6, '_edit_last', '1'),
(11, 10, '_edit_lock', '1228153621'),
(12, 10, '_edit_last', '2'),
(13, 11, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/blu-ray_discsvg.png'),
(14, 11, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:193;s:6:"height";i:193;s:14:"hwstring_small";s:22:"height=''96'' width=''96''";s:4:"file";s:80:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/blu-ray_discsvg.png";s:5:"sizes";a:1:{s:9:"thumbnail";a:3:{s:4:"file";s:27:"blu-ray_discsvg-150x150.png";s:5:"width";i:150;s:6:"height";i:150;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
(61, 28, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/vunow_01.jpg'),
(60, 27, '_edit_last', '2'),
(35, 10, 'keywords', 'kod,bluray,dvd,płyta,hack,złamany'),
(36, 10, 'title', 'Kod zabespieczający Blu-Ray złamany'),
(44, 20, '_edit_last', '1'),
(43, 20, '_edit_lock', '1229280373'),
(77, 37, '_edit_lock', '1227641001'),
(59, 27, '_edit_lock', '1228153614'),
(54, 20, 'title', 'Jak zostać bloggerem ?'),
(53, 20, 'keywords', 'blog,mobilesite,mobile,site,blogger,szukamy,zostan,bloggerem'),
(62, 28, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:450;s:6:"height";i:270;s:14:"hwstring_small";s:23:"height=''76'' width=''128''";s:4:"file";s:73:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/vunow_01.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:3:{s:4:"file";s:20:"vunow_01-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}s:6:"medium";a:3:{s:4:"file";s:20:"vunow_01-300x180.jpg";s:5:"width";i:300;s:6:"height";i:180;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
(63, 29, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/vunow_02.jpg'),
(64, 29, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:280;s:6:"height";i:242;s:14:"hwstring_small";s:23:"height=''96'' width=''111''";s:4:"file";s:73:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/vunow_02.jpg";s:5:"sizes";a:1:{s:9:"thumbnail";a:3:{s:4:"file";s:20:"vunow_02-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
(78, 37, '_edit_last', '1'),
(79, 38, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/komiczny-internet.jpg'),
(80, 38, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:400;s:6:"height";i:219;s:14:"hwstring_small";s:23:"height=''70'' width=''128''";s:4:"file";s:82:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/komiczny-internet.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:3:{s:4:"file";s:29:"komiczny-internet-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}s:6:"medium";a:3:{s:4:"file";s:29:"komiczny-internet-300x164.jpg";s:5:"width";i:300;s:6:"height";i:164;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
(99, 37, 'keywords', 'nasa,internet,kosmos,kosmiczny,prace'),
(100, 37, 'title', 'NASA pracuje nad kosmicznym internetem'),
(102, 42, '_edit_last', '1'),
(103, 43, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/tina.jpg'),
(101, 42, '_edit_lock', '1227642819'),
(104, 43, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:275;s:6:"height";i:159;s:14:"hwstring_small";s:23:"height=''74'' width=''128''";s:4:"file";s:69:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/tina.jpg";s:5:"sizes";a:1:{s:9:"thumbnail";a:3:{s:4:"file";s:16:"tina-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
(114, 42, 'title', 'Radzimy: Nie zostawiaj telefonu w Mc\\''Donaldzie'),
(113, 42, 'keywords', 'mc\\''donalds,tina,sherman,iphone'),
(115, 45, '_edit_lock', '1228322683'),
(116, 45, '_edit_last', '1'),
(117, 46, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/nokia-e75-01.jpg'),
(118, 46, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:1056;s:6:"height";i:792;s:14:"hwstring_small";s:23:"height=''96'' width=''128''";s:4:"file";s:77:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/nokia-e75-01.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:3:{s:4:"file";s:24:"nokia-e75-01-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}s:6:"medium";a:3:{s:4:"file";s:24:"nokia-e75-01-300x225.jpg";s:5:"width";i:300;s:6:"height";i:225;}}s:10:"image_meta";a:10:{s:8:"aperture";d:2.79999999999999982236431605997495353221893310546875;s:6:"credit";s:0:"";s:6:"camera";s:8:"DSC-W300";s:7:"caption";s:0:"";s:17:"created_timestamp";i:1227558164;s:9:"copyright";s:0:"";s:12:"focal_length";d:7.5999999999999996447286321199499070644378662109375;s:3:"iso";i:100;s:13:"shutter_speed";d:0.025000000000000001387778780781445675529539585113525390625;s:5:"title";s:0:"";}}'),
(394, 45, 'title', 'Przecieki o Nokii E75'),
(393, 45, 'keywords', 'nokia,e75,przeciek'),
(322, 107, '_edit_last', '1'),
(323, 108, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/12/nokia_n97_01.jpg'),
(152, 51, '_edit_last', '1'),
(153, 52, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/tosh_sdhc_01.jpg'),
(151, 51, '_edit_lock', '1228325776'),
(154, 52, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:399;s:6:"height";i:246;s:14:"hwstring_small";s:23:"height=''78'' width=''128''";s:4:"file";s:77:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/tosh_sdhc_01.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:3:{s:4:"file";s:24:"tosh_sdhc_01-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}s:6:"medium";a:3:{s:4:"file";s:24:"tosh_sdhc_01-300x184.jpg";s:5:"width";i:300;s:6:"height";i:184;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
(159, 55, '_wp_attached_file', '/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/toshibasdcards.jpg'),
(160, 55, '_wp_attachment_metadata', 'a:6:{s:5:"width";i:494;s:6:"height";i:243;s:14:"hwstring_small";s:23:"height=''62'' width=''128''";s:4:"file";s:79:"/home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/2008/11/toshibasdcards.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:3:{s:4:"file";s:26:"toshibasdcards-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}s:6:"medium";a:3:{s:4:"file";s:26:"toshibasdcards-300x147.jpg";s:5:"width";i:300;s:6:"height";i:147;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}'),
(163, 57, '_edit_lock', '1227946456'),
(164, 57, '_edit_last', '1'),
[SQL] pobierz, plaintext 

itd.

Każdy obrazek ma taką ścieżkę /home/sznajdrowicz/ftp/MobileSite/wp-content/uploads/... co na stronie wynikuje http://domena1.pl/MobileSite/wp-content/uploads/...

Jest tego mocno dużo i nie wiem jak się do tego za bardzo zabrać

Pozdrawiam,

[erix]

A google zbanowali: http://www.liewcf.com/blog/archives/2005/0...mysql-database/
?

[andegrand2]

Dzięki za link Ale mam problem z zastosowaniem go.

[SQL] pobierz, plaintext 
UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`,"liewcf.com/wp","liewcf.com/blog")
[SQL] pobierz, plaintext 

Za wp_posts wstawiam sobie ms_postmeta a za reszte co bo próbuje i próbuje i za każdym razem wyżuca tabela nie istnieje.Pozdrawiam

Już śmiga Dzięki za pomoc,

Ten post edytował andegrand2 8.03.2009, 19:18:58