Hi, i have made a back up of a MySQL database via phpmyadmin, and wish to transfer the data across to a different database on a different server.... i know how to back up the data, but dont have a clue on how to import it back into phpmyadmin running on a different server... :wacko:
I am doing this because the server which holds my database seems to be down at the moment and i wish to continue to run my site (as it relies heavily on the mysql databse), and have a spare database (in the same name) at a different host....would i be able to restore (import) the .mysql file to the second databse?
Thanks, any help would be much aprreciated (and if you need any more info i try my best to explain) :)
Question
WnXP2002
Hi, i have made a back up of a MySQL database via phpmyadmin, and wish to transfer the data across to a different database on a different server.... i know how to back up the data, but dont have a clue on how to import it back into phpmyadmin running on a different server... :wacko:
I am doing this because the server which holds my database seems to be down at the moment and i wish to continue to run my site (as it relies heavily on the mysql databse), and have a spare database (in the same name) at a different host....would i be able to restore (import) the .mysql file to the second databse?
Thanks, any help would be much aprreciated (and if you need any more info i try my best to explain) :)
WnXP2002
Link to comment
Share on other sites
4 answers to this question
Recommended Posts