Help with wordpress blog?
meetarnav asked:
I am a newbie.
I created a wordpress blog.
AFTER creating the blog I downloaded wordpress and installed it on my machine using XAMpp. After logging into wordpress from localhost, wordpress started a new HELLO WORLD blog for me. Now I want to IMPORT/BACKUP all my data online ONTO my machine, so that I can edit it OFFLINE and later UPLOAD IT.
I have seen many tutorials on the net but they just seem so complex.
Please tell me
HOW TO MIRROR MY ONLINE BLOG ONTO MY MACHINE
and HOW TO UPLOAD NEWER POSTS WHICH I HAVE CREATED OFFLINE. Is there a tool that can AUTOMATICALLY synchronise the DB on my machine with that on wordpress… Plessssssssseeeeeee help…
| Digg |
Stumble
|
Sphinn |
Del.icio.us
|
I believe, YES, there is a tool. Although I am not familiar with any, I bet you can do a search for db sync and find $100’s and probably spend hundreds.
What I would do, is:
First, export your online database to SQL file. Then import the SQL file to local DB.
Then… have your local site use the online DB instead of the local db, if this is an option.
If you can’t do that, then… your only option is to keep exporting/importing the SQL data and you wouldn’t be able to update both and then sync, you’d lose data from one or the other.
I use SqlYog for my db operations.