Hi there, I am looking at downloading a MySQL database through cPanel and then uploading it onto a new host, but how do I do this? To download them I have been using phpMyAdmin, and when I try to import them on my new hosting, it just doesn't work? The reason why I want to back them up and upload them elsewhere is because I am using a script which has members and I want to keep all them members, but still switch hosts. If someone could help me I would be ever so grateful. Thank you in advance. Regards, Kieran Taylor.
you can use phpscript for create backup like : phpmybackuppro . http://www.phpmybackuppro.net/ and you can download mysql backup form cpanel/backup page and upload it again . but for import it you should contact admin of server for import it via SSH .
did you try cpanel backup then cpanel restore on new host ? if that doesnt work might be your mysql db is too big, might have to break it up into sections and upload it.
Hi there, I keep getting the following error: And when I try to upload them as SQL I get this error; Would anyone be able to do it for me as a small gesture, they are only 3 small databases. Regards, Kieran Taylor.
#1044 - Access denied for user 'lisa1'@'localhost' to database 'lisa1_auction' you should add privilages for user lisa1 on DB : lisa1_auction form cpanel->Mysql Database