Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #1  
Old 16th February 2013, 16:11
LeCt0r LeCt0r is offline
Member
 
Join Date: Mar 2009
P2P
Posts: 8
Default Problem
heloo i have an sql db of 100 mb and on my upload server max 2 ,1 mb i zipped with winrar but it to larger 18 mb i try with splitter and make me 20 sql spltter arhives.and thw i try to upload give me error ..wich recomand me?
.
Reply With Quote
  #2  
Old 16th February 2013, 16:16
mat22 mat22 is offline
Senior Member
 
Join Date: Jun 2009
Latvia
Posts: 119
Default
You can always open it in Notepad or Notepad++, press Ctrl+A, then Ctrl+C and then in your phpmyadmin open database, choose "SQL" on top and then press Ctrl+V to copy everything in. But that amount of text may crash you. But you can always try it!
Reply With Quote
  #3  
Old 16th February 2013, 16:18
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
use bigdump
http://www.ozerov.de/bigdump/
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in BT.Manager™ forum
My Current Demo is here http://demo.btmanager.org/
Reply With Quote
  #4  
Old 16th February 2013, 16:35
x360zone's Avatar
x360zone x360zone is offline
Senior Member
 
Join Date: Jul 2011
United Kingdom
Posts: 915
Default hi
and if big dump dont work you need to go vps and set your file upload to what ever you need then. ive had success with bigdump and had issues good luck
__________________

7.5 tsse
future tracker source & hosting, vps
trackers installs + Themes
http://www.foxyhosting.co.uk
http://www.downmy.top testing zone
offshore vps & cpanel hosting & Shoutcast & VPN
STOP cyberbullying
any setups tracker installs vps hosting vps setups themes mods hit me up
over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is


Reply With Quote
  #5  
Old 16th February 2013, 22:20
LeCt0r LeCt0r is offline
Member
 
Join Date: Mar 2009
P2P
Posts: 8
Default
Can't open import for import
Please, check that your dump file name contains only alphanumerical characters, and rename it accordingly, for example: import.
Or, specify $filename in bigdump.php with the full filename.
Or, you have to upload the import to the server first.

i solv first problem but:(
Error at the line 174: (170, 128, 2731);
Query: --
--
INSERT INTO `addedrequests` (`id`, `requestid`, `userid`) VALUES
(2, 2, 2731),
(3, 3, 2731),
(19, 19, 2731),
(18, 18, 2731),
(33, 23, 5682),
(21, 19, 5682),
(14, 14, 2731),
(15, 15, 2731),
(20, 19, 5232),
(22, 20, 5314),
(23, 19, 5314),
(24, 20, 2731),
(32, 23, 2731),
(26, 21, 5314),
(27, 21, 2731),
(28, 22, 5314),
(29, 22, 2731),
(30, 21, 5682),
(31, 22, 5682),
(34, 24, 2731),
(35, 24, 5682),
(36, 25, 2793),
(37, 25, 2731),
(38, 25, 5682),
(39, 26, 2731),
(40, 27, 2731),
(41, 28, 2731),
(42, 29, 2731),
(43, 26, 5682),
(44, 29, 5682),
(45, 27, 5314),
(46, 28, 5314),
(47, 30, 5314),
(48, 30, 2731),
(49, 30, 5682),
(50, 31, 5314),
(51, 31, 2731),
(52, 32, 2793),
(53, 32, 2731),
(59, 38, 2731),
(55, 34, 2731),
(60, 39, 2731),
(61, 40, 2731),
(99, 78, 2731),
(63, 42, 2731),
(64, 43, 2731),
(65, 44, 2731),
(66, 45, 2731),
(67, 46, 2731),
(68, 47, 2731),
(69, 48, 2731),
(70, 49, 2731),
(71, 50, 2731),
(72, 51, 2731),
(73, 52, 2731),
(74, 53, 2731),
(75, 54, 2731),
(76, 55, 2731),
(77, 56, 2731),
(78, 57, 2731),
(79, 58, 2731),
(80, 59, 2731),
(81, 60, 2731),
(82, 61, 2731),
(83, 62, 2731),
(84, 63, 2731),
(85, 64, 2731),
(86, 65, 2731),
(88, 67, 2731),
(89, 68, 2731),
(90, 69, 2731),
(91, 70, 2731),
(92, 71, 2731),
(93, 72, 2731),
(94, 73, 2731),
(95, 74, 2731),
(96, 75, 2731),
(97, 76, 2731),
(98, 77, 2731),
(117, 96, 2731),
(118, 97, 2731),
(119, 98, 2731),
(120, 99, 2731),
(121, 100, 2731),
(122, 101, 2731),
(123, 102, 2731),
(124, 103, 2731),
(125, 104, 2731),
(126, 105, 2731),
(127, 106, 2731),
(128, 107, 2731),
(129, 108, 2731),
(130, 109, 2731),
(131, 110, 2731),
(132, 111, 2731),
(133, 112, 2731),
(134, 113, 2731),
(135, 114, 2731),
(136, 115, 2731),
(137, 116, 2731),
(138, 77, 6742),
(139, 30, 6742),
(140, 14, 6742),
(141, 117, 2731),
(142, 118, 2731),
(143, 46, 9974),
(144, 119, 10268),
(145, 119, 2731),
(146, 120, 2731),
(147, 121, 2731),
(148, 122, 2731),
(149, 120, 3224),
(150, 123, 2731),
(151, 124, 3413),
(152, 124, 2731),
(153, 122, 12671),
(154, 125, 4135),
(155, 126, 2793),
(156, 126, 2731),
(157, 53, 12671),
(158, 56, 12671),
(159, 77, 13120),
(160, 127, 9301),
(161, 128, 9301),
(162, 129, 9301),
(163, 130, 9301),
(164, 131, 9301),
(165, 131, 2899),
(166, 130, 2899),
(167, 131, 2731),
(168, 130, 2731),
(169, 129, 2731),
(170, 128, 2731);

MySQL: Duplicate entry '2' for key 'PRIMARY'
Reply With Quote
  #6  
Old 16th February 2013, 22:36
x360zone's Avatar
x360zone x360zone is offline
Senior Member
 
Join Date: Jul 2011
United Kingdom
Posts: 915
Default hi
read what i say above if it dont work you need to upgrade your host to vps or one with a larger mysql import other than that have a good evening
__________________

7.5 tsse
future tracker source & hosting, vps
trackers installs + Themes
http://www.foxyhosting.co.uk
http://www.downmy.top testing zone
offshore vps & cpanel hosting & Shoutcast & VPN
STOP cyberbullying
any setups tracker installs vps hosting vps setups themes mods hit me up
over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is


Reply With Quote
  #7  
Old 16th February 2013, 23:53
LeCt0r LeCt0r is offline
Member
 
Join Date: Mar 2009
P2P
Posts: 8
Default
Quote:
Originally Posted by x360zone View Post
read what i say above if it dont work you need to upgrade your host to vps or one with a larger mysql import other than that have a good evening
i'M sorry but i dont know where to site vsp to upload large..
Reply With Quote
  #8  
Old 17th February 2013, 00:03
x360zone's Avatar
x360zone x360zone is offline
Senior Member
 
Join Date: Jul 2011
United Kingdom
Posts: 915
Default hi
right now your using shared hosting? with cpanel example

so you have outgrown your hosting now you need vps hosting so you can upload files sizes like 200mb and so on these run from a few £ upwards i sell vps and others
__________________

7.5 tsse
future tracker source & hosting, vps
trackers installs + Themes
http://www.foxyhosting.co.uk
http://www.downmy.top testing zone
offshore vps & cpanel hosting & Shoutcast & VPN
STOP cyberbullying
any setups tracker installs vps hosting vps setups themes mods hit me up
over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is


Reply With Quote
  #9  
Old 17th February 2013, 21:24
LeCt0r LeCt0r is offline
Member
 
Join Date: Mar 2009
P2P
Posts: 8
Default
Quote:
Originally Posted by x360zone View Post
right now your using shared hosting? with cpanel example

so you have outgrown your hosting now you need vps hosting so you can upload files sizes like 200mb and so on these run from a few £ upwards i sell vps and others
yea i use cpanel i have an host but where it that thing you talk about
Reply With Quote
  #10  
Old 17th February 2013, 22:25
x360zone's Avatar
x360zone x360zone is offline
Senior Member
 
Join Date: Jul 2011
United Kingdom
Posts: 915
Default hi
host-us my link underneath we host vps nodes which can do this


this dont mean purchasing a cpanel hosting again from me lol especially in the name your trying to purchase in



YOU NEED VPS
__________________

7.5 tsse
future tracker source & hosting, vps
trackers installs + Themes
http://www.foxyhosting.co.uk
http://www.downmy.top testing zone
offshore vps & cpanel hosting & Shoutcast & VPN
STOP cyberbullying
any setups tracker installs vps hosting vps setups themes mods hit me up
over the last three months ive become a snake breeder,pythons,hogs,boa,corn,rat,king,carpet and what joy it is



Last edited by x360zone; 17th February 2013 at 23:36.
Reply With Quote
Reply

Tags
problem

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 02:08. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.