Topic: How to transfert a big amount of data from one server to another one ?
Hi,
I 've something like 70 Mega in my actual mysql database. I plan to move soon to a new hoster. What is the best way to move it ? FTP ?
Thanks
Re: How to transfert a big amount of data from one server to another one ?
Do you have shell access?
"Programming is like sex: one mistake and you have to support it for the rest of your life."
Re: How to transfert a big amount of data from one server to another one ?
Rickard wrote:
Do you have shell access?
Infortunatly not !!!
Other way ? I which not to have split my data in 100 small file ...
- Connorhd
- Former PunBB Developer
- Offline
Re: How to transfert a big amount of data from one server to another one ?
if you make a sql dump using phpmyadmin and upload it to your new host then ask them to insert it into your database, any good host should do it for you
Re: How to transfert a big amount of data from one server to another one ?
Well, you can try downloading a database dump via e.g. phpMyAdmin. Gzipped or not. You should then, in theory, be able to upload it on the new server.
"Programming is like sex: one mistake and you have to support it for the rest of your life."
Re: How to transfert a big amount of data from one server to another one ?
Yes, but for some odd reason PhpMyAdmin has a low max upload limit. Even with gzip Im not sure if you can get it down the the needed size (on my host its 5mb).
Indocron
$theQuestion = (2*b) || !(2*b);
$theQuestion = (2*b) || !(2*b);
Re: How to transfert a big amount of data from one server to another one ?
tuyau45 wrote:
Hi,
I 've something like 70 Mega in my actual mysql database. I plan to move soon to a new hoster. What is the best way to move it ? FTP ?
Thanks
ftp, http, scp (shell needed)
Re: How to transfert a big amount of data from one server to another one ?
If you have shell access on the new server, do this:
- Put the datadump into a public html folder (be careful not to let anyone know about this)
- Login to new server via SSH
- use wget to retrieve the datadump from the old server - usage: 'wget http://example.org/filename.tar.gz'
- Connorhd
- Former PunBB Developer
- Offline
Re: How to transfert a big amount of data from one server to another one ?
how can you login to a server via ssh without shell access?
Re: How to transfert a big amount of data from one server to another one ?
Try out MySQLDumper: http://www.mysqldumper.de
I can't say anything about the english documentation but you can do the following:
- install MySQLDumper on both your old and new server
- make a backup of your complete database and download it as a .gz file
- copy this backup-file in the right folder on your new server
- use MySQLDumper to load the backup and reconstruct your database
It works fine for me and you don't have to deal with shell access or upload limits.
Re: How to transfert a big amount of data from one server to another one ?
Thanks for your help. I will try MySQLDumper soon and i will let you know !
Re: How to transfert a big amount of data from one server to another one ?
Connorhd wrote:
how can you login to a server via ssh without shell access?
Note how I said 'If you have shell access on the new server'...
- Connorhd
- Former PunBB Developer
- Offline
Re: How to transfert a big amount of data from one server to another one ?
yeh but he already said he didn't 
Re: How to transfert a big amount of data from one server to another one ?
He hadn't explained if he had found a new host or not. Therefore my point remains valid, on the grounds that we know not if the new host has shell access or not. I was just trying to help. 
- Connorhd
- Former PunBB Developer
- Offline
Re: How to transfert a big amount of data from one server to another one ?
well ok but i took this as a no
tuyau45 wrote:
Rickard wrote:Do you have shell access?
Infortunatly not !!!
Re: How to transfert a big amount of data from one server to another one ?
Infortunatly I forget my inderwear today. 
Re: How to transfert a big amount of data from one server to another one ?
MySQLDumper was the solution
tx