Can i easily change hosting with this script?

Question

Presently i am using shared hosting, suppose if my community grows and my db become larger like millions of post and millions of user then i need to change my hosting from shared to dedicated, so i want to know that is this possible with this script to transfer my all files and db to another hosting easily without loosing any data?

Answer 1

I don't see why not. It's just a simple MySQL db. You can easily export the db on the original host and import it on the new host.

Or you could use a VPS host that allows you to add 'units' on-the-fly without changing servers.

Answer 2

To export you database use:

`mysqldump -u YourDBUser -p YourDBName > q2a.sql`

If I were you, I would also copy the q2a directory (probably in /var/www/html if your are on linux system) to keep the same version between your data and your q2a application.