NYCPHP Meetup

[joomla] reconnect to mysql database

Stephen Britton steve at sbritton.com
Wed Oct 6 16:32:41 EDT 2010


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



More information about the Joomla mailing list