At Christmas, I had to change the server on which r website was hosted. I used the backup module to do that : it worked perfectly, and I was quite amazed.
I took back the server home, to put it in intensive care. It came out of them this morning, and I was looking forward to put it back in place.
And here my problem start : I stopped the site from the server n°2, backedup the database with backup. No problem till here.
I plugged back the first server, booted, no problem. I had reinstalled the same site as previously (just the same way I had done at christmas), and then re-ftp all the files from server 2 to server 1. All that was missing were the databases ... The only way to implement them back with the backup moduile was to put the server back in place, no problem, log in as webmaster, no problem, install the backup module, no problem, put the .gz file in place and then run the backup script.
Here comes the messing : the backup script starts, beginning with a tremendous error at the line 34, and ending kilometers of text further with a Quote:
MySQL: MySQL server has gone away
Stopped on error
Start from the beginning (DROP the old tables before restarting)
. I then tried to use Phpmyadmin with various files : MySQL backup (*.sql), it does not work, nothing happens.
I then desperatly tried to put back the database as it was at christmas : the modules have not changed at all, everything is the same but a few articles that I will write again.
The backup script tells me it is successfull, having stopped at line 33 !! Nothing changes then (my .gz is 360 k and should contain quite a lot of lines ...).
I noted that on the first server, MySQL is 3.23, on the temporary replacement server, it is 5.0.
Could it be this that is messing the whole thing ?
What can I do then ? Further than this, what can I do even to put back the database as it was at christmas ?
I need some help !
Thanx in advance
