English
Brasil
Dansk
Deutsch
Español
Français
Italiano
Magyar
Nederlands
Polski
Türkçe
Русский
简体中文Announcement
- [2013-04-19] Piwigo 2.5.1
- [2013-04-08] New server for Piwigo.org
- [2013-04-01] Piwigo and Zenphoto to join forces!
- [2013-03-04] Piwigo 2.5
- [2013-02-23] Piwigo 2.5.0RC2
- Forum Index
- » How-To and Troubleshooting
- » Move my Gallery Database to Another Database
Post a reply
Topic review (newest first)
- dalem
- 2012-03-26 12:10:41
Phpmyadmin is a software to connect to your databases and then to manipulate them. If you have hosting you must have some way to connect to your databases (it may not be phpmyadmin that your hosting uses but some other software), you need to ask your hosting company how to do it as it would be near impossible by forum.
Who are you hosted with and do you have cpanel?
- robertmohr
- 2012-03-26 03:43:59
What or how do I use "phpmyadmin"?
- pewe
- 2012-03-26 00:07:23
Configure another separate db for your piwigo installation and import your just backed up tables into it.
You can then point to this new database by changing the 'database.inc.php' file in the /local/config directory.
- dalem
- 2012-03-25 22:52:46
robertmohr wrote:
Thanks for the info.
One of the problems I ran into was I had Wordpress and my gallery on the same database. Now I want to backup the database and then move the gallery to it's own database so I don't run into the problem I had this weekend. I thought I lost 2 months worth of work. I got the database restored and everything is working but splitting Wordpress and Piwigo is my next main objective. I looked a DB Backup plug-in but it does seem to be a reliable, current plug-in. Do you have any ideas?
Thanks again
If you have access to your database it will be easy. Wordpress and Piwigo have completely different tables. I assume you can see your database with phpmyadmin or similar? Wordpress tables start with wp_xxxxxxxx and Piwigo tables piwigo_xxxxxxxx it should be an easy matter to backup the piwigo tables first and then delete all of the piwigo tables from your db.
Configure another separate db for your piwigo installation and import your just backed up tables into it.
- robertmohr
- 2012-03-25 22:01:15
Thanks for the info.
One of the problems I ran into was I had Wordpress and my gallery on the same database. Now I want to backup the database and then move the gallery to it's own database so I don't run into the problem I had this weekend. I thought I lost 2 months worth of work. I got the database restored and everything is working but splitting Wordpress and Piwigo is my next main objective. I looked a DB Backup plug-in but it does seem to be a reliable, current plug-in. Do you have any ideas?
Thanks again
- pewe
- 2012-03-25 13:29:43
I am no pro, but I seem to remember that the config file written when I recently installed was located in the - /local/config - sub directory in the gallery directory on the server.
The file was called 'database.inc.php'.
I just looked on my installation and that does contain all the relevant database details.
I don't think there is an admin function to change it.
- robertmohr
- 2012-03-25 12:04:49
I'm having my Hosting company do a full database restore to a previous date. Unfortunately piwigo is in a database with my Wordpress blog. I assume there is a way to move my piwigo gallery to another database once the restore is complete. I have waiting a database that I want to move my gallery to so I don't have this cross over issue again. A stupid mistake on my part.
Where in the piwigo setup is the database name and password updated?
Can it be done through and admin log in point or do I have to edit a php file?
Thanks for your help