NYCPHP Meetup

[joomla] reconnect to mysql database

Scott Wolpow scott at wolpow.com
Wed Oct 6 16:57:33 EDT 2010


Paul,
Are they the same version of Joomla?
Do a fresh install with sample data. This way you know that install works.
Install the template you want.
Download the new configuration.php
Create a new empty DB
Upload the old db to this new DB
Change the configuration.php to match this new DB
That should work.
If not you have other issues. What type of hosting do you have?
If you look at the old db is the data there?
Scott Wolpow




On 10/6/2010 4:47 PM, Stephen Britton wrote:
> Paul. Please tell me what you are trying to do? Choose A or B or is it
> something else?
>
> A) Are you moving the Joomla website from one server to another server?
>
> B) Is the Joomla site on the same server and you moved it to a
> different part of the server or did you delete the old Joomla site and
> reinstalled a new one?
>
> I am assuming that you are trying to do A. If that is the case, here
> is a tutorial that worked for me. It's old, but PHPMyAdmin hasn't
> changed much in the past four years.
>
> http://www.howtojoomla.net/2006092518/how-tos/miscellaneous/how-to-export-your-joomla-database-with-phpmyadmin
>
>
>
> On Wed, Oct 6, 2010 at 4:36 PM, Paul Elliott
> <joomlanyc at upshotmagazine.com>  wrote:
>    
>> So how would i do it right?
>>
>> On Oct 6, 2010, at 4:32 PM, Stephen Britton wrote:
>>
>>      
>>> If you can't see the data in PHPAdmin than the data was not imported properly.
>>>
>>> Tell me more... Is this website on a different server from the old one?
>>>
>>> If you moved the site to a different server: How did you export the
>>> database from the previous server and how did you import it into the
>>> new one?
>>>
>>>
>>> On Wed, Oct 6, 2010 at 4:05 PM, Paul Elliott
>>> <joomlanyc at upshotmagazine.com>  wrote:
>>>        
>>>> I'm sure i could.
>>>> What options would those give?
>>>> I still see data missing in phpadmin
>>>> On Oct 6, 2010, at 3:47 PM, Helvécio da Silva wrote:
>>>>
>>>> Can you export the previous database again through PHPMyAdmin using REPLACE
>>>> or UPDATE under EXPORT TYPE?
>>>>
>>>> EXPORT TAB>  EXPORT TYPE>  REPLACE or UPDATE
>>>>
>>>> 2010/10/6 Paul Elliott<joomlanyc at upshotmagazine.com>
>>>>          
>>>>> I'm browsing bak_users in phpadmin, all i see is the super admin.
>>>>> When i first started working on this a few days ago, i did a new install
>>>>> and assigned it to the previous mysql database during install.
>>>>> Could that have erased any of the data?
>>>>> On Oct 6, 2010, at 1:15 PM, Donna Marie Vincent wrote:
>>>>>
>>>>> Isn't there a debugger that can be turned on that displays the sql query
>>>>> statements and results?
>>>>>
>>>>> ________________________________
>>>>> From: Paul Elliott<joomlanyc at upshotmagazine.com>
>>>>> To: NYPHP SIG: Joomla<joomla at lists.nyphp.org>
>>>>> Sent: Wed, October 6, 2010 12:54:26 PM
>>>>> Subject: Re: [joomla] reconnect to mysql database
>>>>>
>>>>> Helvécio,
>>>>> I followed your directions.
>>>>> After logging into the admin, i went to users.
>>>>> I dont see any of the names but the super admin.
>>>>>
>>>>> On Oct 6, 2010, at 9:15 AM, Helvécio da Silva wrote:
>>>>>
>>>>> Try this:
>>>>>
>>>>> 1. Do a clean install of Joomla (no sample data)
>>>>> 2. In PHPMyAdmin control panel, choose the database this new install is
>>>>> using
>>>>> 3. Go to the IMPORT tab, choose your previous database and upload it
>>>>> 4. That should do the trick! Previous members and passwords wil be there,
>>>>> as well as all the rest of the content.
>>>>>
>>>>> 2010/10/6 Paul Elliott<joomlanyc at upshotmagazine.com>
>>>>>            
>>>>>> Both front and back end.
>>>>>> No i dont see the articles.
>>>>>> Same template.
>>>>>> On Oct 6, 2010, at 8:45 AM, Donna Marie Vincent wrote:
>>>>>>
>>>>>> Where are you not seeing the old data, in the admin, on the public facing
>>>>>> side?  When you go into the list of articles in admin, do you see the old
>>>>>> articles?  Are you using a different template with a different layout?
>>>>>>
>>>>>> ________________________________
>>>>>> From: Paul Elliott<joomlanyc at upshotmagazine.com>
>>>>>> To: NYPHP SIG: Joomla<joomla at lists.nyphp.org>
>>>>>> Sent: Wed, October 6, 2010 8:33:30 AM
>>>>>> Subject: Re: [joomla] reconnect to mysql database
>>>>>>
>>>>>> Hi Donna,
>>>>>> I do still have the database used for the previous install.
>>>>>> The new install is set to it in configuration.php
>>>>>> The problem is that i still don't see any of the previous database
>>>>>> information on the new site.
>>>>>> On Oct 6, 2010, at 8:18 AM, Donna Marie Vincent wrote:
>>>>>>
>>>>>> In "configuration.php", you can set the db name, db password and db
>>>>>> username.  Set it to the database used for the previous install, assuming
>>>>>> you still have that info.  That info would be in the configuration.php file
>>>>>> of the previous install.
>>>>>>
>>>>>> If you don't have that info, you can open your webhosting control panel
>>>>>> and create another username and password for that database.
>>>>>>
>>>>>>
>>>>>> ________________________________
>>>>>> From: Paul Elliott<joomlanyc at upshotmagazine.com>
>>>>>> To: NYPHP SIG: Joomla<joomla at lists.nyphp.org>
>>>>>> Sent: Wed, October 6, 2010 8:08:57 AM
>>>>>> Subject: [joomla] reconnect to mysql database
>>>>>>
>>>>>> Hello,
>>>>>> I am trying to connect a new joomla installation to the mysql database of
>>>>>> a previous install.
>>>>>> The install was successful but i don't see any of the original data
>>>>>> after.
>>>>>> I even dragged content (i.e.- components, images, modules, plugins,
>>>>>> admin, etc.) from the previous install via ftp and none of it shows up.
>>>>>> Does anyone know how to connect to the content in the previous installs
>>>>>> mysql database?
>>>>>> Thanks,
>>>>>> Paul
>>>>>> _______________________________________________
>>>>>> New York PHP SIG: Joomla! Mailing List
>>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>>
>>>>>> NYPHPCon 2006 Presentations Online
>>>>>> http://www.nyphpcon.com/
>>>>>>
>>>>>> Show Your Participation in New York PHP
>>>>>> http://www.nyphp.org/show_participation.php
>>>>>> _______________________________________________
>>>>>> New York PHP SIG: Joomla! Mailing List
>>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>>
>>>>>> NYPHPCon 2006 Presentations Online
>>>>>> http://www.nyphpcon.com
>>>>>>
>>>>>> Show Your Participation in New York PHP
>>>>>> http://www.nyphp.org/show_participation.php
>>>>>>
>>>>>> _______________________________________________
>>>>>> New York PHP SIG: Joomla! Mailing List
>>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>>
>>>>>> NYPHPCon 2006 Presentations Online
>>>>>> http://www.nyphpcon.com
>>>>>>
>>>>>> Show Your Participation in New York PHP
>>>>>> http://www.nyphp.org/show_participation.php
>>>>>>
>>>>>> _______________________________________________
>>>>>> New York PHP SIG: Joomla! Mailing List
>>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>>
>>>>>> NYPHPCon 2006 Presentations Online
>>>>>> http://www.nyphpcon.com
>>>>>>
>>>>>> Show Your Participation in New York PHP
>>>>>> http://www.nyphp.org/show_participation.php
>>>>>>              
>>>>>
>>>>> --
>>>>> Helvecio "Elvis" da Silva
>>>>> Rio de Janeiro - Brasil - helvecio.rj at gmail.com
>>>>> http://www.helvecio.com/ - http://blog.helvecio.com/
>>>>>
>>>>> _______________________________________________
>>>>> New York PHP SIG: Joomla! Mailing List
>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>
>>>>> NYPHPCon 2006 Presentations Online
>>>>> http://www.nyphpcon.com
>>>>>
>>>>> Show Your Participation in New York PHP
>>>>> http://www.nyphp.org/show_participation.php
>>>>>
>>>>> _______________________________________________
>>>>> New York PHP SIG: Joomla! Mailing List
>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>
>>>>> NYPHPCon 2006 Presentations Online
>>>>> http://www.nyphpcon.com
>>>>>
>>>>> Show Your Participation in New York PHP
>>>>> http://www.nyphp.org/show_participation.php
>>>>>
>>>>> _______________________________________________
>>>>> New York PHP SIG: Joomla! Mailing List
>>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>>
>>>>> NYPHPCon 2006 Presentations Online
>>>>> http://www.nyphpcon.com
>>>>>
>>>>> Show Your Participation in New York PHP
>>>>> http://www.nyphp.org/show_participation.php
>>>>>            
>>>>
>>>> --
>>>> Helvecio "Elvis" da Silva
>>>> Rio de Janeiro - Brasil - helvecio.rj at gmail.com
>>>> http://www.helvecio.com - http://blog.helvecio.com
>>>>
>>>> _______________________________________________
>>>> New York PHP SIG: Joomla! Mailing List
>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>
>>>> NYPHPCon 2006 Presentations Online
>>>> http://www.nyphpcon.com
>>>>
>>>> Show Your Participation in New York PHP
>>>> http://www.nyphp.org/show_participation.php
>>>>
>>>> _______________________________________________
>>>> New York PHP SIG: Joomla! Mailing List
>>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>>
>>>> NYPHPCon 2006 Presentations Online
>>>> http://www.nyphpcon.com
>>>>
>>>> Show Your Participation in New York PHP
>>>> http://www.nyphp.org/show_participation.php
>>>>
>>>>          
>>>
>>> --
>>> Stephen Britton
>>> Technology Consultant
>>> sbritton at gmail.com
>>> ph: 914-661-0040
>>> _______________________________________________
>>> New York PHP SIG: Joomla! Mailing List
>>> http://lists.nyphp.org/mailman/listinfo/joomla
>>>
>>> NYPHPCon 2006 Presentations Online
>>> http://www.nyphpcon.com
>>>
>>> Show Your Participation in New York PHP
>>> http://www.nyphp.org/show_participation.php
>>>        
>> _______________________________________________
>> New York PHP SIG: Joomla! Mailing List
>> http://lists.nyphp.org/mailman/listinfo/joomla
>>
>> NYPHPCon 2006 Presentations Online
>> http://www.nyphpcon.com
>>
>> Show Your Participation in New York PHP
>> http://www.nyphp.org/show_participation.php
>>
>>      
>
>
>
>    

-- 
*Scott Wolpow*
*718.275.7765
Join me for Joomla Day Weekend
http://www.joomladaynyc.com*



More information about the Joomla mailing list