There are a way to change host without downtime?

[Paul B]

Use ssh.

 

[MattW]

I have some problems on uploading the DB on new server...i'm trying to upload with PHPmyAdmin but when i'm try to upload this (it's over 1GB). There is another way to import a DB without PHPMYAdmin?

As @Brogan has suggested, use SSH. Copy the file to the server, login to MySQL with the relevant user, and select the database you want to import it into. The use the source command and point to the sql file to import.

 

[TPerry]

SSH/SFTP/FTP. If your DB is that large, then odds are you will time out when trying to upload it via PhpMyAdmin.

 

[Markos]

I'm not very familiar with SSH, there is a way to upload it with FTP?

 

[EQnoble]

You could move the DB dump.sql file to a non public directory your new server using ftp but you would still need to SSH in so you can use the command to import it into mysql.

 

[Kintaro]

If you can't use ssh, as an alternative, you can export and import a bunch of tables at a time.

 

[Paul B]

I'm not very familiar with SSH, there is a way to upload it with FTP?

Yes, upload it via FTP then use SSH to import it.

The command is simply:

mysql -u -p database_name < backup_name.sql

 

[kontrabass]

I'd get in touch with admingeekz. They migrated my 14M post board with indeed 0 downtime. They live sync the new server somehow, then simply change DNS over.

 

[Tower]

I can help you as well, as I run centos with plesk. Shoot me a PM and id be glad to help you out for free. (Donation accepted) LOL