Strange backup problem...

[samplist]

CMSMS 1.02
Linux
PHP 4.4.1
Mysql 5.0.15
Modules: (just)Externaliser

I'm having a strange problem, when i restore my db after a full backup: The news section in the admin area apears to be ok
(with all the articles-categories inside), but news articles do not apear on the frontend.
Of course they worked ok before the backup. I  tried edit them, but that didn't change anything.
I added new articles and they show up in the frontend!!! Now the new articles apear in the frontend but th old ones don't!

Here is the procedure i'm following to take and restore my backup.
Backup:
-Clear Cache (from admin panel)
-Turn externaliser off (from admin panel)
-mysqldump -u root -p mysite > mysite.txt
-Copy the mysite directory.
-drop database mysite

Restore:
-create database mysite
-mysql -u root -p mysite < mysite.txt
-Copy the mysite directory back
-Clear cache (from admin panel)
-turn externaliser back on

Has anyone experienced the same problem?

[tsw]

if you check the news tables is there anything different with restored items and new items.

cant really see how this would happen...

[mahjong]

news articles do not apear on the frontend

Seems to happen when you restore or export the database with the wrong charset or if you tranfer the data onto another Mysql server version. The expiration date of news article are reset to null. One way of preventing this problem is to specify explicitly the charset when dumping the database. Try :

Code: Select all

when saving : 
mysqldump -u root -p --default-character-set=latin1 --compatible=mysql40 mysite > mysite.sql

when restoring :
mysql -u root -p --default-character-set=latin1 mysite < mysite.sql

By the way, you can use msqldump from within the admin panel if you install the Mysql Dump module.