first this is the iso
http://httpupdate.cpanel.net/cPanel-CentOS-6.4-x86_64.iso
always get lattest from this url
http://httpupdate.cpanel.net/
ok lets start
log in to the host server ssh
[php]
cd /
mkdir /isolib
wget http://httpupdate.cpanel.net/cPanel-CentOS-6.4-x86_64.iso
xe sr-create name-label=isolib type=iso device-config:legacy_mode=true device-config:location=/isolib content-type=iso
[/php]
finished then go create virtual vm and install centos if any question comment me
[php]SET @sql = NULL;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
‘MAX(IF(pa.meta_name = ”’,
meta_name,
”’, "pa.meta_value", NULL)) AS ‘,
meta_name
)
) INTO @sql
FROM post_meta;
SET @sql = CONCAT(‘SELECT p.id
, p.name
, p.type, ‘, @sql, ‘
FROM post p
LEFT JOIN post_meta AS pa
ON p.id = pa.post_id
GROUP BY p.id’);
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
[/php]
also this is the db structure may help any
[php]
DROP TABLE IF EXISTS `post`;
CREATE TABLE IF NOT EXISTS `post` (
`id` int(11) DEFAULT NULL,
`name` varchar(10) DEFAULT NULL,
`type` varchar(50) DEFAULT NULL,
`order` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `post` (`id`, `name`, `type`, `order`) VALUES
(1, ‘product1’, ‘first product’, 5),
(2, ‘product2’, ‘second product’, 5);
DROP TABLE IF EXISTS `post_meta`;
CREATE TABLE IF NOT EXISTS `post_meta` (
`post_id` int(11) DEFAULT NULL,
`meta_name` varchar(10) DEFAULT NULL,
`meta_value` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `post_meta` (`post_id`, `meta_name`, `meta_value`) VALUES
(1, ‘size’, ‘\’\’\”),
(1, ‘height’, ‘103’),
(2, ‘size’, ‘L’),
(2, ‘title’, ’13’),
(2, ‘color’, ‘????’);
[/php]
before you go with this please backup your date i am not responsible about your errors 🙂
enjoy
[php]
DELETE pm
FROM wp_postmeta pm
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id
WHERE wp.ID IS NULL
[/php]