sql backup made easy

[redspider]

Just wanted to share a note with others. After trying to backup sql with putty, and having NO luck using the software because of not knowing how to use the commands or server shh were not working and given me an error no socket found message. I than tried with mysql panel and the data transfered was incomplete.

I found a program or script called mysqldump from an open source and is was free.
I backed up my sql and tranfered it to the new server, it was easy and I did not need to be a guru to use it

here the link if other want to use it :
click (http://www.mysqldumper.de/de/index.php)

[FleaBag]

Taking a look at this now. My current server is unreliable and old - I have a new one ready but I cannot dump my database as it is over 200mb in size. Hoping this works!

[redspider]

for me work well and did not time out is like burning a cd with under buffer protection LOL.

[maroulis]

I backed up my sql and tranfered it to the new server, it was easy and I did not need to be a guru to use it here the link if other want to use it :
click (http://www.mysqldumper.de/de/index.php)

I think it's easier to learn how to use PHPMyAdmin to do SQL dump than read GERMAN :)

[redspider]

sorry english version click (http://www.mysqldumper.de/en/index.php)

[FleaBag]

I saw the English version... ;)

phpMyAdmin does not work, it times out also - this is why I need to try this software - else my site is stuck on a dying server forever.

[Guest210212002]

I have a howto written for pretty much this exact thing. :) Check my sig.

https://vborg.vbsupport.ru/showthread.php?p=875820

[redspider]

I saw the English version... ;)

phpMyAdmin does not work, it times out also - this is why I need to try this software - else my site is stuck on a dying server forever.
I was getting error with putty and I did some search then I found mysqldumber and work awsome I already transfer my sql from one server to another no lost of data .

[filburt1]

mysqldump is a built-in MySQL program. I have it make daily automatic backups of my site's database via a cron job, completely transparently.

[FleaBag]

SSH doesn't seem to allow me to restore for some reason. Hence why I've reverted to PHP scripts. I'm doing a test dump using it now... Fingers crossed eh!

[Guest210212002]

mysqldump is a built-in MySQL program. I have it make daily automatic backups of my site's database via a cron job, completely transparently.

* Guest210212002 notes that anyone wondering how filburt does that should look at his how-to. :)

[FleaBag]

OK so I did the dump overnight. The database according to phpMyAdmin is 210mb... Thegzip of it is 51mb, the gunzipped file is 364mb. Does this sound right? As I've had some trouble with dumps creating databases 600mb in size/being corrupt.

[redspider]

did you try mysqldumper ?

[FleaBag]

That's what I did the dump with last night.

EDIT:

redspider you have saved my site! I'm eternally greatful. Reimported via SSH on the new server like a dream. I'll be donating to their project, only script that's managed to back up my database and I have tried many!

On a side note, phpMyAdmin says my 'collation' is 'latin1_swedish_ci'. My site certainly isn't Swedish. Is this going to be a problem?

[redspider]

That's what I did the dump with last night.

EDIT:

redspider you have saved my site! I'm eternally greatful. Reimported via SSH on the new server like a dream. I'll be donating to their project, only script that's managed to back up my database and I have tried many!

On a side note, phpMyAdmin says my 'collation' is 'latin1_swedish_ci'. My site certainly isn't Swedish. Is this going to be a problem?

I really dont know the anwser to that one but my guess is no.

all we need is someone to integrate this to vbulletin admin panel and this will make backup so easy for the non guru like me .

[FleaBag]

I don't think that will be allowed with the license they distribute under. But something of a similar logic would be a huge benefit. The tool included it useless on most servers with a medium to large database. I understand that SSH can solve the issue, but I have just had to move off a server that did not offer SSH - as a result I had a huge struggle getting the DB off the server. I will test the database later tonight when I finish work. :)

[redspider]

let me know if work good for you . Good luck !

[FleaBag]

It bloody worked!

[redspider]

I really happy for you. :)
all we need now is someone to make a hack that integrate this to vb .

[tendo]

this thing is awesome thanks for pointing me to it <3

[redspider]

the software have a option to create a .htaccess file or you can upload you own .

you can ask someone more advance how to create a .htaccess file my english not good enough to explain to you sorry.

[tendo]

yeah sorry i was being dumb hehe

[redspider]

no you not dumb everybody sometimes need help and here there some peeps that are willing to help with out try to give you a hard time .
so ask all you need . :)