Moving FLV to other server

[hostonnet]

In phpmyadmin, select details of a video and server table and paste here. Also post link to the video.

[onlinetv]

--
-- Table structure for table `video`
--
CREATE TABLE IF NOT EXISTS `video` (
`VID` bigint(20) NOT NULL auto_increment,
`UID` bigint(20) NOT NULL default '0',
`seo_name` varchar(255) NOT NULL,
`title` varchar(120) NOT NULL default '',
`description` text NOT NULL,
`featuredesc` text NOT NULL,
`keyword` text NOT NULL,
`channel` varchar(255) NOT NULL default '0|',
`vdoname` varchar(40) NOT NULL default '',
`flvdoname` varchar(40) default NULL,
`duration` float NOT NULL default '0',
`video_length` varchar(255) default NULL,
`space` float unsigned NOT NULL default '0',
`type` varchar(7) NOT NULL default '',
`vtype` int(2) NOT NULL,
`addtime` varchar(20) default NULL,
`adddate` date NOT NULL default '0000-00-00',
`record_date` date NOT NULL default '0000-00-00',
`location` text NOT NULL,
`country` varchar(120) NOT NULL default '',
`viewnumber` bigint(10) NOT NULL default '0',
`viewtime` datetime NOT NULL default '0000-00-00 00:00:00',
`com_num` int(8) NOT NULL default '0',
`fav_num` int(8) NOT NULL default '0',
`featured` char(3) NOT NULL default 'no',
`ratedby` bigint(10) NOT NULL default '0',
`rate` float NOT NULL default '0',
`filehome` varchar(120) NOT NULL default '',
`be_comment` char(3) NOT NULL default 'yes',
`be_rated` char(3) NOT NULL default 'yes',
`embed` varchar(8) NOT NULL default 'enabled',
`embed_code` text,
`voter_id` varchar(255) NOT NULL default '',
`active` int(1) NOT NULL default '0',
`approve` int(1) NOT NULL default '0',
`adult` tinyint(1) NOT NULL default '0',
`server_id` int(1) NOT NULL default '0',
PRIMARY KEY (`VID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=370 ;
--
-- Dumping data for table `video`
--
INSERT INTO `video` (`VID`, `UID`, `seo_name`, `title`, `description`, `featuredesc`, `keyword`, `channel`, `vdoname`, `flvdoname`, `duration`, `video_length`, `space`, `type`, `vtype`, `addtime`, `adddate`, `record_date`, `location`, `country`, `viewnumber`, `viewtime`, `com_num`, `fav_num`, `featured`, `ratedby`, `rate`, `filehome`, `be_comment`, `be_rated`, `embed`, `embed_code`, `voter_id`, `active`, `approve`, `adult`, `server_id`) VALUES
(135, 19, 'harlemchanging-times', 'Harlem/Changing Times', 'Grassroots residents and supporters talk about their personal experiences in Harlem and the economic and social changes of this historic community. Al Turnquest / Producer', '', 'community education diversity', '0|6|7|20|0', 'arlem_Changing_Times-Youtube.mov', '1225217402944129918.flv', 465, '07:45', 29.44, 'public', 0, '1225217402', '2008-10-28', '0000-00-00', '', '', 492, '2011-06-09 14:46:34', 0, 0, 'no', 0, 0, '', 'yes', 'yes', 'enabled', NULL, '', 1, 1, 0, 1);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;



phpMyAdmin SQL Dump
-- version 3.4.3.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 04, 2011 at 10:47 AM
-- Server version: 5.0.92
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `share`
--
-- --------------------------------------------------------
--
-- Table structure for table `servers`
--
CREATE TABLE IF NOT EXISTS `servers` (
`id` int(11) NOT NULL auto_increment,
`ip` varchar(255) NOT NULL,
`url` varchar(255) NOT NULL,
`user_name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`folder` varchar(255) NOT NULL,
`status` int(1) NOT NULL default '0',
`space_used` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `servers`
--
INSERT INTO `servers` (`id`, `ip`, `url`, `user_name`, `password`, `folder`, `status`, `space_used`) VALUES
(1, 'IP_NUMBER', 'http://www.wherever.com/', '[email protected]', 'password', 'videos', 1, 6974108);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[hostonnet]

I can't find anything from the post. May be you should post link to the video you are having problem.

[onlinetv]

There is no need for a link to any video.

1) Video originally sits on the vshare site
2) I set up a server on another provider and copy the files there.
3) I set up a remote server in vshare to the other provider where the files are now.
4) I pull up phpadmin and go through the video entries one by one and change the ones that go to the other provider so that server is 1.
5) I delete the files on the vshare site.
6) The video shows and error because the file is missing on the vshare site - not the new remote server.

I put the files back on the vshare so that they show and do not error. The question is if there is something other than the manual change on the video record to show server = 1??

I mean I could delete the file on the vhare site so you get an error but that would prove out nothing. The actual error will show in the player and would say it cant find the file on the vhare site (not the other provider site).

[hostonnet]

That is right, no other changes required.

[vshare2]

Hi,

Admin -> Video Management -> Local Videos: you can move local videos to the remote server(must be added and enabled in vShare).

If you can't get it fixed, open a support ticket at

BuyScripts Helpdesk

with your vShare admin and FTP login details.

Thanks,

Buyscripts Team.

[onlinetv]

That is very interesting! I used the Admin -> Video Management -> Local Videos and it is working.

I have a few questions:

1) does the Admin -> Video Management -> Local Videos actually ftp (move) the files to the new server?
2) Since I already uploaded all the videos to the server and changed all the Server ID in the Video records is there another place I can just manually adjust these?

On large files I get this error and am unable to move them in the video management:


ERROR: Unable to execute query

UPDATE `videos` SET `video_server_id`='1' WHERE `video_id`='256'MySQL server has gone away