Copy Structure and data from one mySql database to a new one on a different hosting account.
Posted on 2006-11-27
I currently have a hosting account with GoDaddy. I installed one of their Value Applications call Coppermine photo album. They automatically created a mySql database (for this program) on a server where I can't access the actual database layout. I need to change and view some of the tables.
What I would like to do is extract all of the data (and structure) to a file, then I will setup a new database (that I CAN access) and I want to import this information.
I have the path, username and password for the database.
I've been reading here about mySqlDump. Is this the correct program to do this? And also I don't understand how to run it (I'm a begginer in web design and mySql).