How to migrate a database to a new phpmyfaq install?

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
leandrorius
Posts: 12
Joined: Tue Jul 17, 2012 3:24 pm

How to migrate a database to a new phpmyfaq install?

Post by leandrorius »

Hi there!

I've been using the phpmyfaq in a lab enviroment, and as a lab has to be, I messed up a lot of things trying to customize the interface... Anyway,despites being a lab I created a lot of good FAQs and Categories.
Now I did a clean install of the PHPMyFaq in a new server to get into production, and I'd like to import all the Faqs and categories from the lab database to the new install. Is this possible?
By the way, I can't use the phpmyfaq backup and restore utilities for some reasons, so I'm expecting a way using mysqldump or something.

Thanks!
Thorsten
Posts: 15725
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How to migrate a database to a new phpmyfaq install?

Post by Thorsten »

Hi,

I would recommend the following steps:

1. Install a fresh phpMyFAQ installation on the new server
2. Dump the complete database on your test server with mysqldump
3. Import the database dump on the new server
4. Adjust your database settings if needed in config/database.php

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply