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

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);

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'

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

Re: How to transfert a big amount of data from one server to another one ?

yeh but he already said he didn't tongue

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

Re: How to transfert a big amount of data from one server to another one ?

well ok but i took this as a no tongue

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

Re: How to transfert a big amount of data from one server to another one ?

MySQLDumper was the solution 

tx