Hi there. I have a data issue that I hope someone can help me with:
I have a .SQL dump from an instance of the Mediawiki DB (newest version) that I'm trying to restore to a new instance.
However, even after importing/replacing all existing data, the front page still shows the new installation page, link structure, etc.
Does Mediawiki cache data somewhere that I need to purge? What's going on here? When I view the database after the import with phpMyAdmin, I can see the data in the text indices and whatnot so I know the data was actually imported..
I tried running the rebuildAll.php script in the /maintenance folder but that didn't do anything.
Any assistance provided would be appreciated.
Regards, Will
Have you replaced/created the localsetting.php file and deleted the config folder?
Arthur arthur@assys.net -----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of William Stiern Sent: 07 August 2006 17:37 To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] MediaWiki Help -> Database!
Hi there. I have a data issue that I hope someone can help me with:
I have a .SQL dump from an instance of the Mediawiki DB (newest version) that I'm trying to restore to a new instance.
However, even after importing/replacing all existing data, the front page still shows the new installation page, link structure, etc.
Does Mediawiki cache data somewhere that I need to purge? What's going on here? When I view the database after the import with phpMyAdmin, I can see the data in the text indices and whatnot so I know the data was actually imported..
I tried running the rebuildAll.php script in the /maintenance folder but that didn't do anything.
Any assistance provided would be appreciated.
Regards, Will _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Thanks for your input, Arthur.
I created the new instance of Mediawiki with the exact same details as the previous instance, so the LocalSettings.php doesn't need to be changed. Same DB name, user, etc. All I did was install Mediawiki and use phpMyAdmin to import/replace the previous data over the default data.
I've also tried moving the MySQL \data files over and it still doesn't seem to think there's any data in the database. Still seems like a caching issue of some sort to me.
Regards, Will
On 8/7/06, Arthur Guy Arthur@assys.net wrote:
Have you replaced/created the localsetting.php file and deleted the config folder?
Arthur arthur@assys.net -----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of William Stiern Sent: 07 August 2006 17:37 To: mediawiki-l@Wikimedia.org Subject: [Mediawiki-l] MediaWiki Help -> Database!
Hi there. I have a data issue that I hope someone can help me with:
I have a .SQL dump from an instance of the Mediawiki DB (newest version) that I'm trying to restore to a new instance.
However, even after importing/replacing all existing data, the front page still shows the new installation page, link structure, etc.
Does Mediawiki cache data somewhere that I need to purge? What's going on here? When I view the database after the import with phpMyAdmin, I can see the data in the text indices and whatnot so I know the data was actually imported..
I tried running the rebuildAll.php script in the /maintenance folder but that didn't do anything.
Any assistance provided would be appreciated.
Regards, Will _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
What exact screen do you get when you go to your wiki, a blank front page, the setup page or something else?
When you say you created a new instance of Mediawiki what exactly did you do?
Do you have a URL we can look at?
Arthur arthur@assys.net
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of William Stiern Sent: 07 August 2006 18:16 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] MediaWiki Help -> Database!
Thanks for your input, Arthur.
I created the new instance of Mediawiki with the exact same details as the previous instance, so the LocalSettings.php doesn't need to be changed. Same DB name, user, etc. All I did was install Mediawiki and use phpMyAdmin to import/replace the previous data over the default data.
I've also tried moving the MySQL \data files over and it still doesn't seem to think there's any data in the database. Still seems like a caching issue of some sort to me.
Regards, Will
I see the standard-issue "Mediawiki has been installed" page.
New instance: Copy over the code files, run the installation script creating new DB and whatnot. Import DB contents from previous database via a .SQL dump file.
I don't have a public URL, unfortunately. This wiki is for internal employee use at my company.
Thanks for your ongoing support.
Regards, Will
On 8/7/06, Arthur Guy Arthur@assys.net wrote:
What exact screen do you get when you go to your wiki, a blank front page, the setup page or something else?
When you say you created a new instance of Mediawiki what exactly did you do?
Do you have a URL we can look at?
Arthur arthur@assys.net
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of William Stiern Sent: 07 August 2006 18:16 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] MediaWiki Help -> Database!
Thanks for your input, Arthur.
I created the new instance of Mediawiki with the exact same details as the previous instance, so the LocalSettings.php doesn't need to be changed. Same DB name, user, etc. All I did was install Mediawiki and use phpMyAdmin to import/replace the previous data over the default data.
I've also tried moving the MySQL \data files over and it still doesn't seem to think there's any data in the database. Still seems like a caching issue of some sort to me.
Regards, Will
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Are you upgrading versions or is it the same?
This question has been posted several times before to this mailing list but unfortunately I can't remember what the solution was. Someone else on the ML probably remembers what the solution was.
Arthur arthur@assys.net
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of William Stiern Sent: 07 August 2006 19:42 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] MediaWiki Help -> Database!
I see the standard-issue "Mediawiki has been installed" page.
New instance: Copy over the code files, run the installation script creating new DB and whatnot. Import DB contents from previous database via a .SQL dump file.
I don't have a public URL, unfortunately. This wiki is for internal employee
I started with MySQL version 5.0.22, but upgraded to 5.0.24 due to some issues with another PHP application I'm running. This involved deleting the service, uninstalling MySQL, deleting the Program Files folder, and installing the new version. This is basically what started the whole recovery process, having to upgrade MySQL.
Mediawiki versions are the same.
Regards, Will
On 8/7/06, Arthur Guy Arthur@assys.net wrote:
Are you upgrading versions or is it the same?
This question has been posted several times before to this mailing list but unfortunately I can't remember what the solution was. Someone else on the ML probably remembers what the solution was.
Arthur arthur@assys.net
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of William Stiern Sent: 07 August 2006 19:42 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] MediaWiki Help -> Database!
I see the standard-issue "Mediawiki has been installed" page.
New instance: Copy over the code files, run the installation script creating new DB and whatnot. Import DB contents from previous database via a .SQL dump file.
I don't have a public URL, unfortunately. This wiki is for internal employee _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
Any more suggestions on this topic? I'd really like to be able to recover the data from these files.
Does anyone have any tips on perhaps extracting the data from the CLOB fields in the database? That would work just as well.
Regards, Will
On 8/7/06, William Stiern wstiern@gmail.com wrote:
I started with MySQL version 5.0.22, but upgraded to 5.0.24 due to some issues with another PHP application I'm running. This involved deleting the service, uninstalling MySQL, deleting the Program Files folder, and installing the new version. This is basically what started the whole recovery process, having to upgrade MySQL.
Mediawiki versions are the same.
Regards, Will
On 8/7/06, Arthur Guy Arthur@assys.net wrote:
Are you upgrading versions or is it the same?
This question has been posted several times before to this mailing list but unfortunately I can't remember what the solution was. Someone else on the ML probably remembers what the solution was.
Arthur arthur@assys.net
-----Original Message----- From: mediawiki-l-bounces@Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of William Stiern Sent: 07 August 2006 19:42 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] MediaWiki Help -> Database!
I see the standard-issue "Mediawiki has been installed" page.
New instance: Copy over the code files, run the installation script creating new DB and whatnot. Import DB contents from previous database via a .SQL dump file.
I don't have a public URL, unfortunately. This wiki is for internal employee _______________________________________________ MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org