Exporting Blog from Database so I can delete entire database, & start from scratch & then reimport the blog.
Permalink
Hi guys, I'm having terrible trouble with a website I deid for a client. The CoreCommerce function is not working properly, it doesn't record the orders so I want to delete the entire DB, site, everything & start again. (problems started when I upgraded from 5.3 - 5.4)
My only concern is that the client is quite a regular blogger & I want to export the blog from the current DB, keep it safe, do a new installation of 5.4 & build the site on this as when I do it this way everything seems to work. I'll then install the blog Add-On & import the stuff I exported through phpMyAdmin.
What I need to know is what do I export through phpMyAdmin, to do this right. I'm a designer more than a developer so can't "read" the database. If someone could give me a list of the cells on the table I need to export to be able to this, that would be great.
My only concern is that the client is quite a regular blogger & I want to export the blog from the current DB, keep it safe, do a new installation of 5.4 & build the site on this as when I do it this way everything seems to work. I'll then install the blog Add-On & import the stuff I exported through phpMyAdmin.
What I need to know is what do I export through phpMyAdmin, to do this right. I'm a designer more than a developer so can't "read" the database. If someone could give me a list of the cells on the table I need to export to be able to this, that would be great.
1) I would download the database as it is.
2) Do a fresh install with a new db.
3) Install all the modules again.
4) Download the new database.
5) Open both in BBEdit and find where the blog entries live. Grab them and paste them into the new db.
6) Save the db and upload with Sequel Pro.
I know very little about mysql and this may not work at all. Use a fresh db and just change your config/site.php file to your new db. then you can go back and forth between db's should the need arise.