location of database/backup
|
CherylJoyW
Joined: 2012-08-19
Posts: 42 |
Posted: Sun, 2012-08-19 16:13
|
|
I am at a loss However I cannot locate the database. Gallery version = 2.1.2 core 1.1.0.2 I have no way in Gallery admin to back up the gallery. I have been looking for an export module and if there is a way to do this I would appreciate it. Links if I have missed something too would be appreciated. thank you in advance |
|
Posts: 8339
You have a very old version of gallery.
You won't be able to import into G3 unless you upgrade to the latest G2 version anyways.
The preferred method of upgrading from such an old version:
2.1.2 -> 2.2.6 -> 2.3.2
And then you should be able to import into G3.
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
That is my problem I do not know. I was hosted with GoDaddy at the time. I downloaded and installed 2.1.1 from the gallery website per instructions. ftp the files over to the server and then from the browser install. Cannot remember the exact instructions right now.
I always assumed the database I was setting up was with GoDaddy.
I have another site with the same problem.
I have no idea where this is. 'hostname'] = '10.0.11.146'; the other site's host is 10.0.11.110
They are both artists extensive portfolios.
This is a copy of the config file.
$storeConfig['type'] = 'mysqlt';
$storeConfig['hostname'] = '10.0.11.146';
$storeConfig['database'] = 'user_526559';
$storeConfig['username'] = '526559_ChuckandM';
$storeConfig['password'] = '2f9e13cf113e70a';
$storeConfig['tablePrefix'] = 'g2_';
$storeConfig['columnPrefix'] = 'g_';
$storeConfig['usePersistentConnections'] = false;
$gallery->setConfig('storage.config', $storeConfig);
Any help would be greatly appreciated.
Posts: 42
Yes, I do...
Not knowing the location of the database to back up the info is the main problem.
If there is a work around I would love to hear it.
My one thought was to download 2.3 to another directory(copy over the existing files I have and use the config file from 2.1 and pull in the info from the data base. Then keep upgrading that one until 2.3. Hopefully by 2.3 I can export the database.
I was hoping this could be done without disturbing the original one there now. I am sure there would be problems with the location of the images but this is just thinking out loud.
Again I am in a real bind and any help would be greatly appreciated.
Posts: 8339
Your host should give you database tools to export the database tables. Usually through a tool called phpMyAdmin or similar
If you're on GoBadly then they use cPanel and phpMyAdmin.
10.0.11.146 or 10.0.11.110 are just IP addresses to the database server(s).
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
THANK YOU...
Here is what happened I installed gallery when GoDaddy did not let us have access to the server. With your comments I was able to convince GoDaddy it was on their servers, and they located Them
However they have to back up the database as i cannot get access to them. they will put the backups in the hosting account.
I will need links to help after this is done.
How do I get from 2.1 to 3
Install 3 into a new directory? create a new database on GoDaddy and import the backed up database.
Problems do this????
You are all life savers.
thank you again
Posts: 8339
there is a huge link to documentation in the upper right corner on every page of this site.
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
thank you for the help.
I have 2 Gallery installations in the same bind. both similar using Carbon Theme which I customized.
this is a link to the smaller of the 2
http://www.lear-mahoney.com/gallery/main.php
I have read some of the FAQ and some of the documentation, but not all, and would like advise.
I need to get the data base to where I can handle it (the interface location that GoDaddy has for me on the site.) and then upgrade the gallery to G3 per your steps.
I have the backed up database file from GoDaddy.
This database was backed up with the rewrite URL module installed.
I am assuming these paths are stored in the database.
To try and protect what is working so I do not loose anything in the process I would like to plan on doing this.
Put he gallery into Maintenance Mode.
Uninstall the rewrite URL Module....
1. Copy the current Gallery installation to another folder - that way I will have another copy.
2. Create a new database through the current GoDaddy interface, trying to keep the same names to match the current config.php. If I cannot do this, edit the config to match new database. Import the database into this new one.
3. Replace the Config.php with the new one.
Once connected.. start to upgrade Gallery.
then reinstall the rewrite URL Module
Will this work?
Posts: 8339
I believe GoBadly uses cPanel
http://www.youtube.com/watch?v=ifPJzlqq1rQ
Backup your whole gallery2 directory
backup your whole g2data directory
backup your DB via cpanel -> databases -> phpMyAdmin as per the video I linked above
backing up the g2data can be quicker/smaller if you clear gallery's caches first gallery admin -> maintenance -> clear caches
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
Thank you for the help.
One gallery updated smoothly and will be putting into 3 later today.
2nd gallery started and ran into this error message. What does it mean and what should I be looking for.
2.1 to 2.2 upgrade
Notice: Use of undefined constant GALLERY_FORM_VARIABLE_PREFIX - assumed 'GALLERY_FORM_VARIABLE_PREFIX' in /home/content/C/h/u/ChuckandMarie/html/gallery/modules/core/classes/GalleryUtilities.class on line 242
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/C/h/u/ChuckandMarie/html/gallery/modules/core/classes/GalleryUtilities.class:242) in /home/content/C/h/u/ChuckandMarie/html/gallery/lib/support/GallerySetupUtilities.class on line 75
Will be able to give more info when I get the gallery up and running again. Did back up but not on server...so transferring those files now
Thank you in advance
Posts: 42
OK gallery back up and this is the data
Gallery version = 2.1.2 core 1.1.0.2
PHP version = 4.3.11 cgi-fcgi
Webserver = Apache
Database = mysql 4.0.27-max-log, lock.system=flock
Toolkits = Gd
Acceleration = none, none
Operating system = Linux linhost207.mesa1.secureserver.net 2.4.21-27.ELsmp #1 SMP Wed Dec 1 21:59:02 EST 2004 i686
Default theme = carbon
Locale = en_US
Browser = Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; SV1; .NET CLR 1.1.4322; InfoPath.1)
Posts: 8339
when you go to upgrade, make sure you are replacing the entire /gallery2/ with a comparable set from the next version.
it also helps to uninstall rewrite or any non critical modules.
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
Will do re modules. Just Double checked the files and for some reason bootstrap.inc did not copy over.
I have started to reload everything..
I appreciate your response.
Posts: 42
I am presently trying to restore Gal 2.3
2 things...
I installed Gallery 3 through the godaddy interface...
noticed this at the top of the config file
<?php defined("SYSPATH") or die("No direct script access.");
Looking for advice on what to do.
The import to 3 seemed to go smoothly. I then went to change the theme however received error messages re page not found
--------------------------------------------------------------------
Attaching Var log...
Kohana_404_Exception [ Page Not Found ]:
The page you requested, g2/map?path=g2/map&path=g2/map&path=g2/map&path=g2/map&path=g2/map&path=g2/map&path=g2/map&path=g2/map&path=g2/map&path=g2/map&path=admin/themes, could not be found.
Host name: linhost264.prod.mesa1.secureserver.net
Operating system: Linux 2.6.18-238.19.1.el5PAE
Apache: Unknown
PHP: 5.2.17
MySQL: 5.0.92-log
Server load: 4.19 4.63 4.77
Graphics toolkit: imagemagick
Gallery stats
Version: 3.0.4 (Ricochet)
Albums: 37
Photos: 298
MODPATH/g2_import/controllers/g2.php[ 60 ]
55 $g2_map = ORM::factory("g2_map") 56 ->merge_where($where) 57 ->find(); 58 59 if (!$g2_map->loaded()) { 60 throw new Kohana_404_Exception(); 61 } 62 63 $item = ORM::factory("item", $g2_map->g3_id); 64 if (!$item->loaded()) { 65 throw new Kohana_404_Exception();
{PHP internal call} » G2_Controller->map()
SYSPATH/core/Kohana.php[ 331 ] » ReflectionMethod->invokeArgs( arguments )
object
array(0)
args
array(0)
326
327 // Start the controller execution benchmark
328 Benchmark::start(SYSTEM_BENCHMARK.'_controller_execution');
329
330 // Execute the controller method
331 $method->invokeArgs($controller, $arguments);
332
333 // Controller method has been executed
334 Event::run('system.post_controller');
335
336 // Stop the controller execution benchmark
{PHP internal call} » Kohana_Core::instance( arguments )
0
NULL
SYSPATH/core/Event.php[ 208 ] » call_user_func_array( arguments )
function_name
array(2) (
0 => string(6) "Kohana"
1 => string(8) "instance"
)
parameters
array(1) (
0 => NULL
)
203 Event::$data =& $data;
204 $callbacks = Event::get($name);
205
206 foreach ($callbacks as $callback)
207 {
208 call_user_func_array($callback, array(&$data));
209 }
210
211 // Do this to prevent data from getting 'stuck'
212 $clear_data = '';
213 Event::$data =& $clear_data;
APPPATH/Bootstrap.php[ 67 ] » Event_Core::run( arguments )
name
string(14) "system.execute"
62
63// End system_initialization
64Benchmark::stop(SYSTEM_BENCHMARK.'_system_initialization');
65
66// Make the magic happen!
67Event::run('system.execute');
DOCROOT/index.php[ 113 ] » require( arguments )
Posts: 8339
This is not the preferred method.
View the docs on how to install.
And if you have a gallery3 question, please ask in the gallery3 forums where gallery3 users would be listening.
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
Sorry..
did not think re Gallery3 will post there
Gallery 2.3 will not restore...
I created a new database from the back up
renamed the backed up directory to gallery (Now gallery-bad)and changed the config.
I keep getting error messages
first bootstrap.inc
Fatal error: Call to undefined method Gallery::init() in /home/content/a/s/l/aslabjm/html/gallery-bad/bootstrap.inc on line 42
I replaced this bootstrap with the one from the install and it did not help
What am I looking for to fix this?
-------------------------------------------------------------
I am trying this will it work?
I am downloading a new miminal install 2.3. Will add the g2-data folder, modules and themes.
install it and point to the g2data folder per instructions on web to move to another server.
Is there anything in the g2-data folder that will put a hitch in this?
Thanks again.
Posts: 8339
again, make sure you are uploading the entire codebase.
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
All the files are there..Copied the entire file today on the server.
Just compared them to the ones on my computer.
At a loss as to what to do
Posts: 8339
first, there was no need to "restore" gallery2 after a failed gallery3 import.
Gallery3 import did not harm your gallery2.
Since I have no idea what you have done, maybe you need to restart from 2.1 and go through the process again from your original backups.
-s
All New jQuery Minislideshow for G2/G3
Posts: 42
I assumed that and did this - so glad you reinforced it.
I created a new database and imported the backed up database
Changed the config file to point to it.
Been going back and forth with error messages... has to be the server
Just know it flipped back and I have pulled it back in.
THANK YOU!!!
You do not know how much it means to have someone hanging in there with advise.
Tomorrow will tackle the G3 problem..