I was trying to move a big database (around 60mB) to my DA server just now. Can't do it with phpmyadmin, so I tried out MySQL-Front as someone here recommended it. Saved it to my drive nicely, but I have problem putting it on my DA server.
Then I notice there is this new "Upload a backup file" feature, so I tried out saving my database from CPanel (as .gz), and upload via it. I am not so sure if it is because that my DB is too big (around 30mB in .gz), but it didn't work. It points me to a 404 page not found. And a refresh showed an error saying that I do not own the domain. A bug? Or just my DB?
So in the end, I just uploaded the .gz file to my DA server, then used MySQL to dump it. Tadah...
Not so sure if it would be useful to you guys, but I think downloading the .gz copy and uploading it back up to the server is better than doing it without compressing the DB? If you have a big pipe then maybe it doesn't really matter to you. And that by doing this way, you don't need to get any 3rd party program etc. Maybe it works for other control panels too if they allow you to download .gz copy of your database, but I have never used them thus I don't know.
Then I notice there is this new "Upload a backup file" feature, so I tried out saving my database from CPanel (as .gz), and upload via it. I am not so sure if it is because that my DB is too big (around 30mB in .gz), but it didn't work. It points me to a 404 page not found. And a refresh showed an error saying that I do not own the domain. A bug? Or just my DB?
So in the end, I just uploaded the .gz file to my DA server, then used MySQL to dump it. Tadah...
Not so sure if it would be useful to you guys, but I think downloading the .gz copy and uploading it back up to the server is better than doing it without compressing the DB? If you have a big pipe then maybe it doesn't really matter to you. And that by doing this way, you don't need to get any 3rd party program etc. Maybe it works for other control panels too if they allow you to download .gz copy of your database, but I have never used them thus I don't know.