Looking for Something? Search Afriwap now!!!
Add to Flipboard Magazine. | |

HOW TO MOVE MYSQL DATABASE FOR LOCALHOST TO ONLINE HOST (DATABASE MOVEMENT)

Author Topic: HOW TO MOVE MYSQL DATABASE FOR LOCALHOST TO ONLINE HOST (DATABASE MOVEMENT)  (Read 1001 times)

0 Members and 1 Guest are viewing this topic.

Offline Timi Dapsin

  • Administrator
  • Hero Member
  • *****
  • Posts: 2,503
  • Today is that tomorrow you worried about yesterday
    • View Profile


Hi all,

Today am going to show you all on how to move databases from your localhost to your online host or from one host to another, just the same thing....i don't have much time now, let me just cut it short

  • Launch your localhost and click on the database you want to move am using test to test this tutorial
  •   I created a table named testing2, now not clicking on the table...i want to export the database, all i have to do is click on export
  • Now the next page you'll see is Exporting tables in database name, then click on go and download the .sql file
  • Now we all know that we have PHPMyAdmin in your Cpanel too, login to it and create a database, click on the database to open (Am using test to restore the database)
  • Click on import
  • Browse out where you saved the .sql file and upload, then click go
Congratulations! your database has been imported...that all! :)
THE SAME THING IS APPLICABLE IN MOVING MYSQL DATABASE FROM ONE HOST TO ANOTHER





 


Other Topics To Read

Powered by EzPortal