Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

So picture a regular Hostgator or similar account: everything done through Cpanel, a normal shared hosting website. There are static pages on the site, as well as an application (say Wordpress for instance) that relies on a mysql database.

Is there a way to move that website to a different host while keeping the same mysql users, and thus not breaking the application?

I mean, I can move the files via FTP, I can backup the database using phpMyAdmin and restore to the other server, but if it's assumed that I don't have access to whatever the original mysql user's password is, how can I switch hosts without breaking the application?

All the best!

share|improve this question

2 Answers 2

up vote 3 down vote accepted

User ACLs are stored in a database called 'mysql'. As long as you backup that db and the versions of mysql on both hosts are reasonably similar, you should be fine.

share|improve this answer
    
Fantastic, thank you very much! –  geodave Dec 5 '10 at 21:42

If you use the Backup Wizard in cPanel, you can select Full Website Backup and send this backup file (which contains files, email accounts, MySQL users, databases etc.) to your new hosting provider who can then restore this backup onto their server. This will avoid MySQL users being lost and your account settings will remain intact.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.