Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Moving FLV to other server

  1. #1
    Join Date
    Jun 2011
    Posts
    21

    Default Moving FLV to other server

    I am trying to move the flv files to a media server, not the same one that runs the program. I just made a 2gig zip and moved it to the new server, opened the file, made sure the server is added in the vshare site. All okay.

    I went to the actual database, into the video table and edited all the entries to reflect the server 1. But it still looks for the file locally. What can I do?

  2. #2
    Join Date
    Sep 2007
    Posts
    906

    Default

    In phpmyadmin, select details of a video and server table and paste here. Also post link to the video.
    vShare Hosting, vShare Installation, Server Setup, Lighttpd streaming, vShare Templates
    [email protected]

  3. #3
    Join Date
    Jun 2011
    Posts
    21

    Default

    --
    -- 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 */;

  4. #4
    Join Date
    Sep 2007
    Posts
    906

    Default

    I can't find anything from the post. May be you should post link to the video you are having problem.
    vShare Hosting, vShare Installation, Server Setup, Lighttpd streaming, vShare Templates
    [email protected]

  5. #5
    Join Date
    Jun 2011
    Posts
    21

    Default

    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).

  6. #6
    Join Date
    Sep 2007
    Posts
    906

    Default

    That is right, no other changes required.
    vShare Hosting, vShare Installation, Server Setup, Lighttpd streaming, vShare Templates
    [email protected]

  7. #7

    Default

    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.

  8. #8
    Join Date
    Jun 2011
    Posts
    21

    Default

    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

  9. #9

    Default

    Hi,

    which vShare version you are using?

  10. #10
    Join Date
    Jun 2011
    Posts
    21

    Default

    vShare version: 2.8.1 (DB Version: 2.8.1)

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •