Insert backup mySQL data into database

There are many people who are using WordPress.org as their blog platform and one of the most important thing they do at times in case of system crash is to backup their data. Most bloggers will be backing it up using the plugins from wordpress or do it semi-manually using the phpmyadmin that comes with most hosting.

Now the part comes, where do you put those data. Why not do a replica of it on to your database and run your own WordPress and play test it. Here’s how one can insert the text data back into a database with just few simple commands.

mysql -uUser -pPassword -hlocalhost dbName < data.ddl

Now that is what one ever need to do. Make sure before you do this though, that tables in the said database is drop from it.

Tags: mysql