Go into Cpanel and and then phpmyadmin
- you will next get the welcome screen, click on "export"
- Next you will get a "view dump" (schema) showing you the database (s)
- Choose the database you wish to transfer and then select SQL
- Hit "go", you will then get a load of text, copy all this text and paste it into a notepad file (or word) and save it on your computer as a .txt file
You now have a copy of your database on your pc, structure and all it's data.
UPLOADING THE DATABASE TO NEW HOST
- Same process, go to cpanel and then phpmyadmin
- Hit "query window" on the left, in this new window paste the entire contents of the database file (the text you copied and pasted before) into this window
- Hit "go"
You ahve now successfully transferred your entire database and it's contents.
- you will next get the welcome screen, click on "export"
- Next you will get a "view dump" (schema) showing you the database (s)
- Choose the database you wish to transfer and then select SQL
- Hit "go", you will then get a load of text, copy all this text and paste it into a notepad file (or word) and save it on your computer as a .txt file
You now have a copy of your database on your pc, structure and all it's data.
UPLOADING THE DATABASE TO NEW HOST
- Same process, go to cpanel and then phpmyadmin
- Hit "query window" on the left, in this new window paste the entire contents of the database file (the text you copied and pasted before) into this window
- Hit "go"
You ahve now successfully transferred your entire database and it's contents.
Comment