migrate 5.4.0 to new server

[thomaswhiteeagl]

I'm sure this has been answered somewhere but I searched the forums using all the suspect keywords and phrases and really found nothing on this providing any instructions.
I need to move my directory from one server to another. Can someone provide me with instructions on how to best do this. Should i simply make a copy of the database from within phpmyadmin, copy the old files, transfer servers, reinstall indexu from an original install, then copy over the files with the backup and reload the database or??

[FSGDAG]

Are you using the same Web Host Control Panel? Example : Are both cPanel?

If they are both cPanel, and you have root access, just a cpmove file on the old server and then restore it on the new server. Example :

1 - From old server :

# /scripts/pkgacct <account_name>

2 - When cpmove file is finished being created, FTP it to the new server

3 - From the new server:

# /scripts/restorepkg <account_name>

4 - Just change your name servers at your registrar and your ready to go

If you dont have root access, and again your using cPanel, create a full backup from within cPanel. Copy that full backup to your new server and unpack it in a temp directory. Once its unpacked, create a MySQL DB and import the backup that was made. Then copy all the IndexU files to /public_html/. Now edit /public_html/application.php and ensure all the information in there is correct. Lastly login to your client area and reset your key. That should be it.

Hope that helps!

[thomaswhiteeagl]

Thanks for the info but no I am moving form a server with plesk to a server with cpanel.

[FSGDAG]

Thats great that your moving away from Plesk to cPanel, but it sucks you were on Plesk to begin with!

The best advice I can give you is, zip up / tar up all of your IndexU files. Move them to the new cPanel account and then unpack them. Backup your MySQL on the Plesk server and then create a new DB in cPanel and import the MySQL file you had from Plesk. Then edit application.php to reflect all your new values. Your path, DB names, etc will all need to be modified. After that, you should be good

[thomaswhiteeagl]

Yeah well when I started that server years ago we didn't know better. Live and learn. Now I am in the process of shutting it down and my own toys are the last to go.
Anyways, sounds pretty straightforward to move so hopefully that's how it will work.
Any particular advice regarding when I save the database in phpmyadmin as far as structure and data?

[FSGDAG]

It really depends on how big your DB is... If its larger than 2 to 3 megs, than it will be almost impossible to import it in through phpMyAdmin. Does your new host / server allow for SSH? You could atleast then import it to MySQL through SSH

As far as what type of file to create for the backup through phpMyAdmin, I would just use an SQL file. You really cant go wrong that way

[Bruceper]

whoa hold on there, it's totally possible to import large mysql files into phpmyadmin.

phpmyadmin now (I don't know when it started) has the ability to remember which line a mysql import ended at, so it can resume the import.

So to move your site over all you really need to do is either FXP (or download/upload) the php/html files from the old host to the new one. Then upload your database. Then you'll need to edit application.php to set your variables such as database username/password etc.

After that, follow the directions in the install manual for setting up proper file permissions.

[FSGDAG]

whoa hold on there, it's totally possible to import large mysql files into phpmyadmin.

Not that I've been following all the updates to phpMyAdmin, but that has to be new. The last time I tried to import a DB through phpMyAdmin that was larger than 3 megs, it choked.

Well, you learn something new every day and this is something good to know

[Bruceper]

I suppose it also depends which cpanel trunk you're on. If you're on STABLE then you might only have gotten this update recently. If you're on EDGE you might have gotten it over a year or two ago.

[FSGDAG]

I only use STABLE on my production servers. Dont want to take a chance with my own sites, let alone my clients sites, of getting buggy versions