Wordpress Question - MySQL

I have a huge blog of tutorials. But how do I export the database in order for me to sell it and other people import it into their blogs?

 

Just backup your MySQL database from PHPMyAdmin. Or backup directly from your cPanel. Both MySQL and Home Directory.

 

But wouldn't all the tables be set to my site? They would have to go through everything changing all the settings. Or is that the only way to do it?

 

Look, when you get a backup from your database everything will be there. Posts, Comments, Links, and everything. All other things regarding theme or pictures are in your home directory files. So you with both ( MySQL and Home Directory) you can move your website everywhere without any problem. I did it several times.

 

ok, thanks for your help.

 

If you're exporting your content to give to others to use on their sites, there a couple more things to consider..

If you export from PHPMyAdmin, you'll basically end up with a text file that includes sql statements to create the tables and input the data. You might want to look at other exporting options to rather export data from tables as a csv file, which might be more workable for some webmasters.

Also, make sure you don't export or give away any data from your users tables or any other tables that might contain sensitive data that is important to your site only... you don't want those that obtain your content from you to also obtain your site login information, for example

 

That is what I was worried about in exporting the whole database.

 

Is it also advisable to export MySQL from cPanel's "Backup" Tool? I haven't tried saving file from phpMyAdmin.

 

cPanel backs up all of the databases though. I prefer to use phpMyAdmin so I can select what to export.