There are a way to change host without downtime?

Markos said:
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?
Click to expand...
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.
 
SSH/SFTP/FTP. If your DB is that large, then odds are you will time out when trying to upload it via PhpMyAdmin.
 
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.
 
If you can't use ssh, as an alternative, you can export and import a bunch of tables at a time.
 
Markos said:
I'm not very familiar with SSH, there is a way to upload it with FTP?
Click to expand...
Yes, upload it via FTP then use SSH to import it.

The command is simply:
Code: 
mysql -u -p database_name < backup_name.sql
 
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.
 
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
 
You must log in or register to reply here.
Back
Top Bottom