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

[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]

Originally Posted by redspider

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

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

[redspider]

sorry english version click

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

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

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

[redspider]

Originally Posted by 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.

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!