From: Reini U. <ru...@x-...> - 2004-07-13 10:40:46
|
Le Roux van Wyk schrieb: > I have recently moved from Redhat to Debian and therefore had to > reinstall phpwiki. I didn't see the phpwiki backup facility, and just > exported the mysql tables to .sql and copied the entire phpwiki > directory over to the new machine. Now that I try to import the sql > files into the database, I get incomplete data. Will the phpwiki allow > this type of "copy"? Why is the data incomplete? > I used mysqlfront to export the data originally, and have never > before had problems with data being incompletely exported. > Can anybody shed some light on the subject? probably errors with incorrect quoting or unsupported charsets. please try phpmyadmin (for the stupid) or mysqldump and mysql (for the brave). mysqldump --opt phpwiki > phpwiki.sql scp phpwiki.sql newmachine: ssh newmachine mysql phpwiki < phpwiki.sql -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban/ |