Hi. I've seen various threads in teh Content section of the BST where people have been selling WP databases packed with posts. I was just wondering how they go about getting the database onto a seperate file (off the hosting), then sending it. I was also wondering how you install a database. Thanks!
There are several ways of doing this but the way I would do it is create an SQL Dump. This is basically a set of SQL statements to create the database and then repopulate the data. While there are other ways, this one is the most portable, and easy to send around as once you have your dump just archive it up and since its text it will compress really well. Then to restore it all you need to do is run the SQL Dump file on your system (Depending on how it was done you may need to create the database first), and it will recreate all the tables and data. The MySQL tool I use (SQLyog) has the means to create and restore DB dumps really easily. Jen