How to transfer?

[Hamed]

I have database over 500MB in cPanel I want to transfer it to an other server Cpanel.
I don't know how?
I don't have SSH for this job.

 

[Dynash]

Ask your host to do it for you.
If you do a total backup, and try to import it it'll most likely fail due to it's size. Or you could manually go through bit by bit importing it.

 

[sep]

You press line2 to put the inbound call on hold, then press line1 and speed dial the outbound number, then after you explain the situation to the outbound line, you press conference and introduce line1 to line2, then you press release to get yourself out of there.

 

[themoose]

Don't forget to carry the 1 or you could miss out an entire financial season.

 

[DavidsAwesome]

The best bet is to consult your current host, and ask them. They'll take care of it for you.

 

[gibbs_h]

Not sure if this will help you help you you can gzipp entire database through phpMyAdmin and just restore it back at new location.

 

[GlennBeforeTime]

Not sure if this will help you help you you can gzipp entire database through phpMyAdmin and just restore it back at new location.

Nah, that'd be a little hard due to the filesize restrictions in phpMyAdmin.

I suggest using PHP to FTP a backup of the database to the new server, then execute that database backup using exec in PHP. This way it uses the server's backend which is faster, as it doesn't need to keep sending information to you.

Makes it easier, since you don't really want to download then upload the file again.

It's a little tricky but well worth it.

 

[stard]

I would recommend just backing up via cpanel and moving using wget to new server and restore there. However sometimes mysql is too big for this. If it is do all of the above but then use these commands

BACKUP : mysqldump -u username -p databasename > databasename.sql

wget <link to db>

RESTORE : mysql -u username -p databasename < databasename.sql

Hope this helps!

 

[Diana29]

for this situation best solution can be provided by ur host provider.


but u must have ur backup saved.

 

[vpsgod]

Ask your host to run this command from SSH

mysql -u yourdbusername -pyourdbuserspassword databasename < /home/yourusername/sql.sql