Hi! I have a PHP Wiki install up and running on my hosting provider's server. I'm going to be moving to a new provider soon and want to bring my wiki along with me. So, I went into the MySQLAdmin and did a sql export of all the tables. What do I do when I move to the new provider? I'm thinking my steps are:
Create a PHPWiki on the new server Go into MySQLAdmin (or other appropriate DBMS tool) and do an import. While the DB name may be different, the table names and structures should be same (assuming similar versions of PHPWiki).
Has anyone had any success on this? Any advice on what to do for the export or import to work right? Any other steps I'm missing? Thanks!
Bobby
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi! I have a PHP Wiki install up and running on my hosting provider's server. I'm going to be moving to a new provider soon and want to bring my wiki along with me. So, I went into the MySQLAdmin and did a sql export of all the tables. What do I do when I move to the new provider? I'm thinking my steps are:
Create a PHPWiki on the new server
Go into MySQLAdmin (or other appropriate DBMS tool) and do an import. While the DB name may be different, the table names and structures should be same (assuming similar versions of PHPWiki).
Has anyone had any success on this? Any advice on what to do for the export or import to work right? Any other steps I'm missing? Thanks!
Bobby
This will only work if the new provider can provide the same database libraries (charset, ...)
The recommended way is to do a backup / restore as described in PhpWikiAdministration.
?action=zipdump => wikidb.zip
?action=loadfile&source=wikidb.zip