How To Drop And Replace MySQL Database

UPDATE: With the latest tools, you no longer need to follow the arduous steps discussed in this post. All blog pacakge comes with a premium plugin that makes the installation quick and easy. You only need to create a MySQL database and then upload the blog installation files to your webhost.

No more messing with codes, SQL file, and myPHPadmin.

 

Step by Step Tutorial

  1. Go to phpMyAdmin under Databases on your cpanel.
    php myadmin
  2. Click the phpMyAdmin link. A new window will open. On the left side locate the name of your MySQL database.
    locate database name
    NOTE
    : If in case you don’t know the name of your MySQL database because you automatically installed WordPress using Fantastico or QuickInstall, you can locate your database name including username and password using your CPanel. Read the tutorial on “How To Locate Your Database Name and Username“.
  3. Click your database name. In this example, I click the _weht725 link. You should see some scary stuff like the one below:
    php myadmin database
  4. Click the Check All button just below the list of tables (see illustration above). Click the With Selected: button then choose Drop (as shown below).
    drop mysql
  5. Check YES button (found on the far right) if you are prompted with something like, “Do you really want to: |”.
    girl i really want you
  6. Upon successful dropping you should see the message, “Your SQL query has been executed successfully“. Notice also that your database tables (left side) goes to zero value.
    successful MySQL drop
  7. Now click the SQL tab. You should now see a blank space. This is where you should paste the SQL file of your newly downloaded niche blog. The SQL file is actually the database files and this is where all your blog settings and articles are stored.
    sql insert
  8. Open the SQL file you edited in STEP 5. Select all (use Ctrl + A on your keyboard) then right click your mouse and press copy (or use CTRL + C).
    copy sql
  9. Paste it on the blank SQL query then click the GO button.
    sql go
  10. Success! Welcome to the GEEK world!
    success sql replace
  11. If you’ve been following the step by step installation of your premade blog packages, you can now view your newly installed niche blog by typing your url on your browser. In this demo my url is:¬†http://www.biabranding.com/weightloss/