ssh da db yi yedeklemek.

raptor

merhaba bir sitemin sql dosyası biraz büyük ve yedek alırken bilgisayarıma her defasında bağlantı kopuyor bunu ssh da bir dizine nasıl kayıt edebilirim daha sonra flashget le vs indirebilmek için.

iyinet · 22 Mart 2007

Bu program ile Linux da dosyalari kucuk parcalara ayirabilirsin.
http://www.freebyte.com/download/lxsplit.tar.gz

Bu program ile de windows da tekrar tek parca haline getirebilirsin.
http://www.freebyte.net/download/hjsplit.zip

Unutmam · 22 Mart 2007

Aynı sorun bende de var ssh harici başka yöntemi varmıdır bunun? ssh yetkisi yok.

Uzmanium · 22 Mart 2007

Bütün veritabanlarını yedeklemek için

Kod:

mysqldump --opt --user=root --password --all-databases | bzip2 -c
> /backup/mysql.sql.bz2

site1 veritabanını yedek almak için ;

Kod:

mysqldump --database site1 > site1.sql -u root -p

site1 ve site2 dblerini yedeklemek için

Kod:

mysqldump --database site1 site2 > site1vesite2.sql -u root -p

root yerine sizin kullanıcı adınızı yazmalısınız. Eğer root olarak erişebiliyorsanız böyle kalabilir.

iyinet · 22 Mart 2007

Oturdum yazdim

Bu mesaj uzerine oturdum sizin icin PHP de dosya parcalayan program yazdim.
Hayrini gorun. Windows da http://www.freebyte.com/hjsplit/ ile birlestirin.

Isteyen kisiler baslik kismi kalmak sarti ile bu kodu yayinlayabilirler.

raptor · 22 Mart 2007

iyinet farkı

tşkler.

iyinet · 12 Nisan 2007

HJSplit uyumlu Dosya bolen PHP scriptin yenilenmis hali eklenmistir.

Desi-Instincts · 10 Mart 2008

Im sorry i dont know the language used in the forum, but i do know english ... but im having problem with the php script of HJsplit which splits the files online. I have changed the paths but im unable to get it working. I have modified the script as under :

// Edit here (3 variables)
// ---------------------------
// File to split, is its not in the same folder with filesplit.php, full path is required.
$file = "http://desi-instincts.com/Games%20(Latest)%20(2007)/GtASa/GTA%20San%20Andreas.part01.exe";

// Target folder. Splitted files will be stored here. Original file never gets touched.
// Do not append slash! Make sure webserver has write permission on this folder.
$targetfolder = '/www/tmp';

// File size in Mb per piece. For a 200Mb file if piecesize=10 it will result with 20 x 10Mb files
$piecesize = 100;

Angelo · 10 Mart 2008

Is targetfolder writeable?

WizarD · 10 Mart 2008

Burdaki script isini gorecektir kullandigim bir sistem cron ile birlite istediginiz saatlerde yedeginizi alabilirsiniz

Desi-Instincts · 10 Mart 2008

Yes it is writable, i created a folder named "tmp" as declared in the script and then changed its permission to read, write as well as execute.

Angelo · 10 Mart 2008

Desi-Instincts' Alıntı:
Yes it is writable, i created a folder named "tmp" as declared in the script and then changed its permission to read, write as well as execute.

Do you have any specific error messages you get?

Desi-Instincts · 10 Mart 2008

This is what it says :

Warning: fopen(http://desi-instincts.com/tmp/http:...) (2007)/GtASa/GTA San Andreas.part01.exe.001) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /mounted-storage/home90b/sub008/sc42254-ESFQ/www/filesplit.php on line 62
Splitting http://desi-instincts.com/Games (Latest) (2007)/GtASa/GTA San Andreas.part01.exe into 100 Mb files (last piece may be smaller in size) ...
http://desi-instincts.com/tmp/http:...) (2007)/GtASa/GTA San Andreas.part01.exe.001

Warning: fwrite(): supplied argument is not a valid stream resource in /mounted-storage/home90b/sub008/sc42254-ESFQ/www/filesplit.php on line 67
filesplit.php is unable to write to current folder.
I think it does not have write permission!
Try chmod +w folder

Desi-Instincts · 10 Mart 2008

The above mentioned error arises when the contents of the filesplit.php is :

// Edit here (3 variables)
// ---------------------------
// File to split, is its not in the same folder with filesplit.php, full path is required.
$file = "http://desi-instincts.com/Games%20(Latest)%20(2007)/GtASa/GTA%20San%20Andreas.part01.exe";

// Target folder. Splitted files will be stored here. Original file never gets touched.
// Do not append slash! Make sure webserver has write permission on this folder.
$targetfolder = 'http://desi-instincts.com/tmp';

// File size in Mb per piece. For a 200Mb file if piecesize=10 it will result with 20 x 10Mb files
$piecesize = 100;

Angelo · 10 Mart 2008

I didnt write the script, but you can try the following and see if that helps.
Change the following to relative paths instead of URL.
Assuming your script is on the base path of desi-instincts.com

$file = "http://desi-instincts.com/Games%20(Latest)%20(2007)/GtASa/GTA%20San%20Andreas.part01.exe";

->

$file = "Games%20(Latest)%20(2007)/GtASa/GTA%20San%20Andreas.part01.exe";

Desi-Instincts · 10 Mart 2008

I had actually i think tried that before. However, the script is written by :

Author:
Umit Tirpan 2007-03-22
Author's Website:
http://forum.iyinet.com/

Is he the admin of this forum. ??

Angelo · 10 Mart 2008

Yes. He may be more of assistance when he is online. Though i strongly think relative path would work.

Angelo · 10 Mart 2008

I checked it again, the problem is not the first directive, its the second one. You are trying to make a writable connection to an HTTP protocol. Thats why you are getting the error.

Change
$targetfolder = 'http://desi-instincts.com/tmp';
to

$targetfolder = 'tmp';
or
$targetfolder = '/mounted-storage/home90b/sub008/sc42254-ESFQ/www/tmp';

Desi-Instincts · 10 Mart 2008

Well a very foolish question : hope he knows english .... he shud i guesss ??

Desi-Instincts · 10 Mart 2008

so you mean the source file's path :

$file = "http://desi-instincts.com/Games%20(Latest)%20(2007)/GtASa/GTA%20San%20Andreas.part01.exe";

is ok right ??