Import Articles from my local database to live database

Hi,

I want to import articles from local database to live server. I have posted many articles against many categories in my local database.
Now, i want to import those articles with import all database.

Kindly, Tell me method how can i import those articles?

Thxn

I presume you mean resources. Do they have TVs?

If it's just resources, go to your database and export the site_content table, then import that .sql into your live database.

If you have TVs, the values will be stored in the site_tmplvar_contentvalues table. The problem here will be if you have also been adding resources to the live site. Then you will need to export the site_content table without the auto-increment field (id), and let it automatically add those 'id' values. Now the resource ids will not be the same, and the tmplvar_contentvalues content_id field will not be accurate.

The main problem is, when i working on local server i modified different TV, Chunks, Snippets etc, mean i have modified my database. Because all these saved in database. On live server my client uploaded many article and now they want to back them cause i have uploaded local database file on live server and their all article has lost. I have backup of live server copy. Now i want to extract all articles from that file to live server. I need just article and their content.

That's my problem,

regard

Well, you have a big problem.

All I can suggest is that you restore the live database. Then you will have to go through your changes one at a time and make the same changes on the live site.

Keeping a development and a live site synchronized is not a simple matter.