Hi All,
I have made a backup from manager area : Tools -> BackUp -> Generate drop table statement -> choose all tables -> click at "Click Here" to backup ...
It works great. I can put it back to Mysql database without problem.
I have also make a backup via Mysql prompt :
mysqldump -u dbuser_name dbname -p > mybackup.sql
There is some text like this ... I don’t need it ...
-----------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *
/;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
-------------------------------------------
After I put this database (mybackup.sql) back , the double quote (") and some other characters changed to unreadable under Modx frontend. Something like this : “Halloâ€Â
So, What is the Mysql dump syntax as backup process used at manager area ?
Thanks.
- pedma -
