Moving Servers

[technom8t]

Ok, So katz got a problem with connecting to my server so i am moving, what i want to know is on my new server do i set up a database the same name as my current one then import my backup from my current server and upload files to the correct directories, or do i just import the database into the new server and that should work? or are these both wrong LOL ( never moved servers before)

technom8t Reviewed by technom8t on 30th Oct 2008. Moving Servers Ok, So katz got a problem with connecting to my server so i am moving, what i want to know is on my new server do i set up a database the same name as my current one then import my backup from my current server and upload files to the correct directories, or do i just import the database into the new server and that should work? or are these both wrong LOL ( never moved servers before) Rating: 5

[adi]

Easy way is to name it the same as before, and both ways will work as long as your configuration is pointing to the correct database

[Seifer]

* Backup your Database / Directory
* Download the Database / Directory
* On New host, create mysql database using Cpanel with the same name as previous host
* Create user with same name and password and then add the user to the database
* Either use Phpmyadmin to restore the database or else you can use SSH (More complicated)

That should be all

[donbiz]

I think its easiest just to backup the database through SSH then went your on new server create the database then restore the old database through SSH.

Always seemed to be the easiest way to me anyways

[Seifer]

I think its easiest just to backup the database through SSH then went your on new server create the database then restore the old database through SSH.

Always seemed to be the easiest way to me anyways

Yeah it's easier actually but for technom8t, I guess it will be easier to use phpmyadmin since he is not quite used with those things ...

yeah but if the database is too large, I would also advise using ssh .. there's a guide on katzblog if you need help

[technom8t]

ok so what i did for anyone that wishes to do the same LOL

backed up my database via mt adminCP then i created a blank database on my my server, i imported my backup into that database via myphpadmin, i uploaded all my site files and then changed my config file to the corect details for my new database i created ( icould not name the new databse the same as my backup, as it wouldnt allow me too, it wanted to add the begining of my domain with an underscre and then the name of the database , as the database name)

thanks to everyone for there help