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.

Watch Video

Step by Step Tutorial

1Go to phpMyAdmin under Databases on your cpanel.

php myadmin

2Click 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“.

3Click your database name. In this example, I click the _weht725 link. You should see some scary stuff like the one below:

php myadmin database

4Click 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

5Check YES button (found on the far right) if you are prompted with something like, “Do you really want to: |”.

girl i really want you

6Upon 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

7Now 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

8Open 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

9Paste it on the blank SQL query then click the GO button.

sql go

10Success! Welcome to the GEEK world!

success sql replace

11If 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: